학원시간표
테이블 (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