hotel_promotion

Tables (10)

address (주소)

  • post_code (Key) — int — Primary key — NOT NULL
  • sido_kr (Field) — varchar
  • sido_en (Field2) — varchar
  • gugun_code (Field3) — varchar
  • sort (Field4) — int
  • hotel_cnt (Field5) — int
  • reg_date (Field6) — dateTime

hotel (호텔)

  • hotel_seqy (Key) — int — Primary key — NOT NULL
  • post_code (Key2) — int — Foreign key → address.post_code — NOT NULL
  • user_id (Key3) — int — Foreign key → user.user_id — NOT NULL
  • hotel_name (Field2) — varchar
  • promotion_cnt (Field3) — int
  • wish_cnt (Field4) — int
  • reg_date (Field5) — dateTime

hotel_promition (프로모션)

  • hotel_promotion_id (Key3) — int — Primary key — NOT NULL
  • hotel_seqy (Key) — int — Foreign key → hotel.hotel_seqy — NOT NULL
  • promotion_title (Field) — varchar
  • promotion_sub_title (Field3) — varchar
  • promotion_detail_info (Field9) — varchar
  • promotion_data (Field6) — varchar
  • reservation_start_date (Field10) — varchar
  • reservation_end_date (Field11) — varchar
  • stay_start_date (Field12) — varchar
  • stay_end_date (Field13) — varchar
  • promotion_price (Field14) — varchar
  • promotion_phone (Field5) — varchar
  • promotion_ranking (Field2) — int

img (호텔사진)

  • content_id (Key) — int — Primary key — NOT NULL
  • hotel_promotion_id (Key3) — int — Foreign key → hotel_promition.hotel_promotion_id — NOT NULL
  • hotel_seqy (Key2) — int — Foreign key → hotel_promition.hotel_seqy — NOT NULL
  • origin_img (Field) — varchar
  • thumb_img (Field3) — varchar

img (프로모션 상품 이미지)

  • img_id (Key) — varchar — Primary key — NOT NULL
  • promotion_content_id (Key2) — int — Foreign key → promotion_content.promotion_content_id — NOT NULL
  • img (Field) — varchar

promotionList (찜리스트)

  • promotion_list_id (Key) — int — Primary key — NOT NULL
  • hotel_promotion_id (Key33) — int — Foreign key → hotel_promition.hotel_promotion_id — NOT NULL
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
  • isLike (Field) — boolean

promotion_category (카테고리)

  • category_id (Key) — int — Primary key — NOT NULL
  • hotel_promotion_id (Key3) — int — Foreign key → hotel_promition.hotel_promotion_id — NOT NULL
  • category_main_title (Field) — varchar
  • category_sub_title (Field2) — varchar
  • category_notice_info (Field11) — varchar

promotion_content (프로모션 상품구성)

  • promotion_content_id (Key) — int — Primary key — NOT NULL
  • hotel_promotion_id (Key3) — int — Foreign key → hotel_promition.hotel_promotion_id — NOT NULL
  • promotion_content_main_title (Field) — varchar
  • promotion_content_sub_title (Field2) — varchar
  • promotion_content_detail_info (Field3) — varchar
  • promotion_content_notice (Field4) — varchar

user (사용자)

  • user_id (Key) — int — Primary key — NOT NULL
  • user_name (Field) — varchar
  • password (Field2) — varchar

wishList (위시리스트)

  • wish_list_id (Key) — int — Primary key — NOT NULL
  • hotel_promotion_id (Key33) — int — Foreign key → hotel_promition.hotel_promotion_id — NOT NULL
  • user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
  • isLike (Field) — boolean