5주차과제
테이블 (5)
DEPARTMENT (Untitled2)
- deptID (Key) — int — 기본 키 — NOT NULL
- name (Field) — char(15)
- email (Field2) — char(20)
- phone (Field3) — char(15)
- description (Field4) — text
- manageStartDate (Field5) — date
- managerID (Key2) — int — 외래 키 → EMPLOYEE.empID — NOT NULL
DEPENDENT (Untitled4)
- dependentID (Key) — int — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthDate (Field2) — date
- description (Field3) — text
- empID (Key2) — int — 외래 키 → EMPLOYEE.empID — NOT NULL
EMPLOYEE (Untitled)
- empID (Key) — int — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthDate (Field2) — date
- address (Field3) — varchar(50)
- phone (Field4) — char(11)
ON_PROJECT (Untitled5)
- empID (Key) — int — 외래 키 → EMPLOYEE.empID — NOT NULL
- projID (Key2) — int — 외래 키 → PROJECT.projID — NOT NULL
- timePerWeek (Field) — float
PROJECT (Untitled3)
- projID (Key) — int — 기본 키 — NOT NULL
- name (Field) — char(30)
- description (Field2) — text