Practice
Tables (7)
DEPARTMENT (Untitled)
- departmentID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- phone (Field2) — char(20)
- email (Field3) — email
- manager (Field4) — char(10)
- managerStartDate (Field5) — date
- location (Field6) — char(30)
- ssn (Key2) — char(20) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPARTMENT_LOCATION (Untitled7)
- departmentID (Key) — char(10) — Foreign key → DEPARTMENT.departmentID — NOT NULL
- locationID (Key2) — char(3) — Foreign key → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled4)
- dependentID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- gender (Field2) — char(1)
- birthDate (Field3) — date
- relationship (Field4) — char(10)
- ssn (Field5) — char(12)
- employeeSsn (Key2) — char(20) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled2)
- ssn (Key) — char(20) — Primary key — NOT NULL
- name (Field) — char(30)
- adress (Field2) — char(50)
- email (Field3) — email
- phone (Field4) — char(12)
- departmentID (Key2) — char(10) — Foreign key → DEPARTMENT.departmentID — NOT NULL
LOCATION (Untitled6)
- locationID (Key) — char(3) — Primary key — NOT NULL
- locationName (Field) — char(20)
- description (Field2) — text
PROJECT (Untitled3)
- projectID (Key) — char(20) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — longtext
WORKSON (Untitled5)
- ssn (Key) — char(20) — Foreign key → EMPLOYEE.ssn — NOT NULL
- projectID (Key2) — char(20) — Foreign key → PROJECT.projectID — NOT NULL
- hour (Field) — float