AI 기반 학사 관리 시스템(멀티캠퍼스)

테이블 (7)

Course

  • course_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR
  • course_time — TIME
  • insturctor_id — BIGINT — NOT NULL
  • curriculum_id — BIGINT — NOT NULL

CourseDescription

  • course_id — BIGINT — 외래 키 → Course.course_id — NOT NULL
  • description — TEXT

Curriculum

  • curriculum_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR
  • department — ENUM
  • grade — ENUM

Enrollment

  • enrollment_id — BIGINT — 기본 키 — NOT NULL
  • student_id — BIGINT — NOT NULL
  • date — DATETIME
  • course_id — BIGINT — NOT NULL

Instructor

  • instructor_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR
  • department — ENUM

Review

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • review_id — BIGINT
  • rating — INT
  • comment — TEXT
  • date — DATETIME
  • student_id — BIGINT — NOT NULL
  • course_id — BIGINT — NOT NULL

Student

  • student_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR
  • email — VARCHAR
  • major — ENUM
  • date — DATETIME