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