# unit_calendars

<!-- Generated from apps/irrigation/dbt_redshift/models/client_data/sources.yml. Do not edit by hand — run `make generate-client-data-dictionary`. -->

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 |