연습1
테이블 (5)
DEPENDENT (Untitled4)
- dependentno (Key) — int — 기본 키 — NOT NULL
- dependentname (Field) — char(50)
- gender (Field2) — char
- birthdate (Field3) — char(14)
- relation (Field4) — char(20)
EMPLOYEE (Untitled3)
- ssn (Key) — char(14) — 기본 키 — NOT NULL
- empname (Field2) — char(50)
- address (Field3) — char(70)
- salary (Field4) — int
- birthdate (Field5) — date
- gender (Field6) — char(1)
- supervisor (Field7) — char(14)
- depeo (Field8) — int
- depeNo (Key2) — int — 외래 키 → 도시.depeNo — NOT NULL
WORKSON (Untitled5)
- wono (Key) — int — 기본 키 — NOT NULL
- ssn (Field) — char(14)
- proNo (Field2) — int
- proNo (Field3)
- prono (Key2) — int — 외래 키 → project.prono — NOT NULL
- ssn (Key3) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
project (Untitled2)
- prono (Key) — int — 기본 키 — NOT NULL
- proname (Field2) — char50
- description (Field3) — text
- managedepartment (Field4) — int
도시 (Untitled)
- depeNo (Key) — int — 기본 키 — NOT NULL
- depname (Field2) — char(30)
- managerno (Field3) — int
- managestartdate (Field4) — date
- location (Field5) — char(30)
- ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL