1
Tables (7)
Course (course)
- Key (id) — char(2) — Primary key — NOT NULL
- Field (_name) — char(30)
- Field (credit) — int
Prof
- Key (id) — char(2) — Primary key — NOT NULL
- Key (labid) — char(2) — Foreign key → Untitled.Key — NOT NULL
- Field (_name) — char(30)
- Field (phone) — char(11)
Student
- Key (id) — char(2) — Primary key — NOT NULL
- Field (_name) — char(30)
- Field (iphac) — datetime2
- Field (phone) — char(11)
- Field (email) — char(30)
- Key (labid) — char(2) — Foreign key → Untitled.Key — NOT NULL
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 → Prof.Key — NOT NULL
- Field (score) — char(2)
- Field (openyear) — datetime2
- Key (id2) — char(2) — Foreign key → Prof.Key — NOT NULL
Untitled (Lab)
- Key (id) — char(2) — Primary key — NOT NULL
- Field (_name) — char(30)
- Field (room) — char(5)
Untitled (Project)
- Key (id) — char(2) — Primary key — NOT NULL
- Field (_name) — char(100)
- Field (from) — datetime2
- Field (to) — datetime2
- Field (money) — int
Untitled (Proj_Suhang)
- Key (pid) — char(2) — Foreign key → Prof.Key — NOT NULL
- Key (pjid) — char(2) — Foreign key → Untitled.Key — NOT NULL
- Key (sid) — char(2) — Foreign key → Student.Key — NOT NULL
- s참여율 (s_참여율) — decinal
- p참여율 (p_참여율) — decimal