TripLog

Tables (9)

members

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • refresh_token — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_groups

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • nights — INT
  • join_code — VARCHAR(255)
  • region — VARCHAR(255)
  • member_id — BIGINT — Foreign key → members.id
  • is_start_vote — BIT(1)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_members

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id
  • trip_group_id — BIGINT — Foreign key → trip_groups.id
  • is_admin — BIT(1)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_posts

  • id — BIGINT — Primary key — NOT NULL
  • content_url — VARCHAR(255)
  • trip_member_id — BIGINT — Foreign key → trip_members.id
  • trip_timeline_id — BIGINT — Foreign key → trip_timelines.id
  • type — VARCHAR(255)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_timelines

  • id — BIGINT — Primary key — NOT NULL
  • trip_group_id — BIGINT — Foreign key → trip_groups.id
  • start_time — DATETIME(6)
  • end_time — DATETIME(6)
  • day_number — BIGINT
  • trip_wish_place_id — BIGINT — Foreign key → trip_wish_places.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_vote_items

  • id — BIGINT — Primary key — NOT NULL
  • trip_vote_id — BIGINT — Foreign key → trip_votes.id
  • trip_wish_place_id — BIGINT — Foreign key → trip_wish_places.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_vote_users

  • id — BIGINT — Primary key — NOT NULL
  • trip_vote_item_id — BIGINT — Foreign key → trip_vote_items.id
  • trip_member_id — BIGINT — Foreign key → trip_members.id
  • trip_vote_id — BIGINT — Foreign key → trip_votes.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_votes

  • id — BIGINT — Primary key — NOT NULL
  • trip_group_id — BIGINT — Foreign key → trip_groups.id
  • trip_timeline_id — BIGINT — Foreign key → trip_timelines.id
  • trip_member_id — BIGINT — Foreign key → trip_members.id
  • expire_time — DATETIME(6)
  • status — VARCHAR(50)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

trip_wish_places

  • id — BIGINT — Primary key — NOT NULL
  • trip_group_id — BIGINT — Foreign key → trip_groups.id
  • name — VARCHAR(255)
  • category — VARCHAR(255)
  • address — VARCHAR(255)
  • kakao_place_id — VARCHAR(255)
  • kakao_map_url — VARCHAR(255)
  • trip_member_id — BIGINT — Foreign key → trip_members.id
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)