departmentERD
Tables (8)
Classroom (classroom)
- Key (room) — char(5) — Primary key — NOT NULL
- Key (zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (student)
- Key (sid) — char(8) — Primary key — NOT NULL
- Field (name) — char(4)
- 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 (professor)
- Key (pid) — char(4) — Primary key — NOT NULL
- Field (room) — char(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 (office)
- Key (oid) — char(5) — Primary key — NOT NULL
- Field (name) — varchr(20)
- Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
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 (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 (grade) — char(2)
- Key (pid) — char(4) — Foreign key → Untitled.Key — NOT NULL
- Key (room) — char(5) — Foreign key → Classroom.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)