가볼까

테이블 (10)

Accommodations (Untitled5)

  • acc_id (Field) — INT — 기본 키
  • travel_id (Field22) — INT — 외래 키 → TravelPlan.travel_id
  • user_id (Field15) — INT — 외래 키 → 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 — 외래 키 → TravelPlan.travel_id
  • user_id (Field15) — INT — 외래 키 → TravelPlan.user_id
  • message (Field) — TEXT

Candidates (Untitled9)

  • can_id (Field) — INT — 기본 키
  • list_id (Field22) — INT — 외래 키 → Location.list_id
  • favorit_id (Field222) — INT — 외래 키 → Location.favorit_id
  • user_id (Field5) — INT — 외래 키 → Location.user_id
  • can_name (Field2) — VARCHAR

FavoritList (Untitled3)

  • favorit_id (Field22) — INT — 외래 키 → MyPlace.favorit_id
  • user_id (Field5) — INT — 외래 키 → MyPlace.user_id
  • favorit_id (Field) — INT
  • adress (Field2) — VARCHAR
  • place_name (Field3) — VARCHAR

Location (Untitled7)

  • list_id (Field2) — INT — 기본 키
  • favorit_id (Field22) — INT — 외래 키 → FavoritList.favorit_id
  • user_id (Field5) — INT — 외래 키 → FavoritList.user_id
  • location_id (Field) — INT
  • location_name (Field3) — VARCHAR
  • location_adress (Field4) — VARCHAR

MyPlace (Untitled2)

  • favorit_id (Field2) — INT — 기본 키
  • user_id (Field5) — INT — 외래 키 → User.user_id
  • user_id (Field) — INT
  • location_url (Field3) — TEXT
  • map_app (Field4) — TINYINT

TravelPlan (Untitled4)

  • travel_id (Field2) — INT — 기본 키
  • user_id (Field15) — INT — 외래 키 → 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

User (Untitled)

  • user_id (Field) — INT — 기본 키
  • 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 — 외래 키 → Candidates.can_id
  • list_id (Field22) — INT — 외래 키 → Candidates.list_id
  • favorit_id (Field222) — INT — 외래 키 → Candidates.favorit_id
  • user_id (Field5) — INT — 외래 키 → Candidates.user_id
  • state (Field) — TINYINT
  • skip (Field3) — TINYINT

Voted (Untitled8)

  • can_id (Field2) — INT — 외래 키 → Vote.can_id
  • list_id (Field22) — INT — 외래 키 → Vote.list_id
  • favorit_id (Field222) — INT — 외래 키 → Vote.favorit_id
  • user_id (Field5) — INT — 외래 키 → Vote.user_id
  • Field