Travel-App
Tables (8)
Route (경로)
- PK (route_id) — varchar(50) — Primary key — NOT NULL
- FK (transportation_type) — varchar(20) — Foreign key → Transportation.PK — NOT NULL
- Field (start_spot_id) — varchar(50)
- Field2 (end_spot_id) — varchar(50)
- Field (estimated_time) — varchar(20)
Schedule (일정 - 항목, 스팟 저장)
- Key (schedule_id) — varchar(50) — Primary key — NOT NULL
- FK (travel_id) — varchar(50) — Foreign key → Travel_List.PK — NOT NULL
- FK (user_id) — varchar(50) — Foreign key → Travel_List.FK — NOT NULL
- FK (spot_id) — varchar(50) — Foreign key → Spot_Info.PK — NOT NULL
- FK (route_id) — varchar(50) — Foreign key → Route.PK — NOT NULL
- Field (day_sequence) — int
- Field (element_sequence) — int
Spot_Info (스팟 정보)
- PK (spot_id) — varchar(50) — Primary key — NOT NULL
- FK (spot_type_number) — int — Foreign key → Spot_type.PK — NOT NULL
- Field (spot_name) — varchar(50)
- Field (spot_address) — varchar(100)
- Field (visit_available) — varchar(10)
- Field (business_hours) — varchar(10)
- Field2 (spot_tel) — varchar(20)
- Field (reservation) — int
- Field (preference_gender) — varchar(10)
- Field2 (prference_age) — varchar(10)
- Field3 (spot_rating) — int
Spot_Info_detail (스팟 상세 정보)
- PK (spot_id) — varchar(50) — Foreign key → Spot_Info.PK — NOT NULL
- Field (spot_facilities_type) — varchar(20)
Spot_type (스팟 유형)
- PK (spot_type_number) — int — Primary key — NOT NULL
- Field (spot_type_description) — varchar(20)
Transportation (이동수단)
- PK (transportation_type) — varchar(20) — Primary key — NOT NULL
- Field (transportation_type_descrition) — varchar(20)
Travel_List (여행 목록)
- PK (travel_id) — varchar(50) — Primary key — NOT NULL
- FK (user_id) — varchar(50) — Foreign key → Users.PK — NOT NULL
- Field (travel_region) — varchar(50)
- Field2 (start_date) — date
- Field (end_date) — date
- Field (companion_type) — varchar(20)
Users (유저 아이디)
- PK (user_id) — varchar(50) — Primary key — NOT NULL
- Field (user_gender) — varchar(10)
- Field2 (user_age) — varchar(10)