5주차
테이블 (5)
DEPARTMENT (Untitled2)
- deptID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field)
- mgrstartdate (Field3)
- ssn (Key2) — INT — 외래 키 → EMPLOYEE.empID — NOT NULL
- description (Field2) — text
- Field4
DEPENDENT (Untitled5)
- dpendID (Key) — char(10) — 기본 키 — NOT NULL
- dpendName (Field) — char(30)
- birthdate (Field2) — date
- gender (Field3) — char(1)
- relationship (Field4) — char(10)
- ssn (Key2) — INT — 외래 키 → EMPLOYEE.empID — NOT NULL
EMPLOYEE (Untitled)
- empID (Key) — char(10) — 기본 키 — NOT NULL
- name (Field2) — char(30)
- phone (Field) — char(11)
- bdate (Field4) — date
- address (Field5)
- gen (Field6)
- dno (Key2) — 외래 키 → DEPARTMENT.deptID — NOT NULL
PROJECT (Untitled3)
- proID (Key) — 기본 키 — NOT NULL
- pname (Field)
- plocation (Field2)
- dno (Field3)
WORKSON (Untitled4)
- ssn (Key) — 기본 키 — NOT NULL
- proID (Key2) — int(6) — 기본 키 — NOT NULL
- hoursperweek (Field) — float
- ssn (Key3) — INT — 외래 키 → EMPLOYEE.empID — NOT NULL
- pno (Key4) — 외래 키 → PROJECT.proID — NOT NULL