2022_2(NGS)_박현철
테이블 (4)
EMPLOYEE
- Key (employeeNO) — char(8) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (phone) — char(11)
- Field (departmentID) — char(4)
- Field (sex) — char(6)
- Field (socialID) — char(13)
- Field (birthdate) — char(6)
- Key (deptID) — char(3) — 외래 키 → department.Key — NOT NULL
Untitled (project)
- Key (projectID) — char(100) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Key (deptID) — char(3) — 외래 키 → department.Key — NOT NULL
department
- Key (deptID) — char(3) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (phone) — char(11)
- Field (location) — char(20)
wokrson (workson)
- Key (woID) — char(10) — 기본 키 — NOT NULL
- Key (projectID) — char(100) — 외래 키 → Untitled.Key — NOT NULL
- Key (employeeNO) — char(8) — 외래 키 → EMPLOYEE.Key — NOT NULL