SH Sample Schema Scripts and Objects

The following tables list the names of the scripts that create the Sales History (sh) schema and describe the objects in the schema.

SH Sample Schema Scripts

Script Name	Description
sh_create.sql	Creates the objects in the schema
sh_install.sql	Main script for schema sh; calls other scripts
sh_populate.sql	Populates the objects
sh_uninstall.sql	Uninstalls the schema

SH Sample Schema Objects

Object Type	Objects
Dimension	channels_dim, customers_dim, products_dim, promotions_dim, times_dim
Index	channels_pk, countries_pk, customers_gender_bix, customers_marital_bix, customers_pk, customers_yob_bix, dr$sup_text_idx$x, fw_psc_s_mv_chan_bix, fw_psc_s_mv_promo_bix, fw_psc_s_mv_subcat_bix, fw_psc_s_mv_wd_bix, products_pk, products_prod_cat_ix, products_prod_status_bix, products_prod_subcat_ix, promo_pk, sup_text_idx, times_pk
Partitioned Index	costs_prod_bix, costs_time_bix, sales_channel_bix, sales_cust_bix, sales_prod_bix, sales_promo_bix, sales_time_bix
Materialized View	cal_month_sales_mv, fweek_pscat_sales_mv
Table	channels, countries, customers, products, promotions, times
Partitioned Table	costs, sales
View	profits