es0(2)
Tables (4)
DEPARTMENT (Untitled)
- departmentId (Key) — char(4) — Primary key — NOT NULL
- departmentName (Field) — char(20)
- departmentManager (Field2) — char(30)
- manareStarDate (Field3) — date
EMPLOYEE (Untitled3)
- employeeId (Key) — char(5) — Primary key — NOT NULL
- name (Field) — char(30)
- birthdate (Field2) — date
- phone (Field3) — char(11)
- departmentId (Key2) — char(4) — Foreign key → DEPARTMENT.departmentId — NOT NULL
PROJECT (Untitled2)
- projectId (Key) — char(10) — Primary key — NOT NULL
- projectName (Field) — char(30)
- description (Field2) — text
- departmentId (Key2) — char(4) — Foreign key → DEPARTMENT.departmentId — NOT NULL
WORKSON (Untitled4)
- worksonId (Key2) — Primary key — NOT NULL
- projectId (Key) — char(10) — Foreign key → PROJECT.projectId — NOT NULL
- employeeId (Key3) — char(5) — Foreign key → EMPLOYEE.employeeId — NOT NULL