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