2024_0402_1

Tables (7)

Untitled (EMPLOYEE)

  • Key (EmpID) — char(10) — Primary key — NOT NULL
  • (Name) — char(20)
  • Field (BirthDate) — date
  • Field (Gender) — char(1)
  • Field (Phone) — char(11)
  • Field (DeptNo) — char(10)
  • Key (DepID) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMNET)

  • Key (DepID) — char(10) — Primary key — NOT NULL
  • Field (DepName) — char(20)
  • Field (ManageStartDate) — date
  • Key (EmpID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (ProID) — char(10) — Primary key — NOT NULL
  • (ProName) — char(30)
  • Field2 (manager) — char(10)
  • Field (employee) — char(10)
  • Field (description) — test
  • Key (ManagerDepID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEP-LOCATION)

  • Key (DepID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (LocID) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (Employee_Project)

  • Key (EmpID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (ProID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (hours) — float — NOT NULL
  • Field (role) — char(30)

Untitled (LOCATION)

  • Key (LocID) — char(4) — Primary key — NOT NULL
  • Field (LocName) — char(30)

Untitled (DEPENDENT)

  • Key (DenpenID) — char(11) — Primary key — NOT NULL
  • Field (DenpenName) — char(20)
  • Field (Gender) — char(1)
  • Field (BrithDate) — date
  • Key (EmpID) — char(10) — Foreign key → Untitled.Key — NOT NULL