DDubuk
Tables (9)
images
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → reviews.id — NOT NULL
- file_url — text — NOT NULL
- file_path — text — NOT NULL
places
- id — bigint — Primary key — NOT NULL
- kakao_place_id — text
- place_name — text
- category — text
- latitude — double
- longitude — double
- is_near_station — boolean
- address — text
profiles
- id — uuid — Primary key — NOT NULL
- nickname — text — NOT NULL
- avatar_url — text — NOT NULL
- email — text — NOT NULL
- created_at — timestamp — NOT NULL
reviews
- id — bigint — Primary key — NOT NULL
- user_id — uuid — Foreign key → profiles.id — NOT NULL
- travel_card_id — bigint — Foreign key → travelcard.id
- rating — integer — NOT NULL
- content — text
- created_at — timestamp
routes
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- start — bigint — Foreign key → places.id — NOT NULL
- end — bigint — Foreign key → places.id — NOT NULL
- slope — character
- stairs — character
- shade — character
- user_id — uuid — NOT NULL
- transport_type — text — NOT NULL
travelcard
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id — NOT NULL
- title — text — NOT NULL
- image_url — text
- category — text
- is_hot — boolean
- total_distance — numeric(5, 2)
- total_time — text
- spot_count — integer
- estimated_cost — integer
- save_count — integer
- avg_incline — text
- avg_stairs — text
- avg_shade — text
- avg_rating — numeric(2, 1)
- review_count — integer
- tags — text
- created_at — timestamp
travelers
- id — bigint — Primary key — NOT NULL
- travel_card_id — bigint — Foreign key → travelcard.id — NOT NULL
- user_id — uuid — Foreign key → profiles.id — NOT NULL
- status — text
- completed_at — timestamp
trip_items
- id — bigint — Primary key — NOT NULL
- trip_id — bigint — Foreign key → trips.id
- place_id — bigint — Foreign key → places.id
- visit_order — integer
- transport_type — text
- travel_time — integer
- visit_day — integer
trips
- id — bigint — Primary key — NOT NULL
- user_id — uuid — Foreign key → profiles.id
- title — text
- start_date — date
- end_date — date
- is_public — boolean