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