gwanak_bnb
Tables (11)
categories
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(127) — NOT NULL
- icon_url — VARCHAR(255)
hosts
- id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- thumbnail_url — TEXT
- started_at — DATETIME
- host_type — ENUM('SUPERHOST', 'NORMAL')
regions
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(127) — NOT NULL
- lat_min — DECIMAL(10, 7) — NOT NULL
- lat_max — DECIMAL(10, 7) — NOT NULL
- lng_min — DECIMAL(10, 7) — NOT NULL
- lng_max — DECIMAL(10, 7) — NOT NULL
reservations
- id — VARCHAR(36) — Primary key — NOT NULL
- room_id — VARCHAR(36) — Foreign key → rooms.id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.id — NOT NULL
- check_in — DATE — NOT NULL
- check_out — DATE — NOT NULL
- guest_count — INT — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- price_snapshot — JSON
- status — ENUM('PENDING', 'CONFIRMED', 'CANCELLED')
- created_at — DATETIME — NOT NULL
review_images
- id — VARCHAR(36) — Primary key — NOT NULL
- review_id — VARCHAR(36) — Foreign key → reviews.id — NOT NULL
- url — TEXT — NOT NULL
- caption — VARCHAR(255)
- order_num — INT
reviews
- id — VARCHAR(36) — Primary key — NOT NULL
- score — INT — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- reservation_id — VARCHAR(36) — Foreign key → reservations.id — NOT NULL
room_discounts
- id — VARCHAR(36) — Primary key — NOT NULL
- room_id — VARCHAR(36) — Foreign key → rooms.id — NOT NULL
- min_nights — INT — NOT NULL
- discount_rate — DECIMAL(5, 2) — NOT NULL
room_images
- id — VARCHAR(36) — Primary key — NOT NULL
- room_id — VARCHAR(36) — Foreign key → rooms.id — NOT NULL
- url — TEXT — NOT NULL
- caption — VARCHAR(255)
- order_num — INT
room_prices
- id — VARCHAR(36) — Primary key — NOT NULL
- room_id — VARCHAR(36) — Foreign key → rooms.id — NOT NULL
- date — DATE — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
rooms
- id — VARCHAR(36) — Primary key — NOT NULL
- host_id — VARCHAR(36) — Foreign key → hosts.id — NOT NULL
- category_id — VARCHAR(36) — Foreign key → categories.id
- region_id — VARCHAR(36) — Foreign key → regions.id
- name — VARCHAR(255) — NOT NULL
- short_description — VARCHAR(255)
- description — TEXT
- max_guests — INT — NOT NULL
- max_adults — INT
- max_children — INT
- max_infants — INT
- max_pets — INT
- price_per_night — DECIMAL(10, 2) — NOT NULL
- weekend_price_per_night — DECIMAL(10, 2)
- country — VARCHAR(127)
- city — VARCHAR(127)
- state — VARCHAR(127)
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- thumbnail_url — TEXT
- created_at — DATETIME — NOT NULL
users
- id — VARCHAR(36) — Primary key — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- user_type — ENUM('HOST', 'GUEST')
- created_at — DATETIME — NOT NULL