zz
Tables (13)
accommodation_images (CopyOf객실 사진)
- id (Key) — Primary key — NOT NULL
- image_url (이미지 url)
- displayed (노출 여부)
- accommodation_id (숙소 id) — Foreign key → accommodations.id — NOT NULL
accommodations (숙소)
- id (Key) — Primary key — NOT NULL
- business_user_id (등록 사용자 Id) — Foreign key → users.id — NOT NULL
- name (이름)
- address (주소)
- zip_code (Field)
- detail_address (상세 주소)
- latitude (위도)
- longitude (경도)
- phone (전화번호)
- displayed (노출 여부)
- type (숙소 타입)
amenities (편의시설)
- id (Key) — Primary key — NOT NULL
- name (Field)
- icon_url (Field2)
auth_providers (인증 제공자)
- id (Key) — Primary key — NOT NULL
- provider (인증 제공업체명)
- provider_user_id (소셜 내 사용자 id)
- user_id (사용자 id) — Foreign key → users.id — NOT NULL
roles (권한)
- id (Key) — Primary key — NOT NULL
- name (권한명('USER', 'BUSINESS', 'ADMIN'))
- description (설명)
room_amenities (객실 편의시설)
- id (Key) — Primary key — NOT NULL
- amenity_id (편의시설 id) — Foreign key → amenities.id — NOT NULL
- room_id (객실 id) — Foreign key → rooms.id — NOT NULL
room_images (객실 사진)
- id (Key) — Primary key — NOT NULL
- image_url (이미지 url)
- room_id (객실 id) — Foreign key → rooms.id — NOT NULL
- displayed (노출 여부)
room_reservations (객실 예약)
- id (Key) — Primary key — NOT NULL
- check_in_date (체크인일자)
- check_out_date (체크아웃일자)
- status (상태('PENDING', 'CONFIRMED', 'CANCELLED'))
- user_id (사용자 id) — Foreign key → users.id — NOT NULL
- room_id (객실 id) — Foreign key → rooms.id — NOT NULL
rooms (객실)
- id (Key) — Primary key — NOT NULL
- accommodation_id (숙소 Id) — Foreign key → accommodations.id — NOT NULL
- name (객실명)
- max_occupancy (방 개수)
- available (예약 가능 여부)
user_credentials (회원 자격증명)
- id (Key) — Primary key — NOT NULL
- password_hash (비밀번호)
- auth_provider_id (인증제공자 Id) — Foreign key → auth_providers.id — NOT NULL
user_roles (회원 권한)
- id (Key) — Primary key — NOT NULL
- user_id (사용자 id) — Foreign key → users.id — NOT NULL
- role_id (권한 id) — Foreign key → roles.id — NOT NULL
user_tokens (회원 토큰)
- id (Key) — Primary key — NOT NULL
- auth_provider_id (인증제공자 Id) — Foreign key → auth_providers.id — NOT NULL
- access_token (엑세스 토큰)
- refresh_token (리프레시 토큰)
- expires_at (만료일시)
- issued_at (발급일시)
users (사용자)
- id (Key) — Primary key — NOT NULL
- email (이메일)
- name (이름)
- role (권한)
- nickname (닉네임)