# Warehouse Data

## Purpose

This folder contains warehouse data model documentation for ETL-owned serving schemas.

It is meant to be the human-readable reference for what the tenant warehouse exposes after ETL publication, starting with the `curated` schema.

## Contents

- `brinkPos-staging-model/` - Brink POS source-shaped staging tables, one document per raw API operation
- `curated-model/` - one document per `curated` table, with table purpose and column-level descriptions
- `logic-control-aloha-staging-model/` - source-shaped Aloha staging tables from the current SQL bootstrap
- `logic-control-kds-staging-model/` - source-shaped KDS staging tables from the current SQL bootstrap
- `logic-control-pos-staging-model/` - source-shaped Labpos and POS staging tables from the current SQL bootstrap

## Current Brink XML -> Parquet -> Redshift validation scope

Validated in the current iteration:

- `Sales2.GetOrders`
- `Kitchen.GetOrderItemBumpTimes`
- `Settings2.GetLastModifiedTime`
- `Settings2.GetItems`
- `Settings2.GetModifierGroups` - currently documented under `brinkPos-staging-model/brink_settings_get_modifier_groups.md` because the existing doc naming still reflects the older `Settings.svc` wording

Explicitly deferred to the next iteration:

- `Settings2.GetDestinations`
- `Settings2.GetTables`
- `Settings2.GetKitchenQueues`
- `Settings2.GetTaxes`
- `Settings2.GetEmployees`
- `Settings.GetTenders`