2024_1_과제황석산

테이블 (7)

DEPARTMENT

  • departmentID (deptNo) — char(20) — 기본 키 — NOT NULL
  • Field (deptName) — char(10)
  • Field (managerID) — char(20)
  • Field (managerStartDate) — date
  • Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL
  • Key (locID) — char(4) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (projNo) — char(4) — 기본 키 — NOT NULL
  • Field (poojName) — char(10)
  • Field (controllinDeparment) — char(10)
  • departmentID (deptNo) — char(20) — 외래 키 → DEPARTMENT.departmentID — NOT NULL
  • Key (projNo2) — char(4) — 외래 키 → Untitled.Key — NOT NULL

Untitled (LOCATION)

  • Key (locID) — char(4) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Key (locID2) — char(4) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEP_LOC)

  • Key (locID) — char(4) — 기본 키 — NOT NULL
  • Field (depNo) — char(20)
  • Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL

Untitled (EMPLOYEE)

  • Key (employeeNo) — char(10) — 기본 키 — NOT NULL
  • Key (familyNO) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (employName) — char(10)
  • Field (employeeBirth) — date
  • Field (employAdrres) — char(30)
  • departmentID (deptNo) — char(20) — 외래 키 → DEPARTMENT.departmentID — NOT NULL

Untitled (EMP_FAMILY)

  • Key (familyNO) — char(10) — 기본 키 — NOT NULL
  • Field (familyName) — char(10)
  • Field (familySex) — char(3)
  • Field (familyBirth) — date

Untitled (PROJECT_EMP)

  • Key (employeeNo) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (familyNO) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (projNo) — char(4) — 외래 키 → Untitled.Key — NOT NULL