pj_trip

Tables (5)

search

  • Key — Primary key — NOT NULL
  • travel_id — uuid — Foreign key → travel.travel_id — NOT NULL
  • search_word — string
  • searched_at — date
  • result (to be added) — Data json

travel

  • travel_id — uuid — Primary key — NOT NULL
  • travel_name — string
  • place — string

trip

  • trip_id — uuid — Primary key — NOT NULL
  • travel_id — uuid — Foreign key → travel.travel_id — NOT NULL
  • trip_order — number
  • trip_name — string(default 1일차)

trip_image

  • trip_image_id — uuid — Primary key — NOT NULL
  • trip_id — uuid — Foreign key → trip.trip_id — NOT NULL
  • travel_id — uuid — Foreign key → trip.travel_id — NOT NULL
  • path — string(local image path)
  • name — string

trip_place

  • trip_place_id — uuid — Primary key — NOT NULL
  • trip_id — uuid — Foreign key → trip.trip_id — NOT NULL
  • travel_id — uuid — Foreign key → trip.travel_id — NOT NULL
  • order — number
  • name — string
  • lat — number
  • lon — number
  • addr — string
  • navi_url — string(url)