test
Tables (8)
cancellation_policies
- cancellation_policy_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
facilities
- facilities_id — BIGINT — Primary key — NOT NULL
- facilities_name — VARCHAR(100) — NOT NULL
- category — ENUM('BATHROOM','BEDROOM','LAUNDRY_ROOM','ENTERTAINMENT','HVAC','SAFETY','INTERNET','KITCHEN','PARKING_SERVICE','OTHER') — NOT NULL
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- stay_uuid — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- checkin_date — DATE — NOT NULL
- checkout_date — DATE — NOT NULL
- reservation_date — DATETIME — NOT NULL
- status — ENUM('PENDING','CONFIRMED','CANCELLED') — NOT NULL
- guests_count — INT — NOT NULL
- requests — TEXT
- reservation_info — VARCHAR(255)
stay_facilities
- stay_uuid — BIGINT — Primary key — NOT NULL
- facilities_id — BIGINT — Primary key — NOT NULL
stay_photos
- photo_id — BIGINT — Primary key — NOT NULL
- stay_uuid — BIGINT — NOT NULL
- url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
stay_pricing
- price_id — BIGINT — Primary key — NOT NULL
- stay_uuid — BIGINT — NOT NULL
- weekday_price — INT — NOT NULL
- weekend_price — INT — NOT NULL
- currency — CHAR(3) — NOT NULL
- effective_from — DATE
- effective_to — DATE
stays
- stay_uuid — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- bedrooms — INT — NOT NULL
- beds — INT — NOT NULL
- bathrooms — INT — NOT NULL
- address_line1 — VARCHAR(255) — NOT NULL
- address_line2 — VARCHAR(255)
- city — VARCHAR(100) — NOT NULL
- region — VARCHAR(100) — NOT NULL
- postal_code — VARCHAR(100) — NOT NULL
- max_guests — INT — NOT NULL
- cancellation_policy_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
users
- user_id — BIGINT — Primary key — NOT NULL
- user_role — ENUM('ROLE_GUEST','ROLE_HOST') — NOT NULL
- name — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME