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)