20220104_DS_SQR
Tables (7)
DEPARTMENT_LOCATION (Untitled4)
- departmentID (Key) — char(10) — Foreign key → Department.departmentID — NOT NULL
- locationID (Key2) — char(10) — Foreign key → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled5)
- dependentName (Key) — char(20) — Primary key — NOT NULL
- gender (Field) — char(1)
- birhtDate (Field2) — date
- relationship (Field3) — char(10)
- parent (Field4) — char(10)
- ssn (Field5) — char(14)
- employeeID (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL
Department (Untitled)
- departmentID (Key) — char(10) — Primary key — NOT NULL
- departmentName (Field) — char(20)
- manageStartDate (Field3) — date
- departmentManager (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL
EMPLOYEE (Untitled3)
- employeeID (Key) — char(10) — Primary key — NOT NULL
- employeeName (Field) — char(30)
- ssn (Field2) — char(14)
- salary (Field3) — integer
- gender (Field4) — char(1)
- birthDate (Field5) — date
- project (Field6) — char(10)
- departmentID (Key2) — char(10) — Foreign key → Department.departmentID — NOT NULL
LOCATION (Untitled2)
- locationID (Key) — char(10) — Primary key — NOT NULL
- locationName (Field) — char(20)
- phone (Field2) — char(20)
- fax (Field3) — char(20)
PROJECT (Untitled6)
- projNO (Key) — integer — Primary key — NOT NULL
- name (Field) — char(20)
- location (Field2) — char(20)
- controllingDepartment (Field3) — char(20)
- departmentID (Key2) — char(10) — Foreign key → Department.departmentID — NOT NULL
WORKSON (Untitled7)
- ssn (Key) — char(14) — Primary key — NOT NULL
- projNo (Field) — integer
- hours (Field2) — char(20)
- employeeID (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL
- projNO (Key3) — integer — Foreign key → PROJECT.projNO — NOT NULL