20240930
Tables (4)
Untitled (EMPLOYEE)
- Key (employeeID) — char(10) — Primary key — NOT NULL
- Field (NRRN) — char(13)
- Field (name) — char(10)
- Field (gender) — char(1)
- Field (birthDate) — char(8)
- Field (address) — char(30)
- Field (phone) — char(11)
- Field (salary) — int(10)
- Field (manageDepartment) — char(3)
- Key (departmentID) — char(4) — Foreign key → Untitled.Key — NOT NULL
- Key (ptojectID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ptojectID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (dependentsNRRN) — char(13 — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (departmentID) — char(4) — Primary key — NOT NULL
- Field (departmentName) — char(8)
- Field (managerID) — char(10)
- Field (managerName) — char(10)
- Field (startDate) — char(8)
- Field (departmentLocation) — char(30)
- Field (assignDepartment) — char(10)
- Field (employeeID) — char(10)
- Key (employeeID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (ptojectID) — char(10) — Primary key — NOT NULL
- Field (projectName) — char(20)
- Field (managementDepartment) — char(8)
- Field (workweek) — char(4)
- Field (immediateSuperior) — char(10)
- Field (managementDepartmentID) — char(10)
- Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPENDENTS)
- Key (dependentsNRRN) — char(13 — Primary key — NOT NULL
- Field (familyName) — char(10)
- Field (familyGender) — char(1)
- Field (familyBirthdate) — char(8)
- Field (familyRelations) — char(4)
- Field (relationEmployeeID) — char(10)
- Key (employeeID) — char(10) — Foreign key → Untitled.Key — NOT NULL