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)