Mimi

Tables (5)

Untitled (EMPLOYEE)

  • Key (ssn) — char(14) — Primary key — NOT NULL
  • Field (name) — chart(20)
  • Field (address) — chart(30)
  • Field (phone) — chart(11)
  • Key (depID) — char(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (depID) — char(3) — Primary key — NOT NULL
  • Field (name) — chart(20)
  • Field (manager)
  • Field (managerStartDate)
  • Key (managerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (PROJECT)

  • Key (projNo) — chart(10) — Primary key — NOT NULL
  • Field (name)
  • Key (depID) — char(3) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn) — char(14) — Foreign key → Untitled.Key — NOT NULL

Untitled (WORKS ON)

  • Key (ssn) — Primary key — NOT NULL
  • Key (ssn2) — char(14) — Foreign key → Untitled.Key — NOT NULL
  • Field (projNo)
  • Field (hours)

Untitled (DEPENDENT)

  • Key (dependentName) — Primary key — NOT NULL
  • Field (gender)
  • Field (birthDate)
  • Field (relationship)
  • Field (parent)
  • Field (ssn)
  • Field
  • Key (ssn2) — char(14) — Foreign key → Untitled.Key — NOT NULL