ERD Exercise 0(여영규)
테이블 (7)
DEPARTMENT (Untitled3)
- departmentId (Key) — char(4) — 기본 키 — NOT NULL
- departmentName (Field) — char(30)
- departmentManager (Field2) — char(30)
- managerStartDate (Field3) — date
- employeeid (Key2) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL
DEPART_LOC (Untitled6)
- depNO (Key) — integer — 기본 키 — NOT NULL
- departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
- locNo (Key3) — integer — 외래 키 → LOCATION.locNo — NOT NULL
- LocNo (Field) — integer
DEPENDENT (Untitled2)
- dependentid (Key) — char(10) — 기본 키 — NOT NULL
- dependentName (Field) — char(10)
- gender (Field2) — char(5)
- birthdate (Field3) — date
- relation (Field4) — char(10)
- employeeid (Key2) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL
EMPLOYEE (Untitled)
- employeeid (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthdate (Field2) — date
- address (Field3) — char(30)
- salary (Field4) — char(10)
- gender (Field5) — char(5)
- departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
LOCATION (Untitled7)
- locNo (Key) — integer — 기본 키 — NOT NULL
- locName (Field) — char(100)
- phone (Field2) — char(15)
- address (Field3) — char(100)
PROJECT (Untitled4)
- projectIde (Key) — char(10) — 기본 키 — NOT NULL
- projectName (Field) — char(30)
- description (Field2) — text
- departmentId (Key2) — char(4) — 외래 키 → DEPARTMENT.departmentId — NOT NULL
WORKSON (Untitled5)
- worksonId (Key) — char(10) — 기본 키 — NOT NULL
- projectIde (Key2) — char(10) — 외래 키 → PROJECT.projectIde — NOT NULL
- employeeid (Key3) — char(5) — 외래 키 → EMPLOYEE.employeeid — NOT NULL