2023_webDB_ex0
Tables (5)
DEPARTMENT
- depNo — int — Primary key — NOT NULL
- depName — char(30)
- managerNo — int
- manageStartDate (managerStartDate) — date
- Field (location) — char(30)
- ssn (managerSsn) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE
- ssn — char(14) — Primary key — NOT NULL
- empName — char(50)
- address — char(70)
- manageDeaprtment (salary) — int
- Field4 (birthDate) — date
- gender — char(1)
- proNo (superviser) — char(14)
- depNo — int — Foreign key → DEPARTMENT.depNo — NOT NULL
PROJECT
- proNo — int — Primary key — NOT NULL
- proName — char(30)
- description — text
- manageDeaprtment (manageDaprtment) — int
Untitled (DEPENDENT)
- Key (dependentNo) — int — Primary key — NOT NULL
- Field (dependentName) — char(50)
- Field (gender) — char(1)
- Field (birthDate) — date
- Field (ssn) — char(14)
- Field (relation) — char(20)
- ssn (ssn2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
Untitled (WORKSON)
- Key (workNo) — int — Primary key — NOT NULL
- ssn — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
- proNo — int — Foreign key → PROJECT.proNo — NOT NULL