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)