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