ccdw_dim_site
This table stores information about different e-commerce sites or storefronts.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
site_id (PK) | SMALLINT | PK | Unique identifier for a site. | Yes |
nsite_id | VARCHAR | The natural key of the site as represented in the source system. | Yes | |
site_display_name | VARCHAR | User-friendly display name for the site. | No | |
site_sitezone | VARCHAR | Normalized timezone for the site. | No | |
site_currency | VARCHAR | Alpha-3 currency code used by the site. | No | |
site_taxation | VARCHAR | Taxation rules or status for the site (for example, gross/net). | No | |
site_status | VARCHAR | Current operational status of the site. | No | |
realm_id | SMALLINT | Unique identifier for the realm the site belongs to. | No | |
nrealm_id | VARCHAR | The natural key of the realm as represented in the source system. | Yes | |
realm_timezone | VARCHAR | Timezone of the realm. | No | |
realm_currency | VARCHAR | Alpha-3 currency code used by the realm. | No |