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