학사관리시스템_

테이블 (5)

courses

  • course_id — INT — 기본 키 — NOT NULL
  • course_code — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • credit — INT
  • prof_id — INT — 외래 키 → professor.prof_id — NOT NULL

department

  • dept_id — INT — 기본 키 — NOT NULL
  • dept_name — VARCHAR(100) — NOT NULL
  • telephone — VARCHAR(20)

enrollments

  • course_id — INT — 외래 키 → courses.course_id — NOT NULL
  • student_id — BIGINT — 외래 키 → student.student_id — NOT NULL
  • score — INT
  • enrolled_at — DATE

professor

  • prof_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • dept_id — INT — 외래 키 → department.dept_id — NOT NULL

student

  • student_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • birth_date — DATE
  • created_at — DATE
  • dept_id — INT — 외래 키 → department.dept_id — NOT NULL