차세대
테이블 (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