triptruth

Tables (12)

conflict_card

  • id — BIGINT
  • trip_group_id — BIGINT — Foreign key → trip_group.id — NOT NULL
  • conflict_type — VARCHAR(50) — NOT NULL — EXPLICIT, POTENTIAL, HIDDEN
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)

conflict_detail

  • id — BIGINT
  • conflict_card_id — BIGINT — Foreign key → conflict_card.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL

daily_schedule

  • id — BIGINT
  • recommended_plan_id — BIGINT — Foreign key → recommended_plan.id — NOT NULL
  • day_number — INT — NOT NULL
  • start_time — VARCHAR(10) — NOT NULL
  • activity_title — VARCHAR(100) — NOT NULL
  • satisfied_need — VARCHAR(100)

group_member

  • id — BIGINT
  • trip_group_id — BIGINT — Foreign key → trip_group.id — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • role — VARCHAR(50) — NOT NULL — LEADER, MEMBER
  • is_survey_completed — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

plan_tag

  • id — BIGINT
  • recommended_plan_id — BIGINT — Foreign key → recommended_plan.id — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL

recommended_plan

  • id — BIGINT
  • trip_group_id — BIGINT — Foreign key → trip_group.id — NOT NULL
  • plan_rank — INT — NOT NULL
  • destination — VARCHAR(100) — NOT NULL
  • budget_status — VARCHAR(100) — NOT NULL
  • satisfaction_percent — INT — NOT NULL
  • is_decided — BOOLEAN — NOT NULL

survey_activity

  • id — BIGINT
  • survey_response_id — BIGINT — Foreign key → survey_response.id — NOT NULL
  • activity_type — VARCHAR(50) — NOT NULL — OCEAN, MOUNTAIN_NATURE, CITY_EXPLORATION, CAFE_TOUR, SHOPPING, NIGHT_VIEW

survey_avoidance_tag

  • id — BIGINT
  • survey_response_id — BIGINT — Foreign key → survey_response.id — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL

survey_mood

  • id — BIGINT
  • survey_response_id — BIGINT — Foreign key → survey_response.id — NOT NULL
  • mood_type — VARCHAR(50) — NOT NULL — ACTIVITY, RELAXATION, CULTURE_TOURISM, FOOD, AESTHETIC_PHOTO, ENTERTAINMENT

survey_response

  • id — BIGINT
  • group_member_id — BIGINT — Foreign key → group_member.id — NOT NULL
  • avoidance_text — VARCHAR(255)
  • budget — INT — NOT NULL
  • comment — VARCHAR(255) — ARCHAR(255) NUL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_group

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • trip_length — VARCHAR(50) — NOT NULL — DAY_TRIP, ONE_NIGHT, TWO_NIGHTS, THREE_NIGHTS_PLUS
  • start_date — DATE
  • end_date — DATE
  • invite_code — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL — GATHERING, ANALYZING, VOTING, COMPLETED, FAILED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

vote

  • id — BIGINT
  • group_member_id — BIGINT — Foreign key → group_member.id — NOT NULL
  • recommended_plan_id — BIGINT — Foreign key → recommended_plan.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL