123
Tables (25)
Copy Of review_summary (요약 (옵션))
- summary_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- review_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- summary_text (키워드 요약 (선택)) — TEXT
- summary_update (Field) — DATETIME
Copy Of review_tag_mapping2 (리뷰 별 태그 명시)
- review_id (Key2) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- tag_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- review_id (Key2) — BIGINT — Foreign key — NOT NULL — AUTO_INCREMENT
- tag_id (Key) — BIGINT — Foreign key — NOT NULL — AUTO_INCREMENT
alarm (알림)
- alarm_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- code (Field) — VARCHAR(10)
- target_id (Field2) — BIGINT
- Field3
auth (권한)
- auth_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Field) — BIGINT
- auth_role (Field2) — VARCHAR(255)
cupon (쿠폰)
- cupon_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- cupon_type (Field) — INT
- cupon_reg_date (Field2) — DATETIME — 발급일을 의미
- cupon_end_date (Field5) — DATETIME
- is_valid (Field3) — boolean
customer_iq_board (고객문의)
- custom_iq_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_email (Key2) — VARCHAR(255) — NOT NULL
- category (Field) — VARCHAR(255) — NOT NULL
- title (Field2) — VARCHAR(255) — NOT NULL
- question (Field3) — TEXT
- is_secret (Field4) — BOOLEAN
- reg_date (Field5) — DATETIME — DEFAULT NOW()
- mod_date (Field6) — DATETIME — DEFAULT NOW()
- answer (Field7) — TEXT
- answer_reg_date (Field8) — DATETIME
customer_iq_file (고객문의 게시판 첨부 파일)
- iq_uuid (Key) — VARCHAR(255) — Primary key — NOT NULL
- custom_iq_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- save_dir (Field) — VARCHAR(255) — NOT NULL
- file_name (Field2) — VARCHAR(255) — NOT NULL
- file_type (Field3) — TINYINT — DEFAULT 0
- file_size (Field4) — BIGINT
- reg_date (Field5) — DATETIME — DEFAULT NOW()
deactivated_user (회원탈퇴)
- d_user_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- d_user_email (Field2) — VARCHAR(255) — NOT NULL
- d_user_name (Field3) — VARCHAR(255) — NOT NULL
- d_user_phone (Field) — VARCHAR(255)
- d_reason (Field4) — TEXT
- d_user_transfer_date (Field5) — DATETIME — NOT NULL — deactivated date
lodge (숙소)
- lodge_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- lodge_name (Field) — VARCHAR(200) — NOT NULL
- lodge_type (Field2) — VARCHAR(255) — NOT NULL
- lodge_addr (Field3) — VARCHAR(255) — NOT NULL
- facility (Field4) — INT — NOT NULL
- intro (Field5) — VARCHAR(255)
- description (Field6) — VARCHAR(255)
- business_number (Field7) — VARCHAR(255) — NOT NULL
- business_call (Field8) — VARCHAR(255)
- latitute (Field9) — DOUBLE
- longitute (Field10) — DOUBLE
lodge_img (숙소 이미지)
- lodge_img_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- lodge_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- lodge_img_url (Field) — VARCHAR(255) — NOT NULL
payment_before_payment (결제 전 저장할 구매 정보)
- payment_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- customer_key (Key2) — VARCHAR(255) — NOT NULL
- cupon_id (Key3) — BIGINT
- order_id (Field2) — VARCHAR(200) — NOT NULL
- cupon_price (Field3) — INT — NOT NULL
- strike_price (Field6) — INT
- order_name (Field4) — VARHCAR(100) — NOT NULL
- order_reg_date (Field) — DATETIME — DEFAULT NOW()
payment_cancel (결제 취소 정보를 저장할 테이블)
- payment_cancel_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- paymentkey (Key2) — VARCHAR(200) — NOT NULL
- last_transaction_key (Field2) — VARCHAR(128) — NOT NULL
- cancel_reason (Field3) — VARCHAR(255) — NOT NULL
- cancel_amount (Field4) — INT — NOT NULL
- refundable_amount (Field5) — INT — NOT NULL
- canceled_at (Field6) — DATETIME — NOT NULL
- raw_data (Field7) — TEXT
payment_receipt (결제 승인 시 정보를 저장할 테이블 (영수증))
- paymentkey (Key) — VARCHAR(200) — Primary key — NOT NULL
- order_id (Key2) — VARCHAR(200) — NOT NULL — AUTO_INCREMENT
- order_type (Field) — VARHCAR(50) — NOT NULL
- order_name (Field3) — VARCHAR(100) — NOT NULL
- order_status (Field4) — VARCHAR(128) — NOT NULL
- total_amount (Field5) — INT — NOT NULL
- method (Field6) — VARCHAR(100)
- order_requested (Field7) — DATETIME
- order_approved (Field8) — DATETIME
- last_transaction_key (Field9) — VARCHAR(128)
- raw_data (Field10) — TEXT
reservation (예약)
- reservation_id (Key2) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- room_id (Key) — BIGINT — NOT NULL
- user_id (Key4) — BIGINT — NOT NULL — AUTO_INCREMENT
- order_id (Key3) — VARCHAR(200) — NOT NULL
- start_date (Field) — DATETIME
- end_date (Field2) — DATETIME
- total_amount (Field6) — INT
- gusets_amount (Field3) — INT
- booking_status (Field4) — VARCHAR(255)
- reservation_reg_date (Field5) — DATETIME — DEFAULT NOW()
- reservation_type (Field7) — VARCHAR(10) — - stay 혹은 rent
review (리뷰)
- review_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (작성자 id) — BIGINT — NOT NULL — AUTO_INCREMENT
- lodge_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- reservation_id (Key22) — BIGINT — NOT NULL — AUTO_INCREMENT
- rating (별점) — INT — NOT NULL
- content (리뷰 본문) — TEXT
- ai_summary (AI 요약내용) — TEXT
- created_at (작성시각) — DATETIME — NOT NULL
- reported_count (Field) — INT
review_img (리뷰 이미지)
- review_uuid (Key) — VARCHAR(255) — Primary key — NOT NULL
- review_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- review_save_dir (Field) — VARCHAR(255) — NOT NULL
- review_file_name (Field2) — VARCHAR(255) — NOT NULL
- review_file_size (Field3) — BIGINT
- reg_date (Field4) — DATETIME
- mod_date (Field5) — DATETIME
review_likes (좋아요)
- likes_no (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- review_id (Key4) — BIGINT — NOT NULL — AUTO_INCREMENT
review_report (리뷰 신고)
- report_id (Key) — BIGINT — Primary key — NOT NULL
- review_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- user_id (Key3) — BIGINT — NOT NULL — AUTO_INCREMENT
review_tag (Untitled)
- tag_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- tag_name (태그명) — VARCHAR(50)
room (객실)
- room_id (Key) — BIGINT — Primary key — NOT NULL
- lodge_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- room_name (Field) — VARCHAR(255) — NOT NULL
- info (Field2) — VARCHAR(255) — NOT NULL
- rent_price (Field3) — INT — NOT NULL — - 대실 가격을 의미 - 대실이 없는 객실이면 null
- rent_option (Field5) — VARRCHAR(255)
- rent_time (Field6) — VARCHAR(255)
- stay_price (Field4) — INT — NOT NULL — DEFAULT 0 - 숙박 가격을 의미
- stay_time (Field7) — VARCHAR(255)
- stay_option (Field8) — VARCHAR(255)
- stock_count (Field9) — INT — 전체 객실 수
- standard_count (Field10) — INT
- max_count (Field11) — INT
room_img (객실 이미지)
- room_img_id (Key) — BIGINT — Primary key — NOT NULL
- room_id (Key2) — BIGINT — NOT NULL
- room_img_url (Field) — VARCHAR(255) — NOT NULL
search (검색)
- search_id (Key) — BIGINT — Primary key — NOT NULL
- search_type (Field) — VARCHAR(255) — NOT NULL
- keyword (Field2) — VARCHAR(255)
- jaso_keyword (Field3) — VARCHAR(255)
user (유저)
- user_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- password (Field) — VARCHAR(255)
- user_email (Field2) — VARCHAR(255) — NOT NULL
- user_name (Field3) — VARCHAR(255) — NOT NULL
- user_phone (Field14) — VARCHAR(255)
- user_uid (Field4) — VARCHAR(255)
- birthday (Field5) — VARCHAR(255)
- platform (Field6) — VARCHAR(255)
- user_terms_option (Field8) — Boolean — 마케팅 수신 동의
- is_adult (Field9) — Boolean
- email_certified (Field10) — Boolean
- customer_key (Field11) — VARCHAR(255) — user_uid + "_" + platform 별 앞글자
- user_favorite_tag (Field12) — INT
- user_grade (Field13) — VARCHAR(255) — NOT NULL — 유저등급 silver > gold > platinum
- user_created_date (Field15) — DATETIME — NOT NULL
- user_modify_date (Field16) — DATETIME
user_bookmark (관심숙소 등록)
- user_bookmark_no (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- lodge_id (Field)
ways (오시는 길)
- ways_id (Key) — BIGINT — Primary key — NOT NULL
- lodge_id (Key2) — BIGINT — NOT NULL — AUTO_INCREMENT
- content (Field) — VARCHAR(255) — NOT NULL