Ryu - 2020-09-30 02:58:57

Tables (7)

Graduate (Untitled3)

  • ssn (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • deg_prog (Field3)
  • dno (Key2) — Foreign key → debt.dno — NOT NULL
  • graduatessn (Key3) — Foreign key → Graduate.ssn — NOT NULL

Project (Untitled4)

  • pid (Key) — Primary key — NOT NULL
  • spoonser (Field)
  • start_date (Field2)
  • end_date (Field3)
  • budget (Field4)

Work_Debt (Untitled6)

  • dno (Key) — Foreign key → debt.dno — NOT NULL
  • ssn (Key2) — Foreign key → professor.ssn — NOT NULL
  • pct_time (Field)

Work_in (Untitled5)

  • ssn (Key) — Foreign key → professor.ssn — NOT NULL
  • pid (Key2) — Foreign key → Project.pid — NOT NULL

Work_prog (Untitled7)

  • pid (Key3) — Foreign key → Project.pid — NOT NULL
  • ssn (Key) — Foreign key → Graduate.ssn — NOT NULL

debt (Untitled2)

  • dno (Key) — Primary key — NOT NULL
  • dname (Field)
  • office (Field2)
  • ssn (Key2) — Foreign key → professor.ssn — NOT NULL
  • ssn (Key3) — Foreign key → professor.ssn — NOT NULL

professor (Untitled)

  • ssn (Key) — Primary key — NOT NULL
  • name (Field2)
  • age (Field3)
  • rank (Field4)
  • speciality (Field6)
  • pid (Key2) — Foreign key → Project.pid — NOT NULL