department
Tables (7)
Untitled (student)
- Key (sid) — char(8) — Primary key — NOT NULL
- Field (name) — char(3)
- Field (admission) — date
- Field (graduate_date) — date
- Field (gender) — char(1)
- Field (phone) — char(11)
- Key (lname) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (professorf)
- Key (pid) — char(4) — Primary key — NOT NULL
- Field (room) — cahr(5)
- Field (phone) — char(11)
- Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (course)
- Key (cid) — char(6) — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (grade) — int
Untitled (lab)
- Key (lname) — varchar(20) — Primary key — NOT NULL
- Field (room) — char(5)
- Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (class)
- Key (room) — char(5) — Primary key — NOT NULL
- Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
- Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (sugang)
- Key (sid) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (cid) — char(6) — Foreign key → Untitled.Key — NOT NULL
- Field (open_date) — date
- Field (gread) — char(2)
- Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
- Key (room) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (address)
- Key (zipcode) — char(5) — Primary key — NOT NULL
- Field (do) — char(10)
- Field (city) — char(10)
- Field (gu) — char(10)
- Field (bunzi) — char(10)