Client Data Dictionary

Views exported daily to each client’s Redshift database via the create_update_client_data_views_{client} Airflow DAGs. All views are filtered to the client’s own workspace IDs. Demo/test workspaces are excluded by default; a small set of clients are explicitly configured to receive demo/test workspaces too. The timestamp column on every view records the last DLT sync time for that table. This data dictionary is always kept in sync with the exported views. LVDAM-derived views are refreshed once per day: the load runs at 03:00 UTC (03:00 GMT in winter and 04:00 BST in summer) via the dlt_lvdam_to_clients_redshift Airflow DAG. The report_ar_documents and report_ar_balances views are refreshed separately via the dlt_abacus_to_clients_redshift Airflow DAG.

See also: Redshift Clients Datalake ERD — how these tables relate to each other.

Table	Description
addresses	Address records for units and buildings in client workspaces. Results are a UNION of unit addresses and building addresses.
agreements_agreement_unit_type_allocation_versions	Audit trail versions for agreement unit type allocations.
agreements_agreement_unit_type_allocations	Unit type allocations for agreements.
agreements_agreement_versions	Audit trail versions for agreements.
agreements_agreements	Agreement records for client workspaces.
availability_unit_availability_pool_allocations	Unit allocations within an availability pool, scoped to client workspaces via the unit’s workspace_id.
billing_periods	Billing periods associated with bookings, tracking cost/fee breakdowns per period.
booking_context_participants	Contacts taking part in a booking context (group of bookings), with their roles.
booking_contract_values	Versioned contract values for bookings (accommodation, additional services, cancellation fee and VAT totals), scoped to client workspaces. One row per version; the current value has effective_to NULL.
booking_daily_rates	Daily rate detail records for bookings.
booking_guarantor_informations	Guarantors attached directly to a booking.
booking_guests	Contacts attached to a booking and their role (guest, lead guest, guarantor, booking agent).
booking_rates	Detailed rate entries for bookings, stored as JSON.
bookings	Booking records for the client’s workspace. Demo/test excluded unless configured otherwise.
bookings_instalment_plan_templates	Instalment plan templates per workspace, offered on bookings for their product groups.
buildings	Building master records with marketing data and workspace association.
catalog_product_groups	Sales Proposition product group (contract) definitions, scoped to client workspaces.
catalog_product_rates	Rate definitions (billing interval) for Sales Proposition products, scoped to client workspaces via their product.
catalog_products	Sales Proposition product definitions, scoped to client workspaces via their product group.
catalog_rate_calendars	Calendar entries (span + price) for Sales Proposition product rates, scoped to client workspaces via their product.
crm_companies	CRM company records (e.g. agencies, universities) in the client’s CRM namespaces.
crm_companies_contact_informations	Links between CRM companies and their contacts; one row per company-contact pair.
crm_contact_informations	CRM contact details including names, emails, phones, and marketing consent records. Includes the emergency and trusted contacts of served contacts, so crm_contact_relationships.target_contact_information_id joins here.
crm_contact_relationships	Emergency and trusted contacts: one row per relationship from a contact (usually a guest) to the contact they have nominated, for every contact in the client’s CRM namespaces. Join source_contact_information_id and target_contact_information_id to crm_contact_informations.id; an id does not resolve when that contact is not served there (crm_contact_informations serves contacts on the client’s leads and bookings and their related contacts).
crm_namespaces	CRM namespace definitions. Filtered to namespaces associated with the client’s workspaces.
daily_revenues	Per-day revenue breakdown for bookings, scoped to client workspaces by the unit’s current workspace. Superseded (obsolete) rows and rows with a non-finite accommodation_fare_gbp are excluded. Amounts are double precision.
finance_billing_cycles	Billing cycles for bookings, scoped to client workspaces.
guest_payments	Payment records with status, payment method, and booking linkage.
inquiries	Prospect lead records populated from direct booking websites, the PMS, or API integrations.
inquiry_participants	People involved in leads, with consent and contact details.
interval_pricing_calendars	Interval-based pricing calendars linking bookable entities to tariff pricing by date.
invoice_list_items	Invoice master records with line items, allocations, and recipient details.
invoicing_invoices	Invoice records with payload, account, and status information.
lead_statuses	Lead status tracking records linking leads to CRM namespaces.
multi_unit_group_calendars	Availability and pricing calendar for unit types. Source of truth for availability for unit types.
multi_unit_groups	Unit type definitions (e.g. studio, 2-bed) with marketing data and pricing configuration.
offer_management_offer_accommodations	Accommodation pricing details within offers.
offer_management_offers	Offer creation, status, and pricing records.
properties	Unit master data with descriptions, pricing configuration, and workspace association.
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.)
report_ar_balances	Accounts receivable balances for client workspaces. One row per (workspace_id, party_external_id, currency). Balances are never summed across currencies.
report_ar_documents	Issued accounts receivable documents for client workspaces.
tags_entity_tags	Tags attached to entities; one row per tag on an entity. Join tag_id to tags_tags.id, whose scope and entity say what ref points at.
tags_tags	Tag definitions, such as the tags used on instalment plan templates and product groups. A tag is unique by key within its scope and entity. Discarded (deleted) tags are kept with discarded_at set.
tariffs	Pricing tariff information (monthly/nightly rates) from MongoDB, joined via unit tariff_ids.
task_categories	Task category definitions used to classify tasks.
tasks	Operational task records associated with units and bookings.
tickets	Support and onboarding ticket records associated with units and workspaces.
unit_calendars	Calendar status records for individual units, tracking booking spans and availability.
workspaces	Workspace (client account) master data. Filtered to the client’s own workspace IDs.
workspaces_inquiries	Junction table linking workspaces to leads.