Objects created for the reference environment

The reference implementation toolset creates these objects in the reference replication environment:

**Table D-3: Stored procedures created for reference implementation**
Stored procedure	Location
sp_load_warehouse_data	Primary and replicate databases
sp_load_district_data	Primary and replicate databases
sp_load_customer_data	Primary and replicate databases
sp_load_history_data	Primary and replicate databases
sp_load_item_data	Primary and replicate databases
sp_load_stock_data	Primary and replicate databases
sp_load_order_orderline_data	Primary and replicate databases
sp_load_neworder_data	Primary and replicate databases
sp_load_data_multi_tran	Primary and replicate databases
sp_gen_neworder_data	Primary database
sp_gen_payment_data	Primary database
sp_gen_delivery_data	Primary database
sp_gen_neworder_data_large_tran	Primary database
sp_gen_payment_data_large_tran	Primary database
sp_gen_delivery_data_large_tran	Primary database
sp_generator_data_1	Primary database
sp_generator_data_2	Primary database
sp_generator_data_3	Primary database
sp_generator_data_4	Primary database

**Table D-4: Replication definition and subscription created for reference implementation**
Stored procedure	Subscribing for
Replication definition: pdbrepdefforrdb
Subscription: rdbsubforpdb	pdbrepdefforrdb

**Table D-5: Tables created for reference implementation**
Table	Location
WAREHOUSE	Primary and replicate databases
DISTRICT	Primary and replicate databases
CUSTOMER	Primary and replicate databases
HISTORY	Primary and replicate databases
NEW_ORDER	Primary and replicate databases
ORDER	Primary and replicate databases
ORDER_LINE	Primary and replicate databases
ITEM	Primary and replicate databases
Stock	Primary and replicate databases

The table schema for the tables:

Keys:

Field name	Field definition	Comments
D_ID	20 unique IDs	10 are populated per warehouse
D_W_ID	2*W unique IDs
D_NAME	Variable text, size 10
D_STREET1	Variable text, size 20
D_STREET2	Variable text, size 20
D_CITY	Variable text, size 20
D_STATE	Fixed text, size 2
D_ZIP	Fixed text, size 9
D_TAX	Numeric, 4 digits	Sales tax
D_YTD	Numeric, 12 digits	Year to date balance
D_NEXT_O_ID	10, 000 unique IDs	Unique IDs for next available order number

Keys:

Field name	Field definition	Comments
C_ID	96, 000 unique IDs	3, 000 are populated per warehouse
C_D_ID	20 unique IDs
C_W_ID	2*W unique IDs
C_FIRST	Variable text, size 16
C_MIDDLE	Fixed text, size 2
C_LAST	Variable text, size 16
C_STREET1	Variable text, size 20
C_STREET2	Variable text, size 20
C_CITY	Variable text, size 20
C_STATE	Fixed text, size 2
C_ZIP	Fixed text, size 9
C_PHONE	Fixed text, size 16
C_SINCE	Date and time	The date of registration
C_CREDIT	Fixed text, size 2	Credit: "GC"=good credit, "BC"=bad credit
C_CREDIT_LIM	Numeric, 12 digits
C_DISCOUNT	Numeric, 4 digits
C_BALANCE	Signed numeric, 12 digits
C_YTD_PAYMENT	Numeric, 12 digits
C_PAYMENT_CNT	Numeric, 4 digits
C_DELIVERY_CNT	Numeric, 4 digits
C_DATA	Variable text, size 500	For remarks

Keys:

Keys:

Keys:

Keys:

Keys:

Keys: