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