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