# 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