ㅋ
Tables (6)
Course
- id — INT — Primary key — NOT NULL
- _name — NCHAR(30)
- credit — INT
- dept_id — INT — Foreign key → Department.id — NOT NULL
- id2 — INT — Foreign key → Professor.id — NOT NULL
Department
- id — INT — Primary key — NOT NULL
- _name — NCHAR(30)
- phone — CHAR(14)
- addr — NCHAR(50)
Lab
- id — INT — Foreign key → Professor.id — NOT NULL
- Field — VARCHAR(255)
Professor
- id — INT — Primary key — NOT NULL
- _name — NCHAR(4)
- phone — CHAR(14)
- id2 — INT — NOT NULL
- id3 — INT — NOT NULL
Student
- id — INT — Primary key — NOT NULL
- _name — NCHAR(30)
- birth — DATETIME2
- id2 — INT — NOT NULL
- Field — VARCHAR(255)
Sugang
- cid — INT — Foreign key → Course.id — NOT NULL
- sid — INT — Foreign key → Student.id — NOT NULL
- gpa — CHAR(2)
- open_year — DATETIME2
- open_semester — TINYINT