ss

Tables (7)

Course (course)

  • Key (학수번호) — char(2) — Primary key — NOT NULL
  • Field (과목명) — char(30)
  • Field2 (학점) — int

Lab

  • ID (Id) — char(2) — Primary key — NOT NULL
  • _name — char(2)
  • room — char(5)
  • Key (PID) — char(2) — Foreign key → Prof.Key — NOT NULL

Prof (prof)

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (이름) — char(30)

Student (student)

  • Key (학번) — char(2) — Primary key — NOT NULL
  • Field (이름) — char(3)
  • Field (입학년도) — datetime2
  • Field (휴대전화) — char(11)
  • Field (email) — char(30)
  • ID (Key) — char(2) — Foreign key → Lab.ID — NOT NULL

Untitled (project)

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (_name) — char(30)
  • Field (from) — datetime2
  • Field (to) — datetime2
  • Field (price) — int

Untitled (proj_suhang)

  • Key (projid) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Key (pid) — char(2) — Foreign key → Prof.Key — NOT NULL
  • Key (sid) — char(2) — Foreign key → Student.Key — NOT NULL
  • Field (s.참여율) — decimal
  • Field (p.참여율) — decimal

sugang (수강)

  • Key (학번) — char(2) — Foreign key → Student.Key — NOT NULL
  • Key (학수번호) — char(2) — Foreign key → Course.Key — NOT NULL
  • Key (id) — char(2) — Foreign key → Prof.Key — NOT NULL
  • Field (score) — char(2)
  • Field (openyear) — datetime2