wepl

Tables (15)

Category (카테고리)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • FoursquareCategoryID (Field2) — INT

Comment (댓글)

  • ID (Key) — INT — Primary key — NOT NULL
  • main_text (Field) — TEXT
  • WriteDate (Field2) — DATETIME
  • user_id (Key3) — INT — Foreign key → User.ID — NOT NULL
  • Review_ID (Key2) — INT — Foreign key → Review.ID — NOT NULL
  • RecruitPeople_ID (Key4) — INT — Foreign key → RecruitPeople.ID — NOT NULL

DailyRoute (하루 일정)

  • ID (Key) — INT — Primary key — NOT NULL
  • date (Field) — DATE
  • start_time (Field4) — TIME
  • end_time (Field5) — TIME
  • hotel_in_time (Field2) — DATETIME
  • hotel_out_time (Field3) — DATETIME
  • tourist_spot_start_time (Field6) — TIME
  • tourist_spot_end_time (Field7) — TIME
  • restaurant_start_time (Field8) — TIME
  • restaurant_end_time (Field9) — TIME
  • weather (Field10) — VARCHAR(30)
  • travel_plan_id (Key2) — INT — Foreign key → TravelPlan.ID — NOT NULL
  • hotel_ID (Key3) — INT — Foreign key → Hotel.ID — NOT NULL
  • Restaurant_ID (Key4) — INT — Foreign key → Restaurant.ID — NOT NULL
  • TouristSpot_ID (Key5) — INT — Foreign key → TouristSpot.ID — NOT NULL

DayOff (휴무일)

  • ID (Key) — INT — Primary key — NOT NULL
  • start_date (Field) — DATE
  • end_date (Field2) — DATE
  • Guide_ID (Key2) — INT — Foreign key → Guide.ID — NOT NULL

Guide (가이드)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • Field2 — VARCHAR(50)
  • password (Field3) — VARCHAR(50)
  • phone_num (Field4) — INT
  • sex (Field5) — VARCHAR(10)
  • age (Field6) — INT
  • country (Field7) — VARCHAR(30)
  • license (Field8) — INT

GuideProduct (가이드 상품)

  • ID (Key) — INT — Primary key — NOT NULL
  • image (Field) — VARCHAR(50)
  • info (Field2) — TEXT
  • price (Field3) — INT
  • start_date (Field4) — DATE
  • end_date (Field5) — DATE
  • name (Field6) — VARCHAR(50)
  • Guide_ID (Key2) — INT — Foreign key → Guide.ID — NOT NULL

Hotel (호텔)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • location (Field2) — VARCHAR(50)
  • latitude (Field7) — DOUBLE
  • longitude (Field8) — DOUBLE
  • info (Field3) — TEXT
  • check_in_time (Field4) — DATETIME
  • chech_out_time (Field5) — DATETIME
  • price (Field6) — INT

Purchase (구매)

  • ID (Key) — INT — Primary key — NOT NULL
  • price (Field) — INT
  • purchase_date (Field2) — DATE
  • start_date (Field3) — DATE
  • end_date (Field4) — DATE
  • user_ID (Key2) — INT — Foreign key → User.ID — NOT NULL
  • GuideProduct_ID (Key3) — INT — Foreign key → GuideProduct.ID — NOT NULL

RecruitPeople (여행 동행자 모집)

  • ID (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(50)
  • main_text (Field2) — TEXT
  • join_People (Field3) — INT
  • limit_People (Field4) — INT
  • Place_name (Field5) — VARCHAR(50)
  • user_ID (Key2) — INT — Foreign key → User.ID — NOT NULL
  • Join_user_ID (Key3) — INT — Foreign key → User.ID — NOT NULL
  • WriteDate (Field6) — DATETIME
  • RecruitDate (Field7) — DATETIME

Restaurant (음식점)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • location (Field2) — VARCHAR(50)
  • latitude (Field6) — DOUBLE
  • longitude (Field7) — DOUBLE
  • info (Field3) — TEXT
  • opening_hours (Field4) — TEXT
  • price (Field5) — INT

Review (리뷰)

  • ID (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(50)
  • main_text (Field2) — TEXT
  • WriteDate (Field5) — DATETIME
  • rate (Field3) — DOUBLE
  • like (Field4) — INT
  • user_id (Key2) — INT — Foreign key → User.ID — NOT NULL
  • TravelPlan_ID (Key3) — INT — Foreign key → TravelPlan.ID — NOT NULL

SavedTravelPlan (여행 플랜 저장)

  • ID (Key) — INT — Primary key — NOT NULL
  • user_ID (Key3) — INT — Foreign key → User.ID — NOT NULL
  • TravelPlan_ID (Key2) — INT — Foreign key → TravelPlan.ID — NOT NULL
  • DailyRoute_ID (Key7) — INT — Foreign key → DailyRoute.ID — NOT NULL
  • hotel_ID (Key4) — INT — Foreign key → DailyRoute.ID — NOT NULL
  • Restaurant_ID (Key5) — INT — Foreign key → DailyRoute.ID — NOT NULL
  • TouristSpot_ID (Key6) — INT — Foreign key → DailyRoute.ID — NOT NULL

TouristSpot (관광지)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • location (Field2) — VARCHAR(50)
  • latitude (Field5) — Double
  • longitude (Field6) — Double
  • info (Field3) — TEXT
  • opening_hours (Field4) — TEXT
  • price (Field7) — INT

TravelPlan (여행계획)

  • ID (Key) — INT — Primary key — NOT NULL
  • total_expenses (Field) — INT
  • start_date (Field2) — DATE
  • end_date (Field4) — DATE
  • City (Field3) — VARCHAR(30)
  • vehicle_type (Field5) — VARCHAR(30)
  • user_id (Key2) — INT — Foreign key → User.ID — NOT NULL
  • Category_ID (Key3) — INT — Foreign key → Category.ID — NOT NULL

User (유저)

  • ID (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • email (Field2) — VARCHAR(50)
  • password (Field3) — VARCHAR(50)
  • phone_num (Field4) — INT
  • sex (Field5) — VARCHAR(10)
  • age (Field6) — INT
  • country (Field7) — VARCHAR(30)
  • credit (Field8) — INT