Schema Conventions

The following conventions are used throughout the schema:

Table Prefixes: All tables in the warehouse schema are prefixed with ccdw to organize the tables into a model representing the Commerce Cloud Data Warehouse.
Table Types:
- Dimensions (dim_ prefix): These tables represent business context.
- Facts (fact_ prefix): These tables represent details about a measured business process.
- Aggregates (aggr_ prefix): These tables represent aggregate data about a business process and support quick access to commonly used business questions.
Currency Prefixes:
- lcl_: Monetary values in the tendered currency
- std_: Monetary values converted to a common reporting currency, as configured in Reports & Dashboards administration settings in Business Manager
Time Prefixes:
- utc_: Columns representing Universal Time Coordinated time