서유민_2021913016
테이블 (7)
DEPARTMENT (department)
- Key (depNo) — integer — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (phone) — char(20)
- Field (fax) — char(20)
- Field (startDate) — date
- Key (employNo) — integer — 외래 키 → EMPLOYEE.Key — NOT NULL
DEPART_LOC
- Key (depNo) — integer — 외래 키 → DEPARTMENT.Key — NOT NULL
- locNo — integer — 외래 키 → LOCATION.locNo — NOT NULL
EMPLOYEE (employee)
- Key (employNo) — integer — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (email) — char(20)
- Field (phone) — char(20)
- Key (depNo) — integer — 외래 키 → DEPARTMENT.Key — NOT NULL
- Key (supvisorNo) — integer — 외래 키 → EMPLOYEE.Key — NOT NULL
LOCATION
- locNo — integer — 기본 키 — NOT NULL
- lacName (locName) — char(100)
- phone — char(15)
- address — char(100)
PROJECT (project)
- Key (proNo) — integer — 기본 키 — NOT NULL
- Field (proName) — char(20)
- Field (description) — text
- Key (depNo) — integer — 외래 키 → DEPARTMENT.Key — NOT NULL
Untitled (WORKS_ON)
- Key (woNo) — integer — 기본 키 — NOT NULL
- Key (employNo) — integer — 외래 키 → EMPLOYEE.Key — NOT NULL
- Key (proNo) — integer — 외래 키 → PROJECT.Key — NOT NULL
- Field (hours) — float
- Field (yearmonth) — char(10)
Untitled (DEPENDANT)
- Key (depNo) — integer — 기본 키 — NOT NULL
- Field (depName) — char(20)
- Field (age) — integer
- Field (birthDate) — date
- Field (relation) — char(20)
- Key (employNo) — integer — 외래 키 → EMPLOYEE.Key — NOT NULL