yedambnb_pj

Tables (5)

Description (유저)

  • user_no (회원번호) — PRIMARY KEY
  • user_id (아이디) — NOT NULL UNIQUE
  • user_pw (패스워드) — NOT NULL
  • user_name (이름)
  • birth_date (생년월일) — (YYYY-MM-DD)
  • telephone (전화번호) — 전화번호
  • user_authority (유저권한) — DEFAULT 'user' NOT NULL

tbl_booking (예약)

  • booking_id (결제번호) — pk_booking PRIMARY KEY
  • user_id (유저ID) — NOT NULL
  • lodging_no (숙소No) — NOT NULL
  • user_name (유저이름) — NOT NULL
  • price_per_night (1박 가격) — NOT NULL
  • check_in_date (체크인 날짜) — NOT NULL
  • check_out_date (체크아웃 날짜) — NOT NULL
  • member_count (인원) — DEFAULT 1 NOT NULL
  • fee (수수료) — DEFAULT 0
  • total_price (총금액)
  • booking_status (예약여부('UPCOMING', 'PAST', 'CANCELED')) — DEFAULT 'UPCOMING' NOT NULL

tbl_lodging (숙소)

  • lodging_id (숙소ID) — PRIMARY KEY
  • lodging_no (숙소번호) — NOT NULL
  • name (숙소이름) — NOT NULL
  • description (상세설명)
  • address (숙소위치) — NOT NULL
  • lat (숙소위치(위도))
  • lng (숙소위치(경도))
  • price_per_night (1박 가격) — DEFAULT 0

tbl_review (리뷰)

  • review_id (리뷰ID) — pk_review PRIMARY KEY
  • user_id (유저ID) — NOT NULL
  • user_name (유저이름)
  • lodging_no (숙소ID) — NOT NULL
  • score (총점수)
  • comment_text (내용)

tbl_wishlist (위시리스트)

  • wishlist_id (위시리스트 고유번호) — PRIMARY KEY
  • user_id (사용자ID) — FOREIGNER KEY UNIQUE NOT NULL
  • accommodation_id (숙소ID) — FOREIGNER KEY UNIQUE NOT NULL
  • created_at (등록일자) — DEFAULT SYSDATE