SeoulTour

Tables (10)

Calendar (Untitled8)

  • calendar_id (PK) — int — Primary key — NOT NULL
  • fav_place_id (PK2) — int — Foreign key → FavPlace.fav_place_id — NOT NULL
  • map_id (PK22) — int — Foreign key → FavPlace.map_id — NOT NULL
  • user_id (PK222) — int — Foreign key → FavPlace.user_id — NOT NULL
  • fav_place_id (Field2) — int
  • user_id (Field) — int
  • tour_start_date (Field3) — varchar
  • tour_end_date (Field4) — varchar
  • place_name (Field5) — varchar
  • schedule_time (Field6) — varchar
  • schedule_date (Field7) — varchar
  • memo (Field8) — TEXT
  • Field9

CalendarDetails (CopyOfUntitled7)

  • calendar_details_id (PK) — int — Primary key — NOT NULL
  • calendar_id (PK2) — int — Foreign key → Calendar.calendar_id — NOT NULL
  • fav_place_id (PK22) — int — Foreign key → Calendar.fav_place_id — NOT NULL
  • map_id (PK222) — int — Foreign key → Calendar.map_id — NOT NULL
  • user_id (PK2222) — int — Foreign key → Calendar.user_id — NOT NULL
  • calendar_id (Field14) — int
  • place_name (Field) — varchar
  • place_image (Field6) — varchar(255)
  • operation_time (Field2) — varchar
  • operation_date (Field3) — varchar
  • day_off (Field4) — varchar
  • place_location (Field5) — varchar
  • place_contact_num (Field7) — varchar
  • place_details_info (Field10) — TEXT
  • schedule_time (Field8) — varchar
  • schedule_date (Field9) — varchar
  • memo (Field15) — TEXT
  • Field11

DeliveryInfo (Untitled9)

  • delivery_info_id (PK) — int — Primary key — NOT NULL
  • user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
  • user_id (Field) — int
  • receiver_name (Field2) — varchar
  • receiver_phone (Field3) — CHAR(11)
  • main_address (Field4) — varchar
  • details_address (Field5) — varchar
  • zip_code (Field7) — varchar
  • expected_delivery (Field6) — TIMESTAMP

FavPlace (Untitled7)

  • fav_place_id (PK) — int — Primary key — NOT NULL
  • map_id (PK2) — int — Foreign key → Map.map_id — NOT NULL
  • user_id (PK22) — int — Foreign key → Map.user_id — NOT NULL
  • user_id (Field12) — int
  • place_name (Field) — varchar
  • place_image (Field6) — varchar(255)
  • place_location (Field5) — varchar
  • place_details_info (Field10) — TEXT
  • like_status (Field11) — boolean

Map (Untitled2)

  • map_id (PK) — int — Primary key — NOT NULL
  • user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
  • user_id (Field4) — int
  • latitude (Field) — varchar
  • longtitude (Field2) — varchar
  • place_name (Field3) — varchar
  • place_image (Field5) — varchar(255)
  • place_info (Field6) — TEXT
  • place_details_info (Field11) — TEXT
  • operation_time (Field7) — varchar
  • operation_date (Field8) — varchar
  • place_location (Field9) — varchar
  • place_contact_num (Field10) — varchar

Order (Untitled4)

  • order_id (Key) — int — Primary key — NOT NULL
  • goods_id (PK) — int — Foreign key → TraditionalGoods.goods_id — NOT NULL
  • user_id (PK2) — int — Foreign key → TraditionalGoods.user_id — NOT NULL
  • payment_id (Field) — int
  • goods_id (Field2) — int
  • quantity (Field3) — int
  • total_price (Field4) — int
  • order_status (Field5) — varchar

Payment (Untitled3)

  • payment_id (PK) — int — Primary key — NOT NULL
  • order_id (Key) — int — Foreign key → Order.order_id — NOT NULL
  • goods_id (PK2) — int — Foreign key → Order.goods_id — NOT NULL
  • user_id (PK22) — int — Foreign key → Order.user_id — NOT NULL
  • user_id (PK3) — int — Foreign key → User.user_id — NOT NULL
  • user_id (Field) — int
  • imp_uid (Field3) — varchar
  • merchant_uid (Field4) — varchar
  • payment_card (Field6) — CHAR(16)
  • total_price (Field2) — int
  • payment_date (Field5) — TIMESTAMP
  • payment_status (Field7) — varchar

Statistic (Untitled6)

  • statistic_id (PK) — int — Primary key — NOT NULL
  • Field
  • Field2

TraditionalGoods (Untitled5)

  • goods_id (PK) — int — Primary key — NOT NULL
  • user_id (PK2) — int — Foreign key → User.user_id — NOT NULL
  • goods_name (Field) — varchar
  • goods_image (Field4) — varchar(255)
  • price (Field2) — int
  • stock_quantity (Field3) — int
  • sale_start_time (Field5) — TIMESTAMP
  • sale_end_time (Field10) — TIMESTAMP
  • goods_size (Field6) — varchar
  • goods_weight (Field7) — varchar
  • summary (Field8) — TEXT
  • category (Field9) — varchar

User (Untitled)

  • user_id (PK) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — CHAR(72)
  • user_name (Field3) — varchar
  • created_at (Field4) — TIMESTAMP
  • deleted_at (Field5) — TIMESTAMP