ggg
Tables (11)
comments
- comment_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key — NOT NULL
- schedule_id — BIGINT — Foreign key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- parent_comment_id — BIGINT — Foreign key → comments.comment_id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
invitations
- invitation_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → plans.plan_id — NOT NULL
- inviter_id — BIGINT — Foreign key → users.user_id — NOT NULL
- invite_code — VARCHAR(100) — NOT NULL
- role — ENUM('EDITOR', 'VIEWER') — NOT NULL
- status — ENUM('ACTIVE', 'EXPIRED', 'REVOKED') — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
members
- member_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → plans.plan_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role — ENUM('OWNER', 'EDITOR', 'VIEWER') — NOT NULL
- status — ENUM('JOINED', 'LEFT') — NOT NULL
- joined_at — DATETIME
places
- place_id — BIGINT — Primary key — NOT NULL
- kakao_place_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(100)
- address — VARCHAR(255)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- phone — VARCHAR(50)
- image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
plans
- plan_id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- center_region — VARCHAR(100)
- is_recruiting — BOOLEAN — NOT NULL
- recruit_count — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
schedule_comments
- comment_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → plans.plan_id — NOT NULL
- schedule_id — BIGINT — Foreign key → schedules.schedule_id — NOT NULL
- writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- parent_comment_id — BIGINT — Foreign key → schedule_comments.comment_id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
schedules
- schedule_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → plans.plan_id — NOT NULL
- place_id — BIGINT — Foreign key → places.place_id
- kakao_route_url — VARCHAR(500)
- schedule_date — DATE — NOT NULL
- title — VARCHAR(100) — NOT NULL
- start_time — TIME
- end_time — TIME
- memo — VARCHAR(500)
- display_order — INT — NOT NULL
- is_reserved — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- kakao_id — BIGINT — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- profile_image — VARCHAR(500)
- created_at — DATETIME — NOT NULL
vote_options
- vote_option_id — BIGINT — Primary key — NOT NULL
- vote_id — BIGINT — Foreign key → votes.vote_id — NOT NULL
- place_id — BIGINT — Foreign key → places.place_id
- content — VARCHAR(255) — NOT NULL
- display_order — INT — NOT NULL
vote_participations
- vote_participation_id — BIGINT — Primary key — NOT NULL
- vote_id — BIGINT — Foreign key → votes.vote_id — NOT NULL
- vote_option_id — BIGINT — Foreign key → vote_options.vote_option_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- participated_at — DATETIME — NOT NULL
votes
- vote_id — BIGINT — Primary key — NOT NULL
- plan_id — BIGINT — Foreign key → plans.plan_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- vote_type — ENUM('SINGLE', 'MULTIPLE') — NOT NULL
- closes_at — DATETIME — NOT NULL
- status — ENUM('OPEN', 'CLOSED') — NOT NULL
- creator_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — DATETIME — NOT NULL