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)