swERD
Tables (15)
Airplane (비행기)
- ID (Key) — INT — Primary key — NOT NULL
- start_time (Field) — DATETIME
- end_time (Field2) — DATETIME
- dapartures (Field3) — VARCHAR(50)
- arrivals (Field4) — VARCHAR(50)
- price (Field5) — INT
- type (Field6) — INT
- travel_plan_id (Key2) — INT — Foreign key → TravelPlan.ID — NOT NULL
Comment (댓글)
- ID (Key) — INT — Primary key — NOT NULL
- main_text (Field3) — TEXT
- id_post (Key2) — INT — Foreign key → Post.ID — NOT NULL
- id_user (Key3) — INT — Foreign key → User.id — NOT NULL
Community (커뮤니티 종류)
- ID (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
DailyRoute (하루 일정)
- ID (Key) — INT — Primary key — NOT NULL
- date (Field6) — DATE
- hotel_check_in_time (Field7) — DATETIME
- hotel_check_out_time (Field8) — DATETIME
- travel_plan_id (Key3) — INT — Foreign key → TravelPlan.ID — NOT NULL
- id_plan_group_morning (Key2) — INT — Foreign key → PlanGroup.id — NOT NULL
- id_plan_group_afternoon (Key4) — INT — Foreign key → PlanGroup.id — NOT NULL
- id_plan_group_evening (Key5) — INT — Foreign key → PlanGroup.id — NOT NULL
- id_hotel (Key6) — INT — Foreign key → Hotel.ID — NOT NULL
DayOff (휴무일)
- ID (Key) — INT — Primary key — NOT NULL
- start_date (Field2) — DATE
- end_date (Field3) — DATE
- guide_id (Key2) — INT — Foreign key → Guide.id — NOT NULL
Guide (가이드)
- 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)
- license (Field8) — INT
GuideProduct (가이드 상품)
- ID (Key) — INT — Primary key — NOT NULL
- image (Field2) — VARCHAR(50)
- info (Field3) — TEXT
- price (Field4) — INT
- start_date (Field5) — DATE
- end_date (Field6) — DATE
- name (Field7) — 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)
- info (Field3) — TEXT
- check_in_time (Field4) — DATETIME
- check_out_time (Field5) — DATETIME
- price (Field6) — INT
PlanGroup (계획 묶음)
- id (Key) — INT — Primary key — NOT NULL
- tourist_spot_start_time (Field3) — DATETIME
- tourist_spot_end_time (Field4) — DATETIME
- restaurant_start_time (Field5) — DATETIME
- restaurant_end_time (Field6) — DATETIME
- id_restaurant (Key2) — INT — Foreign key → Restaurant.ID — NOT NULL
- id_tourist_spot (Key3) — INT — Foreign key → TouristSpot.ID — NOT NULL
Post (게시글)
- ID (Key) — INT — Primary key — NOT NULL
- title (Field2) — VARCHAR(50)
- main_text (Field3) — TEXT
- id_community (Key2) — INT — Foreign key → Community.ID — NOT NULL
- id_user (Key3) — INT — Foreign key → User.id — NOT NULL
Purchase (구매)
- ID (Key) — INT — Primary key — NOT NULL
- price (Field3) — INT
- purchase_date (Field4) — DATE
- start_date (Field5) — DATE
- end_date (Field6) — DATE
- user_id (Key2) — INT — Foreign key → User.id — NOT NULL
- guide_product_id (Key3) — INT — Foreign key → GuideProduct.ID — NOT NULL
Restaurant (음식점)
- ID (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- location (Field2) — VARCHAR(50)
- info (Field3) — TEXT
- opening_hours (Field4) — TEXT
- price (Field5) — INT
TouristSpot (관광지)
- ID (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- location (Field2) — VARCHAR(50)
- info (Field3) — TEXT
- opening_hours (Field4) — TEXT
TravelPlan (여행 계획)
- ID (Key) — INT — Primary key — NOT NULL
- total_expenses (Field2) — INT
- start_time (Field3) — DATETIME
- departures (Field4) — VARCHAR(50)
- user_id (Key2) — INT — Foreign key → User.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)