2023_2학기_학사DB
테이블 (12)
Untitled (Student)
- Key (Id) — character(8) — 기본 키 — NOT NULL
- Field2 (name) — nvarchar(30)
- Field2 (phone) — char(11)
- Key (labId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (deptId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (bunzi) — nvarchar(10)
- Key (profId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
- Field (juminbunho) — char(13)
Untitled (Department)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Field (city) — nvarchar(10)
- Field (bunzi) — nvarchar(10)
- Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Course)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
Untitled (Sugang)
- Key (studentId) — character(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (courseId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (grade) — char(2)
- Field (year) — datetime2
- Key (profId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (roomId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Classroom)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
Untitled (Professor)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Key (deptId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (city) — nvarchar(10)
- Field (bunzi) — nvarchar(10)
- Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Paper)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (title) — nvarchar(50)
- Field (date) — datetime2
Untitled (Paper_Participate)
- Key (profId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (paperId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (studentId) — character(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Lab)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Key (profId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Field (name) — nvarchar(30)
Untitled (Project)
- Key (Id) — char(8) — 기본 키 — NOT NULL
- Field (name) — nvarchar(30)
- Field (start) — datetime2
- Field (end) — datetime2
- Field (agency) — nvarchar(50)
Untitled (Project_Participate)
- Key (profId) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (projed) — char(8) — 외래 키 → Untitled.Key — NOT NULL
- Key (studentId) — character(8) — 외래 키 → Untitled.Key — NOT NULL
Untitled (Address)
- Key (zip) — char(5) — 기본 키 — NOT NULL
- Field (city) — nvarchar(30)
- Field (Do) — nvarchar(30)