properties

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