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