COMA-ROOM

데베설 화이팅!

테이블 (16)

event

  • event_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • event_date — DATETIME — NOT NULL
  • reward_xp — BIGINT — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • event_category — VARCHAR(255) — NOT NULL
  • host_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

event_approval

  • approval_id — BIGINT — 기본 키 — NOT NULL
  • approval_status — VARCHAR(255)
  • approval_at — DATETIME
  • granted_xp — BIGINT
  • reason — VARCHAR(255)
  • requester_id — BIGINT — 외래 키 → member.member_id
  • created_at — DATETIME
  • updated_at — DATETIME

event_participant

  • event_participant_id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → event.event_id — NOT NULL
  • participant_member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

event_photo

  • event_photo_id — BIGINT — 기본 키 — NOT NULL
  • photo_url — VARCHAR(255) — NOT NULL
  • post_id — INT — 외래 키 → event_photo_post.post_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

event_photo_post

  • post_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • approval_status — VARCHAR(255) — NOT NULL
  • author_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • event — BIGINT — 외래 키 → event.event_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • student_id — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • xp — BIGINT — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • major — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

notice

  • notice_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_pinned — BOOLEAN — NOT NULL
  • is_hidden — BOOLEAN — NOT NULL
  • notice_priority — VARCHAR(255) — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

study

  • id — BIGINT — 기본 키 — NOT NULL
  • study_name — VARCHAR(255) — NOT NULL
  • manager_id — BIGINT — 외래 키 → member.member_id
  • description — VARCHAR(2000)
  • schedule_description — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • topic — VARCHAR(255)

study_attendance_session

  • id — BIGINT — 기본 키 — NOT NULL
  • plan_id — BIGINT — 외래 키 → study_week.id — NOT NULL
  • event_id — BIGINT — 외래 키 → event.event_id

study_join_request

  • id — BIGINT — 기본 키 — NOT NULL
  • study_id — BIGINT — 외래 키 → study.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

study_material

  • id — BIGINT — 기본 키 — NOT NULL
  • plan_id — BIGINT — 외래 키 → study_week.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • object_key — VARCHAR(512) — NOT NULL

study_member

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id
  • study_id — BIGINT — 외래 키 → study.id
  • created_at — DATETIME
  • updated_at — DATETIME

study_week

  • id — BIGINT — 기본 키 — NOT NULL
  • study_id — BIGINT — 외래 키 → study.id — NOT NULL
  • week_number — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • topic — VARCHAR(255)
  • description — VARCHAR(2000)
  • created_at — DATETIME
  • updated_at — DATETIME

vote

  • vote_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • is_multi_vote — BOOLEAN — NOT NULL
  • vote_status — VARCHAR(255) — NOT NULL
  • deadline — DATETIME — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

vote_option

  • vote_option_id — BIGINT — 기본 키 — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • vote_id — BIGINT — 외래 키 → vote.vote_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

vote_result

  • vote_result_id — BIGINT — 기본 키 — NOT NULL
  • voter_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • vote_option_id — BIGINT — 외래 키 → vote_option.vote_option_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME