COMPANY

Tables (5)

EMPLOYEE

  • ssn — char(30) — Primary key — NOT NULL
  • name — char(30)
  • address — char(40)
  • phone — int(11)
  • Field4 (bdate) — date
  • Field (salary) — int(10)
  • Field (gender) — char(1)
  • Field (email) — char(30)
  • Key (dno) — char(3) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (dno) — char(3) — Primary key — NOT NULL
  • Field (dname) — char(30)
  • Field (phone) — int(11)
  • Field (manageStartDate) — date
  • ssn — char(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

Untitled (PROJECT)

  • Key (pno) — char(30) — Primary key — NOT NULL
  • Field (pname) — char(30)
  • Field (description) — text
  • Field

Untitled (WORKS_ON)

  • ssn — char(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
  • Key (pno) — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field (hour) — float

Untitled (DEPENDENT)

  • Key (ssn) — char(30) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field2 (brithDate) — date
  • Field (gender) — char(1)
  • Field (relation) — char(10)
  • Field (status) — char(50)
  • ssn (ssn2) — char(30) — Foreign key → EMPLOYEE.ssn — NOT NULL