# properties

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

Unit master data with descriptions, pricing configuration, and workspace association.

| Column | Description |
| --- | --- |
| `id` | A unique primary key for units |
| `p_type` | DEPRECATED |
| `code` | Code for this unit within a building |
| `description` | The description for this unit |
| `status` | Enum showing the status for this unit |
| `google_place_id` | The google place_id for this unit |
| `created_at` | The UTC date, including time, when this unit was created |
| `updated_at` | The UTC date, including time, when this unit was updated |
| `owner_visible` | Is the owner visible when viewing this unit |
| `number_of_bedrooms` | Number of bedrooms for unit |
| `number_of_beds` | Number of beds for units (not the same as bedrooms) |
| `max_occupants` | Max number of guests for a booking |
| `hkus` | Housekeeping units |
| `onboarding_ticket_id` | The ID of the onboarding ticket for this unit |
| `beneficiary_id` | The unique identifier of the beneficiary associated with this unit |
| `monthly_arrears_payment` | True if monthly payments can be made in arrears |
| `workspace_id` | The ID of this workspace |
| `origin` | The origin of where this unit was created |
| `total_nights_hosted` | Total nights hosted for this unit |
| `total_nights_booked` | Total number of nights booked for this unit |
| `property_type_id` | The property type ID for this unit |
| `marketing_title` | The marketing title for this unit, often used with OTA |
| `marketing_description` | The marketing description for this unit, often used with OTA |
| `location_description` | Information about the unit's location and surrounding area |
| `number_of_bathrooms` | Number of bathrooms for this unit |
| `size_in_sqm` | Total size in SQM for this unit |
| `dedicated_rental` | Is this a dedicated rental unit |
| `approximate_annual_available_nights` | Number of nights in a given year that can be booked for this unit |
| `manual_pricing_enabled` | If true the price for this unit can be manually changed |
| `vat` | The % of VAT to apply to all bookings for this unit |
| `imported_at` | The date in UTC, including time, for when this unit was imported |
| `v2_payout_template_id` | The ID for the payout template |
| `uuid` | A unique ID |
| `has_overlapping_bookings` | Does this unit have overlapping bookings |
| `multi_unit_group_id` | The ID of the unit type; each unit can either have an ID or not |
| `imported_from` | The platform where this unit was imported from |
| `license` | A text field storing the regulatory license number or permit details |
| `access_description` | Additional notes for guests that explain what they have access to in the building when booking this unit |
| `space_description` | A description about the spaces for tenants |
| `transit_description` | Information about what is in the area, including how to get to the unit |
| `additional_information` | More information about this unit |
| `interaction_with_guests` | A message for guests on how they can interact with the owners |
| `connected_with_keycafe` | Is this unit integrated with Keycafe |
| `cadastral` | The unique identifier assigned to this unit by the local planning authority or land registry |
| `parent_unit_id` | The parent unit ID for this unit |
| `tariff_ids` | A JSON object containing any tariffs that are valid for this unit and bookings |
| `vat_code_id` | The ID of the VAT code |
| `company_vat_code_id` | The ID of the company VAT code |
| `timestamp` | Date when the table was last synchronized |