sample이명건
테이블 (5)
DEPARTMENT (Untitled2)
- dept\No (Key) — char(15) — 기본 키 — NOT NULL
- name (Field) — char(20)
- location (Field2) — char(15)
- manager (Field3) — char(5)
- managerStartdate (Field4) — char(10)
- ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled4)
- dependentName (Key) — char(15) — 기본 키 — NOT NULL
- gender (Field) — char(4)
- birthdate (Field2) — date
- relationship (Field3) — char(15)
- parent (Field4) — char(15)
- supervisor (Field5) — char(15)
- ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled)
- ssn (Key) — char(14) — 기본 키 — NOT NULL
- name (Field) — char(20)
- gender (Field2) — char(4)
- address (Field3) — char(50)
- salary (Field4) — char(10)
- birthdate (Field5) — date
- dept (Field6) — char(10)
- dept\No (Key2) — char(15) — 외래 키 → DEPARTMENT.dept\No — NOT NULL
PROJECT (Untitled3)
- projNo (Key) — char(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- location (Field2) — char(15)
- controllingDept (Field3) — char(15)
- dept\No (Key2) — char(15) — 외래 키 → DEPARTMENT.dept\No — NOT NULL
workson (Untitled5)
- woID (Key) — 기본 키 — NOT NULL
- Field
- ssn (Key2) — char(14) — 외래 키 → EMPLOYEE.ssn — NOT NULL
- projNo (Key3) — char(20) — 외래 키 → PROJECT.projNo — NOT NULL