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)