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