2024_1_report00

Tables (7)

DEPARTMENT (Department)

  • Key (depID) — char(4) — Primary key — NOT NULL
  • Field (depName) — char(20)
  • Field2 (manageStarDate) — date
  • Field (empID) — char(10)
  • Key (empID2) — char(20) — Foreign key → EMPLOYEE.Key — NOT NULL

DEPENDENT

  • Key (depnID) — char(11) — Primary key — NOT NULL
  • Field (depngender) — char(20)
  • Field (gender) — char(1)
  • Field (emplID) — char(20)
  • Key (empID) — char(20) — Foreign key → EMPLOYEE.Key — NOT NULL

DEP_LOC (DeparttmentLocation)

  • Key (depID) — char(4) — Foreign key → DEPARTMENT.Key — NOT NULL
  • Key (locID) — char(4) — Foreign key → LOCATION.Key — NOT NULL

EMPLOYEE (Employee)

  • Key (empID) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (birthdate) — date
  • Field (gender) — char(1)
  • Field (phone) — char(11)
  • Key (depID) — char(4) — Foreign key → DEPARTMENT.Key — NOT NULL

LOCATION (Location)

  • Key (locID) — char(4) — Primary key — NOT NULL
  • Field (locName) — char(20)
  • Field (phone) — char(10)

PROJECT (Project)

  • Key (proID) — char(20) — Primary key — NOT NULL
  • Field (proName) — char(20)
  • Field (depTeam) — team
  • Field (depID) — char(4)
  • Key (depID2) — char(4) — Foreign key → DEPARTMENT.Key — NOT NULL

PROJECT_EMP (Employee_project)

  • Key (proID) — char(20) — Foreign key → PROJECT.Key — NOT NULL
  • Key (empID) — char(20) — Foreign key → EMPLOYEE.Key — NOT NULL
  • Field (hours) — float
  • Field (role) — char(30)