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