bachelor_system
Tables (4)
class_registration
- PK (student_id) — INT — Foreign key → student.PK — NOT NULL
- PK (subject_id) — INT — Foreign key → subject.PK — NOT NULL
student
- PK (id) — INT — Primary key — NOT NULL
- 학생이름 (name) — VARCHAR(50)
- 학년 (grade) — INT
subject
- PK (id) — INT — Primary key — NOT NULL
- 과목이름 (name) — VARCHAR(50)
- 과목시수 (contact_hours) — INT
- 선생님_id (teacher_id) — INT — Foreign key → teacher.PK — NOT NULL
teacher
- PK (id) — INT — Primary key — NOT NULL
- 선생님_이름 (name) — VARCHAR(50)