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