f

Tables (7)

Untitled (employee)

  • Key (emplid) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (gender) — char(3)
  • Field2 (adress) — char(10)
  • Field2 (phone) — char(10)
  • Field (salary) — char(10)
  • Key (depid) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (superemplid2) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (department location)

  • Key (depid) — char(10) — Foreign key → Untitled2.Key — NOT NULL
  • Key (locid) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (location)

  • Key (locid) — char(10) — Primary key — NOT NULL
  • Field (locname) — char(10_
  • Field (phone) — char(10)
  • Field (email) — email

Untitled (project)

  • Key (proid) — char(10) — Primary key — NOT NULL
  • Field (startdate) — date
  • Field (endeate) — date
  • Field (descrition) — text
  • Key (manaterdepid) — char(10) — Foreign key → Untitled2.Key — NOT NULL

Untitled (workson)

  • Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (proid) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (hourperweek) — float

Untitled (dependent)

  • Key (dependid) — char(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (birthdate) — date
  • Field (relation) — char(10_
  • Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled2 (department)

  • Key (depid) — char(10) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field2 (managerid) — char(10)
  • Field (maganestartdate) — char(10)
  • Key (emplid) — char(10) — Foreign key → Untitled.Key — NOT NULL