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