2022913021

Tables (9)

Employee

  • Key (ssn) — char(10) — Primary key — NOT NULL
  • Key (SupervisorID) — char(10) — Foreign key → Employee.Key — NOT NULL
  • Key (departmentNO) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char(20)
  • Field (gender) — integer(1)
  • Field (paymant) — char(20)
  • Field (address) — char(30)
  • Field (birth_date) — integer(8)

Untitled (Department)

  • Key (departmentNO) — char(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (start_date) — integer(8)
  • Key (manager_employeeID) — char(10) — Foreign key → Employee.Key — NOT NULL

Untitled (Project)

  • Key (projcet_name) — char(20) — Primary key — NOT NULL
  • Field (ProjectNO) — char(20)
  • Field (departmentNO) — char(20)

Untitled (Familly)

  • Key (departmentID) — char(10) — Primary key — NOT NULL
  • Field (gender) — integer(1)
  • Field (birth_date) — integer(8)
  • Field (name) — char(20)
  • Field (dmployee_relation) — char(20)
  • Key (ssn_employee) — char(10) — Foreign key → Employee.Key — NOT NULL

Untitled (Workson)

  • Key (projcet_name) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn) — char(10) — Foreign key → Employee.Key — NOT NULL
  • Field (hours) — float

Untitled (Component)

  • Key (componentID) — char(10) — Primary key — NOT NULL
  • Field (explain) — char(20)
  • Key (ProducterID) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Producter)

  • Key (ProducterID) — char(10) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (address) — char(30)
  • Field (phone) — char(15)

Untitled (Procuct_Component)

  • Key (productID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (componentID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (component_number) — integer(5)

Untitled (Product)

  • Key (productID) — char(10) — Primary key — NOT NULL
  • Field (expain) — char(20
  • Field (price) — integer(10)