This is the multi-page printable view of this section. Click here to print.
The online_sales schema is a snowflake schema that contains information about the retail chains. The following graphic illustrates the online_sales schema and its relationship with tables in the public schema.
The subsequent subsections describe database tables.
This table describes all the items purchased through the online store front.
| Column Name | Data Type | NULLs |
sale_date_key |
INTEGER | No |
ship_date_key |
INTEGER | No |
product_key |
INTEGER | No |
product_version |
INTEGER | No |
customer_key |
INTEGER | No |
call_center_key |
INTEGER | No |
online_page_key |
INTEGER | No |
shipping_key |
INTEGER | No |
warehouse_key |
INTEGER | No |
promotion_key |
INTEGER | No |
pos_transaction_number |
INTEGER | No |
sales_quantity |
INTEGER | Yes |
sales_dollar_amount |
FLOAT | Yes |
ship_dollar_amount |
FLOAT | Yes |
net_dollar_amount |
FLOAT | Yes |
cost_dollar_amount |
FLOAT | Yes |
gross_profit_dollar_amount |
FLOAT | Yes |
transaction_type |
VARCHAR(16) | Yes |
This table describes all the chain’s call centers.
| Column Name | Data Type | NULLs |
call_center_key |
INTEGER | No |
cc_closed_date |
DATE | Yes |
cc_open_date |
DATE | Yes |
cc_date |
VARCHAR(50) | Yes |
| cc_class | VARCHAR(50) | Yes |
cc_employees |
INTEGER | Yes |
cc_hours |
CHAR(20) | Yes |
cc_manager |
VARCHAR(40) | Yes |
cc_address |
VARCHAR(256) | Yes |
cc_city |
VARCHAR(64) | Yes |
cc_state |
CHAR(2) | Yes |
cc_region |
VARCHAR(64) | Yes |
This table describes all the pages in the online store front.
| Column Name | Data Type | NULLs |
online_page_key |
INTEGER | No |
start_date |
DATE | Yes |
end_date |
DATE | Yes |
page_number |
INTEGER | Yes |
page_description |
VARCHAR(100) | Yes |
page_type |
VARCHAR(100) | Yes |