enjoy_trip

Tables (7)

HotPlace (hotplaces)

  • hotplace_id (Key) — Primary key — NOT NULL
  • name (Field)
  • visited_date (Field2)
  • type (Field3)
  • detail (Field4)
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL
  • trip_id (Key3) — Foreign key → trip.trip_id — NOT NULL

TripCourse (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • id (Key2) — Foreign key → content_type.id — NOT NULL

content_type (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • share_id (Key2) — Foreign key → travel_information_sharing.share_id — NOT NULL
  • trip_id (Key3) — Foreign key → trip.trip_id — NOT NULL

travel_information_sharing (d)

  • share_id (Key) — Primary key — NOT NULL
  • title (Field)
  • no (Field3)
  • views (Field5)
  • write_date (Field6)
  • user_id (Key2) — bigint — Foreign key → user.user_id — NOT NULL
  • trip_id (Key3) — Foreign key → trip.trip_id — NOT NULL

trip (trips)

  • trip_id (Key) — Primary key — NOT NULL
  • sido_code (Field)
  • gugun_code (Field2)
  • gugun_name (Field3)
  • image (Field4)
  • description (Field5)
  • latitude (Field6)
  • longitude (Field7)
  • tel (Field9)
  • addr (Field8)

user (users)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • password (Field2)
  • email (Field3)
  • region (Field4)

users (Untitled3)

  • 유저고유값 (id) — int — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4