e0
Tables (7)
DEPARTEMENT (Untitled2)
- departmentld (Key) — char(4) — Primary key — NOT NULL
- employeeld (Key2) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
- departmentld (Key22) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
- employeeld (Key222) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
- departmentName (Field) — char(20)
- departManager (Field2) — cjar(30)
- manageStartDate (Field3) — date
DEPARTMENT_LOCATION (Untitled3)
- departmentid (Key) — char(4) — Primary key — NOT NULL
- locationID (Key2) — char(3) — Primary key — NOT NULL
- departmentld (Key3) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
- employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
- departmentld (Key222) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
- employeeld (Key2222) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
- locationID (Key4) — char(3) — Foreign key → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled)
- dependentld (Key) — char(10) — Primary key — NOT NULL
- employeeld (Key2) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
- departmentld (Key22) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
- employeeld (Key222) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
- dependentName (Field) — char(30)
- ssn (Field2) — char(15)
- gemder (Field3) — char(1)
- birthment (Field4) — date
- relation (Field5)
EMPLOYEE (Untitled4)
- employeeld (Key) — char(5) — Primary key — NOT NULL
- departmentld (Key2) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
- employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
- name (Field) — char(30)
- birtdate (Field2) — date
- phone (Field3) — char(11)
- departmentld (Field4) — char(4)
LOCATION (Untitled6)
- locationID (Key) — char(3) — Primary key — NOT NULL
- locationName (Field) — char(20)
- descrlption (Field2) — text
WORKSON (Untitled7)
- worksonld (Key) — char(10) — Primary key — NOT NULL
- projectid (Key2) — char(10) — Foreign key → project.projectid — NOT NULL
- departmentld (Key22) — char(4) — Foreign key → project.departmentld — NOT NULL
- employeeld (Key222) — char(5) — Foreign key → project.employeeld — NOT NULL
- departmentld (Key2222) — char(4) — Foreign key → project.departmentld — NOT NULL
- employeeld (Key22222) — char(5) — Foreign key → project.employeeld — NOT NULL
- employeeld (Key3) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
- departmentld (Key23) — char(4) — Foreign key → EMPLOYEE.departmentld — NOT NULL
- employeeld (Key223) — char(5) — Foreign key → EMPLOYEE.employeeld — NOT NULL
project (Untitled5)
- projectid (Key) — char(10) — Primary key — NOT NULL
- departmentld (Key2) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
- employeeld (Key22) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
- departmentld (Key222) — char(4) — Foreign key → DEPARTEMENT.departmentld — NOT NULL
- employeeld (Key2222) — char(5) — Foreign key → DEPARTEMENT.employeeld — NOT NULL
- projectName (Field) — char(30)
- description (Field2) — text