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)