2023
Tables (5)
DEPARTMENT (Untitled)
- depNO (Key) — int — Primary key — NOT NULL
- depName (Field) — char(30)
- managerNO (Field2) — int
- manageStartDate (Field3) — date
- location (Field4) — char(30)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPENDENT (Untitled4)
- dependentNO (Key) — int — Primary key — NOT NULL
- dependetName (Field) — char(50)
- gender (Field2) — char(1)
- birthDate (Field3) — date
- ssn (Field4) — char(14)
- relation (Field5) — char(20)
- ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled3)
- ssn (Key) — char(14) — Primary key — NOT NULL
- empName (Field) — char(50)
- address (Field2) — char(70)
- salary (Field3) — int
- birthDate (Field4) — date
- gender (Field5) — char(1)
- supervisor (Field6) — char(14)
- depNO (Key2) — int — Foreign key → DEPARTMENT.depNO — NOT NULL
PROJECT (Untitled2)
- proNO (Key) — int — Primary key — NOT NULL
- proNAME (Field) — char(50)
- desaription (Field2) — text
- manageDepartment (Field3) — int
WORKSON (CopyOfUntitled5)
- woNO (Key3) — int — Primary key — NOT NULL
- ssn (Key) — char(14) — Foreign key → PROJECT.proNO — NOT NULL
- proNO (Key2) — int — Foreign key → EMPLOYEE.ssn — NOT NULL