sample이명건

테이블 (5)

DEPARTMENT (Untitled2)

  • dept\No (Key) — char(15) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • location (Field2) — char(15)
  • manager (Field3) — char(5)
  • managerStartdate (Field4) — char(10)
  • ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL

DEPENDENT (Untitled4)

  • dependentName (Key) — char(15) — 기본 키 — NOT NULL
  • gender (Field) — char(4)
  • birthdate (Field2) — date
  • relationship (Field3) — char(15)
  • parent (Field4) — char(15)
  • supervisor (Field5) — char(15)
  • ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled)

  • ssn (Key) — char(14) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • gender (Field2) — char(4)
  • address (Field3) — char(50)
  • salary (Field4) — char(10)
  • birthdate (Field5) — date
  • dept (Field6) — char(10)
  • dept\No (Key2) — char(15) — 외래 키 → DEPARTMENT.dept\No — NOT NULL

PROJECT (Untitled3)

  • projNo (Key) — char(20) — 기본 키 — NOT NULL
  • name (Field) — char(20)
  • location (Field2) — char(15)
  • controllingDept (Field3) — char(15)
  • dept\No (Key2) — char(15) — 외래 키 → DEPARTMENT.dept\No — NOT NULL

workson (Untitled5)

  • woID (Key) — 기본 키 — NOT NULL
  • Field
  • ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
  • projNo (Key3) — char(20) — 외래 키 → PROJECT.projNo — NOT NULL