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 (닉네임)