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)