학사관리시스템

테이블 (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