가볼까
테이블 (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