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)