ERD 예제 0
테이블 (4)
Department (Untitled)
- departmentId (Key) — char(4) — 기본 키 — NOT NULL
- departmentName (Field) — char(20)
- departManager (Field2) — char(30)
- manageStartDate (Field3) — date
Employee (Untitled2)
- employeeId (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(30)
- birthdate (Field2) — date
- departmentId (Key2) — char(4) — 외래 키 → Department.departmentId — NOT NULL
PROJECT (Untitled3)
- projectId (Key) — char(10) — 기본 키 — NOT NULL
- projectName (Field) — char(30)
- description (Field2) — text
- departmentId (Key2) — char(4) — 외래 키 → Department.departmentId — NOT NULL
WORKSON (Untitled4)
- worksonId (Key3) — char(10) — 기본 키 — NOT NULL
- projectId (Key) — char(10) — 외래 키 → PROJECT.projectId — NOT NULL
- employeeId (Key2) — char(5) — 외래 키 → Employee.employeeId — NOT NULL