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