madanguni

Tables (7)

Department (Untitled2)

  • depart_id (Key) — bigint — Primary key — NOT NULL
  • dno (Field) — integer
  • dname (Field2) — varchar(20)
  • office (Field3) — varchar(20)
  • professor_id (Key2) — bigint — Foreign key → professor.professor_id — NOT NULL

Graduate (Untitled3)

  • gra_id (Key) — bigint — Primary key — NOT NULL
  • ssn (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • age (Field3) — tinyint
  • deg_prog (Field4) — varchar(10)
  • advisor (Field5) — varchar(20)
  • depart_id (Key2) — bigint — Foreign key → Department.depart_id — NOT NULL

Project (Untitled4)

  • pid (Key) — bigint — Primary key — NOT NULL
  • sponsor (Field) — varchar(20)
  • start_date (Field2) — varchar(20)
  • end_date (Field3) — varchar(20)
  • budget (Field4) — bigint
  • manager (Key2) — bigint — Foreign key → professor.professor_id — NOT NULL

Work-dept (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • depart_id (Key2) — bigint — Foreign key → Department.depart_id — NOT NULL
  • professor_id (Key3) — bigint — Foreign key → professor.professor_id — NOT NULL
  • pct_time (Field)

Work-in (Untitled6)

  • id (Key3) — int — Primary key — NOT NULL
  • professor_id (Key) — bigint — Foreign key → professor.professor_id — NOT NULL
  • pid (Key2) — bigint — Foreign key → Project.pid — NOT NULL

Work-prog (Untitled7)

  • id (Key3) — integer — Primary key — NOT NULL
  • gra_id (Key) — bigint — Foreign key → Graduate.gra_id — NOT NULL
  • pid (Key2) — bigint — Foreign key → Project.pid — NOT NULL

professor (Untitled)

  • professor_id (Key) — bigint — Primary key — NOT NULL
  • ssn (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • age (Field3) — integer
  • rank (Field4) — varchar(20)
  • speciality (Field5) — varchar(20)