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