학원시간표

테이블 (13)

academy

  • id — BIGSERIAL
  • name — TEXT — NOT NULL
  • branch — TEXT
  • region — TEXT

academy_member

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • role_in_academy — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL

academy_partner

  • academy_id — BIGINT — 기본 키 — NOT NULL
  • partner_id — BIGINT — 기본 키 — NOT NULL

app_user

  • id — BIGSERIAL
  • name — TEXT — NOT NULL

class_offering

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • course_id — BIGINT
  • teacher_id — BIGINT — NOT NULL
  • room_id — BIGINT
  • term_id — BIGINT
  • capacity — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • visibility — VARCHAR(20) — NOT NULL
  • target_level — CHAR(1)
  • note — TEXT

class_target_grade

  • class_id — BIGINT — 기본 키 — NOT NULL
  • grade — SMALLINT — 기본 키 — NOT NULL

class_textbook

  • class_id — BIGINT — 기본 키 — NOT NULL
  • textbook_id — BIGINT — 기본 키 — NOT NULL

course

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • title — TEXT — NOT NULL
  • subject — TEXT

enrollment

  • id — BIGSERIAL
  • class_id — BIGINT — NOT NULL
  • student_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • enrolled_at — TIMESTAMP — NOT NULL

meeting_time

  • id — BIGSERIAL
  • class_id — BIGINT — NOT NULL
  • day_of_week — SMALLINT — NOT NULL
  • start_min — INTEGER — NOT NULL
  • end_min — INTEGER — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

room

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • name — TEXT — NOT NULL
  • capacity — INTEGER

term

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • title — TEXT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

textbook

  • id — BIGSERIAL
  • academy_id — BIGINT — NOT NULL
  • title — TEXT — NOT NULL
  • publisher — TEXT