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