ㅁㄱㄷㄱ
Tables (5)
Course
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
Department
- id — char(8) — Primary key — NOT NULL
- Name — nvarchar(30)
- phone — char(11)
Room
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
Student
- id — char(8) — Primary key — NOT NULL
- name — nvarchar(30)
- phone — char(11)
- deptid — char(8) — NOT NULL
Sugang
- studentid — char(8) — Foreign key → Student.id — NOT NULL
- courseid — char(8) — Foreign key → Course.id — NOT NULL
- grade — char(2)
- year — datetime2
- roomid — char(8) — NOT NULL