ex_0(20-21)
Tables (7)
DEPARTMENT (Untitled)
- departmertId (Key) — char(4) — Primary key — NOT NULL
- departmentName (Field) — char(20)
- departmentManager (Field2) — char(30)
- mangeStartDate (Field3) — date
- employeeId (Key2) — char(5) — Foreign key → EMPLOYEE.employeeId — NOT NULL
DEPARTMENT_LOCATION (Untitled7)
- departmertId (Key) — char(4) — Foreign key → DEPARTMENT.departmertId — NOT NULL
- lokationId (Key2) — char(3) — Foreign key → LOCATION.lokationId — NOT NULL
DEPENDENT (Untitled5)
- dependentId (Key) — char(10) — Primary key — NOT NULL
- dependentName (Field) — char(30)
- ssn (Field2) — char(15)
- gender (Field3) — char(1)
- birthdate (Field4) — date
- relation (Field5) — char(10)
- employeeId (Key2) — char(5) — Foreign key → EMPLOYEE.employeeId — NOT NULL
EMPLOYEE (Untitled2)
- employeeId (Key) — char(5) — Primary key — NOT NULL
- departmentId (Field4) — char(4)
- name (Field) — char(30)
- birthdate (Field2) — date
- Phone (Field3) — char(11)
- departmertId (Key2) — char(4) — Foreign key → DEPARTMENT.departmertId — NOT NULL
- departmertId (Key3) — char(4) — Foreign key → DEPARTMENT.departmertId — NOT NULL
- departmertId (Key4) — char(4) — Foreign key → DEPARTMENT.departmertId — NOT NULL
LOCATION (Untitled6)
- lokationId (Key) — char(3) — Primary key — NOT NULL
- locationName (Field) — char(20)
- description (Field2) — text
PROJECT (Untitled3)
- projectId (Key) — char(10) — Primary key — NOT NULL
- projectname (Field) — char(30)
- description (Field2) — text
- departmertId (Key2) — char(4) — Foreign key → DEPARTMENT.departmertId — NOT NULL
WORKSON (Untitled4)
- worksonId (Key3) — char(10) — Primary key — NOT NULL
- projectId (Key) — char(10) — Foreign key → PROJECT.projectId — NOT NULL
- employeeId (Key2) — char(5) — Foreign key → EMPLOYEE.employeeId — NOT NULL