학부2024_학사ERD
테이블 (7)
LAB
- Key — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
- Field (room) — char(5)
- Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
Student
- id — char(2) — 기본 키 — NOT NULL
- _name — char(30)
- iphak — datetime2
- Field3 (phone) — char(11)
- Field (email) — char(30)
- Key (labid) — char(2) — 외래 키 → LAB.Key — NOT NULL
Untitled (Prof)
- Key (id) — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
Untitled (Sugang)
- id — char(2) — 외래 키 → Student.id — NOT NULL
- Key (cid) — char(2) — 외래 키 → Untitled2.Key — NOT NULL
- Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Field (score) — char(2)
- Field (openyear) — datetime2
Untitled (project)
- Key (id) — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
- Field2 (from) — datetime2
- Field (to) — datetime2
- Field (price) — int
Untitled (Project_Suhang)
- Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Key (projid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- id (sid) — char(2) — 외래 키 → Student.id — NOT NULL
- Field (s.참여율) — decimal
- Field (p.참여율) — decimal
- Field (From) — datetime2
- Field (To) — datetime2
Untitled2 (Course)
- Key (id) — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
- Field (credit) — int