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)