dbcourse

Tables (7)

Course

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (credit) — int

LAB (Untitled)

  • id (Key) — char(2) — Primary key — NOT NULL
  • _name (Field) — char(30)
  • room (Field2) — char(5)

Professor

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • id (Key) — char(2) — Foreign key → LAB.id — NOT NULL

Proj_Suhang (m2m mediation)

  • pid (Key) — char(2) — Foreign key → Projct.pid — NOT NULL
  • Key (id) — char(2) — Foreign key → student.Key — NOT NULL
  • Key (id2) — char(2) — Foreign key → Professor.Key — NOT NULL
  • studchamyeo (Field) — decimal
  • profchamyeo (Field2) — decimal
  • from (Field3) — datetime2
  • to (Field4) — datetime2

Projct (Untitled2)

  • pid (Key) — char(2) — Primary key — NOT NULL
  • _name (Field) — char(30)
  • from (Field2) — datetime2
  • to (Field3) — datetime2
  • price (Field4) — int

Sugang

  • Key (sid) — char(2) — Foreign key → student.Key — NOT NULL
  • Key (cid) — char(2) — Foreign key → Course.Key — NOT NULL
  • Key (pid) — char(2) — Foreign key → Professor.Key — NOT NULL
  • Field (score) — char(2)
  • Field (openyear) — datetime2
  • Field

student

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (_year) — datetime2
  • Field (phone) — char(11)
  • Field (email) — char(30)
  • id (Key) — char(2) — Foreign key → LAB.id — NOT NULL