예제 ERD
테이블 (5)
DEPARTMENT
- deptNo — int(10) — 기본 키 — NOT NULL
- manager (name) — char(30)
- managerStartDate (manager) — char(30)
- Field (managerStartDate) — date
- ssn — 외래 키 → EMPLOYEE.ssn — NOT NULL
- Key (proNo) — int(20) — 외래 키 → Untitled.Key — NOT NULL
EMPLOYEE
- ssn — 기본 키 — NOT NULL
- name — char(30)
- gender
- address
- salary
- birthDate
- Field6 (department)
- Field (supervisor)
- Field (worksOn)
- deptNo — int(10) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
- Key (SSN) — 외래 키 → Untitled.Key — NOT NULL
- Key (dependentName) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- ssn (ssn2) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- ssn (ssn3) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- ssn (ssn4) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- ssn (ssn5) — 외래 키 → EMPLOYEE.ssn — NOT NULL
Untitled (PROJECT)
- Key (proNo) — int(20) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (location)
- Field (controllingDepartment)
- deptNo — int(10) — 외래 키 → DEPARTMENT.deptNo — NOT NULL
- Key (SSN) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WORKSON)
- Key (SSN) — 기본 키 — NOT NULL
- Field (proNo) — int(20)
- Field2 (hours) — float
- ssn — 외래 키 → EMPLOYEE.ssn — NOT NULL
- Key (proNo2) — int(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DEPENDENT)
- Key (dependentName) — char(20) — 기본 키 — NOT NULL
- Field (gender)
- Field (birthDate) — date
- Field (relationship)
- Field (parent)
- Field (ssn)
- ssn (ssn2) — 외래 키 → EMPLOYEE.ssn — NOT NULL