madang

Tables (7)

Untitled (Work_ln)

  • Key (ssn) — INT — Primary key — NOT NULL
  • Key (pid) — INT — Primary key — NOT NULL
  • Key (ssn2) — INT — Foreign key → Untitled6.Key — NOT NULL
  • Key (pid2) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Key (pid) — INT — Primary key — NOT NULL
  • Field (ssn) — INT
  • Field (sponsor) — VARCHAR
  • Field (start_date) — DATE
  • Field (end_date) — DATE
  • Field (budget) — INT
  • Key (ssn2) — INT — Foreign key → Untitled6.Key — NOT NULL

Untitled2 (Work_prog)

  • Key (ssn) — INT — Primary key — NOT NULL
  • Key (pid) — INT — Primary key — NOT NULL
  • Key (pid2) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn2) — INT — Foreign key → Untitled3.Key — NOT NULL

Untitled3 (Graduate)

  • Key (ssn) — INT — Primary key — NOT NULL
  • Field (dno) — INT
  • Field (age) — INT
  • Field (deg_prog) — VARCHAR
  • Field (graduatessn) — INT

Untitled4 (Dept)

  • Key (dno) — INT — Primary key — NOT NULL
  • Field (ssn) — INT
  • Field (dname) — VARCHAR
  • Field (office) — VARCHAR

Untitled5 (Work_Dept)

  • Key (ssn) — INT — Primary key — NOT NULL
  • Key (dno) — INT — Primary key — NOT NULL
  • Field (pct_time) — INT

Untitled6 (Professor)

  • Key (ssn) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field (age) — INT
  • Field (rank) — VARCHAR
  • Field (speciality) — VARCHAR