zzz
Tables (6)
classroom
- classroom_id — BIGINT — Primary key — NOT NULL
- building_name — VARCHAR(100) — NOT NULL — 건물명
- room_number — VARCHAR(30) — NOT NULL — 강의실 호수
- capacity — INT — NOT NULL — 최대 수용 인원
- created_at — DATETIME — NOT NULL
classroom_timetable
- timetable_id — BIGINT — Primary key — NOT NULL
- classroom_id — BIGINT — Foreign key → classroom.classroom_id — NOT NULL
- day_of_week — TINYINT — NOT NULL — 1:월 2:화 3:수 4:목 5:금 6:토 7:일
- start_time — TIME — NOT NULL — 수업 시작 시간
- end_time — TIME — NOT NULL — 수업 종료 시간
- valid_from — DATE — NOT NULL — 시간표 적용 시작일
- valid_until — DATE — NOT NULL — 시간표 적용 종료일
- created_at — DATETIME — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- role — ENUM('MEMBER', 'ADMIN') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
room_participant
- participant_id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → study_room.room_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- status — ENUM( 'JOINED', 'CANCELLED' ) — NOT NULL
- joined_at — DATETIME — NOT NULL
- cancelled_at — DATETIME
study_category
- category_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
study_room
- room_id — BIGINT — Primary key — NOT NULL
- host_id — BIGINT — Foreign key → member.member_id — NOT NULL — 개설자 회원 ID
- classroom_id — BIGINT — Foreign key → classroom.classroom_id — NOT NULL
- category_id — BIGINT — Foreign key → study_category.category_id — NOT NULL
- title — VARCHAR(100) — NOT NULL — 모임 제목
- description — TEXT — 모임 설명
- start_at — DATETIME — NOT NULL — 모임 시작 일시
- end_at — DATETIME — NOT NULL — 모임 종료 일시
- max_members — INT — NOT NULL — 개설자를 포함한 모집 정원
- status — ENUM( 'SCHEDULED', 'COMPLETED', 'CANCELLED' ) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL