2023_2학기_학사DB
테이블 (8)
Untitled (Student)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Key (deptid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (labid) — char(8)
- Field (jidopof) — char(8)
- Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Field (Bunzi) — nvarchar(10)
- Field (juminno) — char(13)
- Field
- Key (id2) — char(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Department)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (Name) — nvarchar(30)
- Field (phone) — char(11)
Untitled (Course)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
Untitled (Sugang)
- Key (studentid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (Courseid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (grade) — char(2)
- Field (year) — datetime(2)
- Key (roomid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Room)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
Untitled (Lab)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (profid) — char(8)
Untitled (Address)
- Key (zip) — char(5) — 기본 키 — NOT NULL
- Field (City) — nvarchar(30)
- Field (Do) — nvarchar(30)
Untitled (Professor)
- Key (id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Field (deptid) — char(8)
- Field