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)