Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)

Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)

Warehouse Model (93)

Analytical data warehouse schemas, curated tables, and Redshift/Athena data models.

warehouse-model/docs/features/ETL/warehouse-data/curated-model/pos_tables.md 2,926 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

curated.pos_tables

Purpose

This table stores POS table lookup data used by dine-in operations. It provides the business identifiers and presentation fields needed to connect orders or layouts to specific restaurant tables.

It acts as lightweight reference data and is typically joined to more transactional datasets rather than queried on its own.

Schema contract

The deployed SQL under backend/Kds.Ai.Warehouse/Sql/Bootstrap/Tenant/Curated/ is the source of truth for the current column names, types, and nullability.

Column groups

Business properties describe the business entity, event, fact, or reference record represented by the table.
Technical and ETL properties describe warehouse lineage, surrogate keys, source reconciliation, tenant scoping, slowly changing dimension controls, and ingestion metadata.

Business properties

Column	Type	Nullable	Business Meaning
`id`	`INTEGER`	Yes	Table identifier in the POS source.
`usernumber`	`INTEGER`	Yes	User-visible table number in the source system.
`revcenter`	`INTEGER`	Yes	Revenue center associated with the table.
`numseats`	`INTEGER`	Yes	Number of seats available at the table.
`ownerid`	`INTEGER`	Yes	Owning configuration or location identifier.
`desc`	`VARCHAR(20)`	Yes	Short descriptive label for the table.
`style`	`INTEGER`	Yes	Style or layout code for the table.
`table_name`	`VARCHAR(255)`	Yes	Readable business name or label for the table.
`revenue_center_name`	`VARCHAR(255)`	Yes	Readable revenue center name associated with the table.
`zone_name`	`VARCHAR(255)`	Yes	Readable dining zone or seating area name for the table.
`style_name`	`VARCHAR(255)`	Yes	Readable business label for the table style.
`is_active`	`BOOLEAN`	Yes	Canonical flag indicating whether the table is active in the curated model.

Technical and ETL properties

Column	Type	Nullable	Technical Meaning	Notes
`table_key`	`BIGINT`	Yes	Stable warehouse key for the table entity.
`source_system`	`VARCHAR(100)`	Yes	Canonical name of the source platform that produced the table row.
`source_table_id`	`VARCHAR(199)`	Yes	Original table identifier from the source platform.
`tenant_key`	`BIGINT`	Yes	Stable warehouse key for the tenant, brand, or client that owns the table.
`tenant_name`	`VARCHAR(255)`	Yes	Readable tenant, brand, or client name associated with the table.
`_etl_batch_id`	`VARCHAR(256)`	Yes	ETL batch lineage identifier.
`_etl_source_type`	`VARCHAR(100)`	Yes	Source adapter type used by ETL.
`_etl_ingested_at`	`TIMESTAMP`	No	Warehouse ingestion timestamp for the curated row.	Required ingestion audit timestamp.