학사실습
테이블 (7)
Untitled (Student)
- Key (ID) — char(2) — 기본 키 — NOT NULL
- Field (_Name) — char(30)
- Field (iphak) — Determine2
- Field (Phone) — char(11)
- Field (Email) — char(30)
- Key (l.id) — char(2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Course)
- Key (ID) — char(2) — 기본 키 — NOT NULL
- Field (_Name) — char(30)
- Field (credit) — int
Untitled (Prof)
- Key (ID) — char(2) — 기본 키 — NOT NULL
- Field (_Name) — char(30)
- Key (l.id) — char(2) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Sugang)
- Key (s.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Key (c.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Key (p.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Field (score) — char(2)
- Field (openyear) — determine2
Untitled (Lab)
- Key (ID) — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
- Field (room) — char(5)
Untitled (Project)
- Key (ID) — char(2) — 기본 키 — NOT NULL
- Field (_name) — char(30)
- Field (from) — datetime2
- Field (to) — datetime2
- Field (price) — int
Untitled (proj_suheng)
- Key (p.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Key (Pr.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Key (s.ID) — char(2) — 외래 키 → Untitled.Key — NOT NULL
- Field (s.chamyoyul) — decimal
- Field (p.chamyoyul) — decimal