test(2022913002)
Tables (7)
DEPARTMENT (Untitled3)
- Key (DeptID) — char(10) — Primary key — NOT NULL
- Key (LocationID) — char(10) — Foreign key → DEPARTMENT LOCATION.Key — NOT NULL
- Field (name) — char(20)
- Field (beginning Date) — int(6)
- Key (employeeID) — char(10) — Foreign key → EMPLOYEE.Key — NOT NULL
- Key (projectID) — char(10) — Foreign key → EMPLOYEE.Key — NOT NULL
DEPARTMENT LOCATION (Untitled4)
- Key (DeptID) — char(10) — Primary key — NOT NULL
- Key (LocationID) — char(10) — Primary key — NOT NULL
DEPENDENT (Untitled6)
- Key (dependentID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (gender) — int(1)
- birth — int(6)
- Field (relationship) — char(10)
- Key (employeeID) — char(10) — Foreign key → EMPLOYEE.Key — NOT NULL
- Key (projectID) — char(10) — Foreign key → EMPLOYEE.Key — NOT NULL
- Key (LocationID) — char(10) — Foreign key → EMPLOYEE.Key — NOT NULL
EMPLOYEE
- Key (employeeID) — char(10) — Primary key — NOT NULL
- Key (projectID) — char(10) — Foreign key → WORKSON.Key — NOT NULL
- Field (name) — char(20)
- Field (cell) — char(11)
- Field2 (address) — char(*)
- Field (birth) — int(6)
- Field (gender) — int(1)
- Key (departmentID) — char(10) — Foreign key → DEPARTMENT.Key — NOT NULL
- Key (LocationID) — char(10) — Foreign key → DEPARTMENT.Key — NOT NULL
LOCATION (Untitled5)
- Key (LocationID) — char(10) — Primary key — NOT NULL
- Key (DeptID) — char(10) — Foreign key → DEPARTMENT LOCATION.Key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(*)
PROJECT (Untitled2)
- Key (projectID) — char(10) — Foreign key → WORKSON.Key — NOT NULL
- Field (name) — char(*)
- Field2 (term) — char(*)
- Field (pay) — char(*)
- Field (departmentID) — char(10)
WORKSON (Untitled)
- Key (projectID) — char(10) — Primary key — NOT NULL
- Field (position) — char(*)
- Field (pay) — char(*)
- Field (participation) — char(3)
- Field (employeeID) — char(10)