property_calendars
DEPRECATED — being phased out, only still synced for a shrinking set of legacy clients. Superseded by two views that split its responsibilities: availability/booking spans live in unit_calendars, and pricing lives in interval_pricing_calendars. Do not build new integrations against this view. (Historically: availability and pricing calendar for units, source of truth for standalone units and units in a unit type.)
| Column | Description |
|---|---|
id |
Unique and primary key for this table |
property_id |
The ID of the unit associated |
status |
available/unavailable/booked |
price |
The price for this date |
currency |
The underlying currency for this calendar day |
date |
The date in YYYY-MM-DD |
note |
Optional note when setting status as unavailable |
created_at |
The UTC date, including time, when this was created |
updated_at |
The UTC date, including time, when this row was updated |
min_stay |
Minimum number of nights to allow a reservation to check-in on this date |
booking_ids |
IDs of the related bookings |
default_availability |
DEPRECATED |
closed_to_departure |
DEPRECATED |
closed_to_arrival |
DEPRECATED |
timestamp |
Date when the table was last synchronized |