YBE_TOY3

Tables (6)

location (Untitled3)

  • location_id (locationId) — NotNull — Primary key — NOT NULL
  • itinerary_id (itineraryId) — NotNull — Foreign key → Itinerary.itinerary_id — NOT NULL
  • location_name (locationName) — NotNull

Comment (Untitled6)

  • comment_id (commentId) — NotNull — Primary key — NOT NULL
  • user_id (userId) — NotNull — Foreign key → User.user_id — NOT NULL
  • trip_id (tripId) — NotNull — Foreign key → Trip.trip_id — NOT NULL
  • content — NotNull

Itinerary (Untitled2)

  • itinerary_id (itineraryId) — NotNull — Primary key — NOT NULL
  • trip_id (tripId) — NotNull — Foreign key → Trip.trip_id — NOT NULL
  • accomodation — NotNull
  • arrive_city (arriveCity) — NotNull
  • check_in_time (checkInTime) — NotNull
  • check_out_time (checkOutTime) — NotNull
  • citiy_arrive_time (cityArriveTime) — NotNull
  • city_dpart_time (cityDepartTime) — NotNull
  • depart_city (departCity) — NotNull
  • itinerary_name (itineraryName) — NotNull
  • place_arrive_time (placeArriveTime) — NotNull
  • place_depart_time (placeDepartTime) — NotNull
  • place_name (placeName) — NotNull
  • transprtation (transportation) — NotNull

Likes (Untitled5)

  • user_id (userId) — NotNull — Foreign key → User.user_id — NOT NULL
  • trip_id (tripId) — NotNull — Foreign key → Trip.trip_id — NOT NULL

Trip (Untitled)

  • trip_id (tripId) — NotNull — Primary key — NOT NULL
  • user_id (userId) — NotNull — Foreign key → User.user_id — NOT NULL
  • trip_end_date (tripEndDate) — NotNull
  • trip_name (tripName) — NotNull
  • trip_start_date (tripStartDate) — NotNull
  • trip_type (tripType) — NotNull
  • like_count (likeCount)
  • Field2

User (Untitled4)

  • user_id (userId) — NotNull — Primary key — NOT NULL
  • email — NotNull
  • user_name (userName) — NotNull
  • password — NotNull
  • like — NotNull
  • Field