berry_TEAM_PROJECT

Tables (27)

alarm (알림)

  • alarm_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — 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 — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • cupon_type (Key3) — INT — Foreign key → cupon_template.쿠폰템플릿ID — NOT NULL
  • cupon_reg_date (Field2) — DATETIME — 발급일을 의미
  • cupon_end_date (Field5) — DATETIME
  • is_valid (Field3) — boolean

cupon_template (쿠폰 템플릿)

  • 쿠폰템플릿ID (ct_id) — LONG — Primary key — NOT NULL
  • 쿠폰 유형 (cupon_type) — INT
  • 쿠폰 이름 (cupon_title) — VARCHAR
  • 할인 금액 (cupon_price) — LONG
  • 최소 결제 금액 (the_minimum_amount) — LONG
  • 쿠폰 이미지 이름 (cupon_img_name) — VARCHAR
  • 유효기간 (cupon_end_date) — TIMESTAMP
  • 수량 (qty) — LONG

customer_iq_board (고객문의)

  • custom_iq_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • user_email (Key2) — VARCHAR(255) — Foreign key → user.user_id — 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 — Foreign key → customer_iq_board.custom_iq_id — 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 — Foreign key → user.user_id — 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

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)
  • business_number (Field7) — VARCHAR(255) — NOT NULL
  • business_call (Field8) — VARCHAR(255)
  • latitute (Field9) — DOUBLE
  • longitute (Field10) — DOUBLE

lodge_description (숙소 이용 정보)

  • 숙소 이용 정보 Id (lodge_description_id) — long — Primary key — NOT NULL
  • lodge_id (Key) — BIGINT — Foreign key → lodge.lodge_id — NOT NULL — AUTO_INCREMENT
  • 제목 (title) — varchar(255)
  • 내용 (content) — longtext

lodge_img (숙소 이미지)

  • lodge_img_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • lodge_id (Key2) — BIGINT — Foreign key → lodge.lodge_id — 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) — Foreign key → user.user_id — NOT NULL
  • cupon_id (Key3) — BIGINT — Foreign key → cupon.cupon_id
  • method (Field7) — VARCHAR(255)
  • order_id (Field2) — VARCHAR(200) — NOT NULL
  • cupon_price (Field3) — long — NOT NULL
  • strike_price (Field6) — long
  • pbp_total_amount (Field5) — long
  • 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) — Foreign key → payment_receipt.paymentkey — NOT NULL
  • transaction_key (Field2) — VARCHAR(128) — NOT NULL
  • cancel_reason (Field3) — VARCHAR(255) — NOT NULL
  • cancel_amount (Field4) — 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) — Foreign key → payment_before_payment.payment_id — 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) — long — 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 — Foreign key → room.room_id — NOT NULL
  • user_id (Key4) — BIGINT — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • order_id (Key3) — VARCHAR(200) — Foreign key → payment_before_payment.payment_id — NOT NULL
  • start_date (Field) — DATETIME
  • end_date (Field2) — DATETIME
  • total_amount (Field6) — INT
  • gusets_amount (Field3) — INT
  • booking_status (Field4) — VARCHAR(20)
  • 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 — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • lodge_id (Key2) — BIGINT — Foreign key → lodge.lodge_id — NOT NULL — AUTO_INCREMENT
  • reservation_id (Key22) — BIGINT — Foreign key → reservation.reservation_id — NOT NULL — AUTO_INCREMENT
  • rating (별점) — INT — NOT NULL
  • content (리뷰 본문) — TEXT
  • ai_summary (AI 요약내용) — TEXT
  • created_at (작성시각) — DATETIME — NOT NULL
  • reported_count (Field) — INT

review_image (리뷰 이미지)

  • review_uuid (Key) — VARCHAR(255) — Primary key — NOT NULL
  • review_id (Key2) — BIGINT — Foreign key → review.review_id — 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 — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • review_id (Key4) — BIGINT — Foreign key → review.review_id — NOT NULL — AUTO_INCREMENT

review_report (리뷰 신고)

  • report_id (Key) — BIGINT — Primary key — NOT NULL
  • review_id (Key2) — BIGINT — Foreign key → review.review_id — NOT NULL — AUTO_INCREMENT
  • user_id (Key3) — BIGINT — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT

review_summary (AI 요약 (옵션))

  • summary_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • review_id (Key2) — BIGINT — Foreign key → review.review_id — NOT NULL — AUTO_INCREMENT
  • summary_text (숙소별 리뷰 요약) — TEXT
  • summary_update (Field) — DATETIME

review_tag (Untitled)

  • tag_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • tag_name (태그명) — VARCHAR(50)

review_tag_mapping (리뷰 별 태그 명시)

  • mapping_id (Key3) — BIGINT — Primary key — NOT NULL
  • review_id (Key2) — BIGINT — Foreign key → review.review_id — NOT NULL — AUTO_INCREMENT
  • tag_id (Key) — BIGINT — Foreign key → review_tag.tag_id — NOT NULL — AUTO_INCREMENT

room (객실)

  • room_id (Key) — BIGINT — Primary key — NOT NULL
  • lodge_id (Key2) — BIGINT — Foreign key → lodge.lodge_id — 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 — Foreign key → room.room_id — NOT NULL
  • room_img_url (Field) — VARCHAR(255) — NOT NULL

search (검색)

  • 검색 ID (search_id) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • lodge_id (Key2) — BIGINT — Foreign key → lodge.lodge_id — 검색 타입이 숙소인 경우 lodge_id를 저장 지역일 경우 null
  • 키워드 (keyword) — VARCHAR(255) — NOT NULL
  • 상세 (detail) — VARCHAR(255) — NOT NULL
  • 키워드 자소 분리 (jaso_keyword) — VARCHAR(255) — NOT NULL
  • 상세 자소 분리 (jaso_detail) — VARCHAR(255) — NOT NULL

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) — NOT NULL — google 인 경우에는 "GOOGLE_NUMBERS" 라는 문구 저장
  • user_uid (Field4) — VARCHAR(255) — NOT NULL
  • birthday (Field5) — VARCHAR(255) — NOT NULL — yyyymmdd 형태
  • provider (Field6) — VARCHAR(255) — NOT NULL
  • user_terms_option (Field8) — Boolean — NOT NULL — 마케팅 수신 동의
  • is_adult (Field9) — Boolean — NOT NULL
  • is_email_certified (Field10) — Boolean — NOT NULL
  • is_email_certified (Field17) — Boolean
  • customer_key (Field11) — VARCHAR(255) — NOT NULL — user_uid + "_" + platform 별 앞글자
  • user_favorite_tag (Field12) — INT — NOT NULL
  • user_grade (Field13) — VARCHAR(255) — NOT NULL — 유저등급 silver > gold > platinum
  • user_created_date (Field15) — DATETIME — NOT NULL
  • user_modify_date (Field16) — DATETIME
  • user_lastLogin (Field7) — DATETIME
  • user_grade_point (Field18) — INT
  • review_ban (Field19) — Boolean

user_bookmark (관심숙소 등록)

  • user_bookmark_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL — AUTO_INCREMENT
  • lodge_id (Field)

ways (오시는 길)

  • ways_id (Key) — BIGINT — Primary key — NOT NULL
  • lodge_id (Key2) — BIGINT — Foreign key → lodge.lodge_id — NOT NULL — AUTO_INCREMENT
  • content (Field) — VARCHAR(255) — NOT NULL