letsgo
Tables (13)
Accommodations (Untitled5)
- acc_id (Field) — INT — Primary key
- travel_id (Field22) — INT — Foreign key → TravelPlan.travel_id
- user_id (Field15) — INT — Foreign key → TravelPlan.user_id
- acc_name (Field2) — VARCHAR
- acc_address (Field3) — VARCHAR
- check_in (Field4) — TIME
- check_out (Field5) — TIME
- acc_image (Field6) — TEXT
BubbleChat (Untitled6)
- travel_id (Field22) — INT — Foreign key → TravelPlan.travel_id
- user_id (Field15) — INT — Foreign key → TravelPlan.user_id
- message (Field) — TEXT
Candidates (Untitled9)
- can_id (Field) — INT — Primary key
- location_id (Field3) — INT — Foreign key → Location.location_id
- travel_id (Field22) — INT — Foreign key → Location.travel_id
- user_id (Field4) — INT — Foreign key → FavoritList.user_id
- favorit_id (Field5) — INT — Foreign key → FavoritList.favorit_id
- can_name (Field2) — VARCHAR
FavoritList (Untitled3)
- favorit_id (Field) — INT — Primary key
- travel_id (Field2222) — INT — Foreign key
- user_id (Field1522) — INT — Foreign key
- user_id (Field4) — INT — Foreign key → User.user_id
- adress (Field2) — VARCHAR
- place_name (Field3) — VARCHAR
- list_name (Field5) — VARCHAR
Location (Untitled7)
- location_id (Field) — INT — Primary key
- travel_id (Field22) — INT — Foreign key → TravelPlan.travel_id
- user_id (Field15) — INT — Foreign key → TravelPlan.user_id
- location_name (Field3) — VARCHAR
- location_adress (Field4) — VARCHAR
- list_id (Field2) — INT
MyPlaceList (Untitled2)
- list_id (Field6) — INT — Primary key
- user_id (Field5) — INT — Foreign key → User.user_id
- user_id (Field) — INT
- location_url (Field3) — TEXT
- map_app (Field4) — TINYINT
- favorit_id (Field2) — INT
MyPlaceListMapping (Untitled11)
- list_id (Field6) — INT — Foreign key → MyPlaceList.list_id
- user_id (Field5) — INT — Foreign key → MyPlaceList.user_id
- mapping_id (Field) — INT
- place_name (Field3) — VARCHAR
- adress (Field4) — VARCHAR
- list_id (Field2) — INT
Route (Untitled12)
- route_id (Field) — INT — Primary key
- travel_id (Field22) — INT — Foreign key → TravelPlan.travel_id
- user_id (Field15) — INT — Foreign key → TravelPlan.user_id
- start_location (Field2) — VARCHAR
- end_location (Field3) — VARCHAR
- route_url (Field4) — TEXT
- Field5
TravelPlan (Untitled4)
- travel_id (Field2) — INT — Primary key
- user_id (Field15) — INT — Foreign key → User.user_id
- title (Field3) — VARCHAR
- region (Field4) — VARCHAR
- start_date (Field5) — DATE
- end_date (Field6) — DATE
- status (Field7) — TINYINT
- user_id (Field) — INT
- created_at (Field8) — DATETIME
- update_at (Field9) — DATETIME
- explain (Field10) — TEXT
- start_time (Field11) — TIME
- end_time (Field12) — TIME
TravelRoute (Untitled13)
- can_id (Field22) — INT — Foreign key → Voted.can_id
- travel_id (Field222) — INT — Foreign key → Voted.travel_id
- acc_id (Field4) — INT — Foreign key → Accommodations.acc_id
- user_id (Field152) — INT — Foreign key → Accommodations.user_id
- favorit_id (Field5) — INT — Foreign key → Voted.favorit_id
- route_id (Field) — INT
- route_title (Field2) — VARCHAR
- route_order (Field3) — INT
- place_name (Field6) — VARCHAR
- place_address (Field7) — VARCHAR
User (Untitled)
- user_id (Field) — INT — Primary key
- password (Field6) — VARCHAR
- name (Field2) — VARCHAR
- email (Field3) — VARCHAR
- phone (Field4) — VARCHAR
- profile_image (Field5) — TEXT
- resign_at (Field7) — DATETIME
- access_at (Field8) — DATETIME
- created_at (Field9) — DATETIME
- updated_at (Field10) — DATETIME
- status (Field11) — TINYINT
Vote (Untitled10)
- can_id (Field2) — INT — Foreign key → Candidates.can_id
- location_id (Field32) — INT — Foreign key → Candidates.location_id
- travel_id (Field22) — INT — Foreign key → Candidates.travel_id
- user_id (Field4) — INT — Foreign key → Candidates.user_id
- favorit_id (Field5) — INT — Foreign key → Candidates.favorit_id
- state (Field) — VARCHAR
- skip (Field3) — TINYINT
- vote_count (Field6) — INT
Voted (Untitled8)
- can_id (Field2) — INT — Foreign key → Vote.can_id
- location_id (Field32) — INT — Foreign key → Vote.location_id
- travel_id (Field22) — INT — Foreign key → Vote.travel_id
- user_id (Field4) — INT — Foreign key → Vote.user_id
- favorit_id (Field5) — INT — Foreign key → Vote.favorit_id
- rank (Field) — INT