hotel
테이블 (15)
결제 (payments)
- pay_id (Key) — int — 기본 키 — NOT NULL
- reservation_id (Key4) — int — 외래 키 → 예약.reservation_id — NOT NULL
- total (Field) — int
- paid (Field2) — int
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
- status (Field5) — varchar(255)
결제수단 (payment_types)
- payment_type_id (Key) — int — 기본 키 — NOT NULL
- type (Field) — varchar(20)
- type_code (Field2) — int
- card_number (Field3) — varchar(255)
- approve_no (Field4) — varchar(20)
- acquire_status (Field5) — varchar(20)
- issuer_code (Field6) — varchar(20)
- acquirer_code (Field7) — varchar(20)
- acquirer_status (Field8) — varchar(25)
- pay_id (Key2) — int — 외래 키 → 결제.pay_id — NOT NULL
공지 (notice)
- notice_id (Key) — int — 기본 키 — NOT NULL
- content (Field) — varchar(100)
- usage_guide (Field2) — varchar(100)
- introduction (Field5) — varchar(100)
- own_hotel_id (Key2) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL
리뷰 (reviews)
- review_id (Key) — int — 기본 키 — NOT NULL
- score (Field) — float
- content (Field2) — varchar(80)
- user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
- hotel_id (Key3) — int — 외래 키 → 숙소.hotel_id — NOT NULL
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
리뷰답변 (review_replies)
- reveiw_reply_id (Key) — int — 기본 키 — NOT NULL
- created_at (Field) — timestamp
- updated_at (Field2) — timestamp
- is_del (Field3) — boolean
- review_id (Key2) — int — 외래 키 → 리뷰.review_id — NOT NULL
- reply_content (Field4) — varchar(50)
리뷰사진테이블 (review_picutres)
- review_picture_id (Key) — int — 기본 키 — NOT NULL
- picture_name (Field) — varchar(20)
- picture_path (Field2) — varchar(20)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
- review_id (Key2) — int — 외래 키 → 리뷰.review_id — NOT NULL
북마크 (bookmarks)
- bookmark_id (Key) — nt — 기본 키 — NOT NULL
- user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
- hotel_id (Key3) — int — 외래 키 → 숙소.hotel_id — NOT NULL
- created_at (Field) — timstamp
- updated_at (Field2) — timestamp
소유숙소 (own_hotels)
- own_hotel_id (Key) — int — 기본 키 — NOT NULL
- price (Field3) — bigint
- count_room (Field) — int
- created_at (Field2) — timestamp
- updated_at (Field4) — timestamp
- check_in (Field5) — TIME
- check_out (Field6) — TIME
- hotel_id (Key2) — int — 외래 키 → 숙소.hotel_id — NOT NULL
- room_name (Field7) — varchar(100)
- room_type (Field8) — varchar(50)
- max_person (Field9) — int
- min_person (Field10) — int
- owner_discount (Field11) — double
- platform_discount (Field12) — double
소유숙소사진 (own_hotel_pictures)
- own_hotel_picture_id (Key2) — int — 기본 키 — NOT NULL
- own_hotel_id (Key) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL
- picture_name (Field) — varchar(100)
- picture_url (Field2) — varchar(200)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
숙소 (hotels)
- hotel_id (Key) — int — 기본 키 — NOT NULL
- location (Field) — varchar(20)
- name (Field2) — varchar(20)
- tel (Field3) — varchar(20)
- owner (Field4) — varchar(20)
- business_number (Field5) — varchar(20)
- regist_number (Field6) — varchar(20)
- region (Field7) — varchar(20)
- facility_id (Key2) — int — 외래 키 → 편의시설.facility_id — NOT NULL
- hotel_picture_id (Key3) — int — 외래 키 → 호텔숙소사진.hotel_picture_id — NOT NULL
- hotel_type (Field8) — varchar(20)
예약 (reservations)
- reservation_id (Key) — int — 기본 키 — NOT NULL
- start_date (Field) — timestamp
- end_date (Field2) — timestamp
- duration (Field5) — int
- created_at (Field6) — timestamp
- updated_at (Field7) — timestamp
- hotel_id (Key2) — int — 외래 키 → 숙소.hotel_id — NOT NULL
- user_id (Key3) — int — 외래 키 → 회원.user_id — NOT NULL
- person_count (Field8) — int
- own_hotel_id (Key4) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL
- reserved_name (Field3) — varchar(20)
- reserved_phone (Field4) — varchar(11)
편의시설 (facilities)
- facility_id (Key) — int — 기본 키 — NOT NULL
- service_name (Field) — varchar(50)
- service_detail (Field2) — varchar(100)
프로필사진 (profile_photo)
- profile_photo_id (Key) — int — 기본 키 — NOT NULL
- photo_name (Field) — varchar(20)
- photo_url (Field2) — varchar(20)
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
호텔숙소사진 (hotel_pictures)
- hotel_picture_id (Key) — int — 기본 키 — NOT NULL
- picture_name (Field)
- picture_url (Field2)
- created_at (Field3)
- updated_at (Field4)
회원 (users)
- user_id (Key) — int — 기본 키 — NOT NULL
- oauth_id (Field) — bigint
- email (Field2) — varchar(20)
- password (Field7) — varchar(30)
- fullname (Field3) — varchar(20)
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp
- phone (Field6) — varchar(20)
- profile_photo_id (Key2) — int — 외래 키 → 프로필사진.profile_photo_id — NOT NULL