d
Tables (7)
Untitled (EMPLOYEE)
- Key (ssn) — Primary key — NOT NULL
- Key (depID) — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field (adress)
- Field (birthDate)
- Field (salary)
- Field (gender)
- Field (email)
- Field (phone)
Untitled (DEPARTMENT)
- Key (depID) — Primary key — NOT NULL
- Key (ssn) — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field (phone)
- Field (email)
Untitled (DEPENDANT)
- Key (dependantID) — Primary key — NOT NULL
- Key (ssn) — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field (birthDate)
- Field (degree)
Untitled (LOCATION)
- Key (locationID) — Primary key — NOT NULL
- Field (name)
- Field (adress)
Untitled (departmentLocation)
- Key (depID) — Foreign key → Untitled.Key — NOT NULL
- Key (locationID) — Foreign key → Untitled.Key — NOT NULL
Untitled (PROJECT)
- Key (projectID) — Primary key — NOT NULL
- Key (depID) — Foreign key → Untitled.Key — NOT NULL
- Field (name)
- Field (date)
- Field (outline)
Untitled (projectEmployee)
- Key (ssn) — Foreign key → Untitled.Key — NOT NULL
- Key (projectID) — Foreign key → Untitled.Key — NOT NULL
- Field (workingHour)