학사관리시스템
테이블 (11)
course
- course_id — bigserial
- title — varchar(200) — NOT NULL
- category — varchar(100)
- level — varchar(50)
- expected_hours — int
- status — varchar(20)
- created_at — timestamptz
- updated_at — timestamptz
course_description
- description_id — bigserial
- course_id — bigint — NOT NULL
- version — int
- language — varchar(10)
- title — varchar(200)
- content_md — text — NOT NULL
- tags — text
- is_current — boolean
- created_at — timestamptz
- updated_at — timestamptz
course_offering
- offering_id — bigserial
- course_id — bigint — NOT NULL
- name — varchar(150) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- capacity — int
- mode — varchar(20)
- location — varchar(200)
- status — varchar(20)
- created_at — timestamptz
- updated_at — timestamptz
description_embedding
- embedding_id — bigserial
- description_id — bigint — NOT NULL
- provider — varchar(50) — NOT NULL
- model — varchar(100) — NOT NULL
- dimension — int — NOT NULL
- chunk_index — int
- text_span — text
- embedding — vector
- token_count — int
- created_at — timestamptz
enrollment
- enrollment_id — bigserial
- offering_id — bigint — NOT NULL
- student_id — bigint — NOT NULL
- enrolled_at — timestamptz
- status — varchar(20)
- grade — varchar(5)
- attendance_rate — numeric(5,2)
instructor
- instructor_id — bigserial
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(30)
- bio — text
- created_at — timestamptz
- updated_at — timestamptz
offering_instructor
- offering_id — bigint — 기본 키 — NOT NULL
- instructor_id — bigint — 기본 키 — NOT NULL
- role — varchar(50)
- assigned_at — timestamptz
offering_operator
- offering_id — bigint — 기본 키 — NOT NULL
- operator_id — bigint — 기본 키 — NOT NULL
- role — varchar(50)
- assigned_at — timestamptz
operator
- operator_id — bigserial
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(30)
- role — varchar(50)
- created_at — timestamptz
- updated_at — timestamptz
review
- review_id — bigserial
- offering_id — bigint — NOT NULL
- student_id — bigint — NOT NULL
- rating — int — NOT NULL
- title — varchar(200)
- content — text — NOT NULL
- is_anonymous — boolean
- created_at — timestamptz
- updated_at — timestamptz
student
- student_id — bigserial
- name — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(30)
- birth_date — date
- status — varchar(20)
- created_at — timestamptz
- updated_at — timestamptz