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