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