학부실습
테이블 (7)
Untitled (Lab)
- Key (ID) — Char [2] — 기본 키 — NOT NULL
- Field (name) — Char [30]
- Field — Char[5]
- Key (pid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
Untitled (student)
- Key (id) — char[2] — 기본 키 — NOT NULL
- Field (name) — char[33]
- Field (iphak) — datetime[2]
- Field (email) — char[33]
- Key (labid) — Char [2] — 외래 키 → Untitled.Key — NOT NULL
- Field (phone) — Char[11]
Untitled (prof)
- Key (id) — char[2] — 기본 키 — NOT NULL
- Field (name) — char[30]
Untitled (course)
- Key (ID) — char[2] — 기본 키 — NOT NULL
- Field (name) — char[30]
- Field (credit) — int
Untitled (sugang)
- Key (sid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
- Key (cid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
- Key (pid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
- Field (score) — char[2]
- Field (openyear) — datetime2
Untitled2 (project)
- Key (ID) — char[2] — 기본 키 — NOT NULL
- Field (name) — char[30]
- Field (from) — datetime2
- Field (to) — datetime2
- Field (price) — int
Untitled2 (project_Suhang)
- Key (sid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
- Key (pid) — char[2] — 외래 키 → Untitled2.Key — NOT NULL
- Key (projid) — char[2] — 외래 키 → Untitled.Key — NOT NULL
- Field (s_참여율) — decimal
- Field (p.참여율) — decimal
- Field (From) — datatime2
- Field (To) — Datatiem2