2023_2학기_학사DB
테이블 (5)
Untitled (Student)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Key — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Field (deptid) — char(8)
Untitled (Deptment)
- Key — char(8) — 기본 키 — NOT NULL
- Field (Name) — nvarchar(30)
- Field (phone) — char(11)
Untitled (Course)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field
Untitled (Room)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — varchar(30)
Untitled (Sugang)
- Key (studentid) — char(8) — 기본 키 — NOT NULL
- Field (courseid) — char(8)