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 |