차세대

테이블 (5)

department (Untitled4)

  • department (Key) — char(100) — 기본 키 — NOT NULL
  • gender (Field) — char(6)
  • brithday (Field2) — char(8)
  • relationship (Field3) — char(10)
  • parent (Field4) — char(2)
  • ssn (Field5) — char(10)
  • Field6
  • projno (Key2) — char(100) — 외래 키 → project.projno — NOT NULL

dependent (Untitled2)

  • daptno (Key2) — char(10) — 기본 키 — NOT NULL
  • manager (Field2) — char(10)
  • managerstartdate (Field3) — char(8)
  • name (Key) — char(10) — NOT NULL

employee (Untitled)

  • ssn (Key2) — char(100) — 기본 키 — NOT NULL
  • number (Field) — char(13)
  • address (Field2) — char(100)
  • salary (Field3) — char(7)
  • gender (Field4) — char(6)
  • brithdate (Field5) — char(8)
  • name (Key) — char(10) — NOT NULL
  • supervisor (Field6) — char(20)
  • works-on (Field7) — char(100)
  • department (Key3) — char(100) — 외래 키 → department.department — NOT NULL
  • projno (Key4) — char(100) — 외래 키 → project.projno — NOT NULL
  • daptno (Key22) — char(10) — 외래 키 → dependent.daptno — NOT NULL

project (Untitled3)

  • projno (Key) — char(100) — 기본 키 — NOT NULL
  • name (Field) — char(100)
  • controllingdepartment (Field2) — char(100)
  • Field3

works-on (Untitled5)

  • ssn (Key) — char(10) — 기본 키 — NOT NULL
  • projno (Field) — char(100)
  • hours (Field2) — char(100)
  • Field3