2023사서교육원예제

테이블 (5)

DEPARTMENT

  • Key (DeptId) — int — 기본 키 — NOT NULL
  • Field (DeptName) — char(30)
  • Field2 (DeptLocation) — char(30)
  • Field (DeptManagerStartDate) — date
  • Key (ManagerEmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL

PROJECT

  • Key (ProjNo) — int — 기본 키 — NOT NULL
  • Field (ProjName) — char(30)
  • Key (ManageDeptId) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (EmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (DependentSSN) — char(14) — 기본 키 — NOT NULL
  • Field (DependentName) — char(30)
  • Field2 (DependentGender) — char(30)
  • Field3 (DependentBirthDate) — date
  • Field4 (DependentRelationship) — char(30)
  • Key (EmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL

Untitled (WORKS-ON)

  • Key (EmpSSN2) — char(14) — 외래 키 → Untitled2.Key — NOT NULL
  • Key (ProjNo2) — int — 외래 키 → PROJECT.Key — NOT NULL
  • Field2 (HoursPerWeek) — float

Untitled2 (EMPLOYEE)

  • Key (EmpSSN) — char(14) — 기본 키 — NOT NULL
  • Field (EmpName) — char(30)
  • Field (EmpGender) — char(30)
  • Field (EmpAddress) — char(99)
  • Field2 (EmpSalary) — int
  • Field (EmpBirthDate) — date
  • Field (EmpSupervisor) — char(30)
  • Field (EmpWorksOn) — char(30)
  • Key (WorksForDeptId) — int — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (ProjNo) — int — 외래 키 → PROJECT.Key — NOT NULL
  • Key (superVEmpSSN) — char(14) — 외래 키 → Untitled2.Key — NOT NULL