---
schema_version: "1"
id: ae216907bdee75a9d90d87f35493ced0b7ffde13c8f2ec154f1e728e861c71fd
title: Schema Conventions
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_schema_conventions.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_schema_conventions.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ab963c31eb9a42cf3c3753760b979e8cdf71e798c99801177f4bb4c617fd1ef4
products:
  - Composable Storefront
  - Salesforce APIs
---
# 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