Entity dim_store
Stereotype: dimension
Subject areas: Sales Star
Attributes
| # | Name | Type | Null | Default | Key | Terms | Description |
|---|
| 1 | store_key | integer | no | | PK | | |
| 2 | store_code | text(20) | no | | UQ | | |
| 3 | name | text(200) | no | | | | |
| 4 | region | text(100) | yes | | | | |
Keys
| Kind | Name | Attributes |
|---|
| primary | pk_dim_store | store_key |
| unique | uq_dim_store_code | store_code |
Relationships
| Name | Role | Other entity | Cardinality | Attributes | Identifying | On delete | On update |
|---|
| fact_sales_store | parent | fact_sales | one to many | fact_sales.store_key -> dim_store.store_key | no | no_action | no_action |
Physical
bq (bigquery): public.dim_store
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | int64 | no | | | | store_key | |
| 2 | store_code | string(20) | no | | | | store_code | |
| 3 | name | string(200) | no | | | | name | |
| 4 | region | string(100) | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)
dbx (databricks): default.dim_store
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | int | no | | always | | store_key | |
| 2 | store_code | string | no | | | | store_code | |
| 3 | name | string | no | | | | name | |
| 4 | region | string | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)
mysql (mysql): warehouse.dim_store
Options: engine=InnoDB
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | int | no | | by_default | | store_key | |
| 2 | store_code | varchar(20) | no | | | | store_code | |
| 3 | name | varchar(200) | no | | | | name | |
| 4 | region | varchar(100) | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)
pg (postgresql): dw.dim_store
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | integer | no | | always | | store_key | |
| 2 | store_code | varchar(20) | no | | | | store_code | |
| 3 | name | varchar(200) | no | | | | name | |
| 4 | region | varchar(100) | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)
rs (redshift): public.dim_store
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | integer | no | | always | | store_key | |
| 2 | store_code | varchar(20) | no | | | | store_code | |
| 3 | name | varchar(200) | no | | | | name | |
| 4 | region | varchar(100) | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)
snow (snowflake): public.dim_store
| # | Name | Type | Null | Default | Identity | Collation | Attribute | Comment |
|---|
| 1 | store_key | number(10, 0) | no | | always | | store_key | |
| 2 | store_code | varchar(20) | no | | | | store_code | |
| 3 | name | varchar(200) | no | | | | name | |
| 4 | region | varchar(100) | yes | | | | region | |
- primary key pk_dim_store (store_key)
- unique uq_dim_store_code (store_code)