221115
Tables (7)
Untitled (student)
- Key (sid) — char(8) — Primary key — NOT NULL
- Field (name) — char(3)
- Field (addmission_day) — date
- Field (graduate_day) — date
- Field (gender) — char(1)
- Field (phone) — char(11)
Untitled (professor)
- Key (pid) — char(8) — Primary key — NOT NULL
- Field (room) — char(5)
- Field (phone) — char(11)
Untitled (course)
- Key (cid) — char(5) — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (grade) — int
Untitled (office)
- Key (oid) — char(9) — Primary key — NOT NULL
- Field (name) — varchar(20)
Untitled (lab)
- Key (lname) — varchar(20) — Primary key — NOT NULL
- Field (room_no) — char(5)
Untitled (class)
- Key (room) — char(8) — Primary key — NOT NULL
Untitled (sugang)
- Key (sid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (cid) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Field (open_date) — date
- Field (grade) — char(2)
- Key (pid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (room) — char(8) — Foreign key → Untitled.Key — NOT NULL