Skip to content

unit_calendars

Calendar status records for individual units, tracking booking spans and availability.

Column Description
id Unique identifier for the unit calendar record
unit_id Identifier of the unit this calendar record belongs to
span The full date span for this calendar entry
span_lower Lower bound of the calendar span
span_upper Upper bound of the calendar span
span_lower_inclusive Whether the lower bound of the span is inclusive
span_upper_inclusive Whether the upper bound of the span is inclusive
created_at Timestamp indicating when the record was created
updated_at Timestamp indicating when the record was last updated
type Type of calendar entry (e.g. booking, block)
booking_id Identifier of the associated booking, if applicable
notes Optional notes for this calendar entry
timestamp Date when the table was last synchronized