hotel
Tables (8)
Hotel (호텔)
- hotel_id (호텔ID) — BIGINT — Primary key — NOT NULL
- name (호텔명) — VARCHAR(100) — NOT NULL
Point (포인트)
- point_id (포인트ID) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- amount (포인트수량) — BIGINT — NOT NULL
- create_at (생성일) — DATETIME — NOT NULL
- type (포인트타입) — VARCHAR(20) — NOT NULL — 적립, 소멸, 회수, 사용
Reservation (예약)
- resv_code (예약코드) — VARCHAR(255) — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- room_id (객실ID) — BIGINT — Foreign key → Room.room_id — NOT NULL
- person_number (예약인원) — TINYINT — NOT NULL
- check_in (체크인날짜) — DATETIME — NOT NULL
- check_out (체크아웃날짜) — DATETIME — NOT NULL
- cancel (취소여부) — TINYINT(1) — NOT NULL — false
- created_at (예약생성일) — DATETIME — NOT NULL
Review (리뷰)
- review_id (리뷰ID) — BIGINT — Primary key — NOT NULL
- resv_code (예약코드) — VARCHAR(30) — Foreign key → Reservation.resv_code — NOT NULL
- view_flag (노출여부) — TINYINT(1) — NOT NULL
- content (내용) — TEXT — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
ReviewImage (리뷰 이미지)
- image_id (리뷰이지미ID) — BIGINT — Primary key — NOT NULL
- image_url (이미지 경로) — VARCHAR(255) — NOT NULL
- review_id (리뷰ID) — BIGINT — Foreign key → Review.review_id — NOT NULL
Room (객실)
- room_id (객실ID) — BIGINT — Primary key — NOT NULL
- hotel_id (호텔ID) — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
- name (객실명) — VARCHAR(100) — NOT NULL
- capacity (숙박인원) — TINYINT — NOT NULL
- floor (층) — TINYINT — NOT NULL
- bathtub_flag (욕조여부) — TINYINT(1) — NOT NULL
- view_type (전망) — TINYINT — NOT NULL — 0:city, 1:ocean, 2:mountain
- created_at (생성일) — DATETIME — NOT NULL
- Field
RoomImage (객실 이미지)
- image_id (이미지ID) — BIGINT — Primary key — NOT NULL
- room_id (객실ID) — BIGINT — Foreign key → Room.room_id — NOT NULL
- image_url (이미지경로) — VARCHAR(255) — NOT NULL
User (사용자)
- user_id (사용자ID) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(20) — NOT NULL
- login_id (로그인아이디) — VARCHAR(20) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL