ATG Commerce Schema

The ATG Commerce database schema includes the following types of tables:

1.     Product Catalog Tables
2.     Commerce Users Tables
3.     Claimable Tables
4.     Shopping Cart Events Table
5.     Inventory Tables
6.     Order Tables
7.     Promotion Tables
8.     User Promotion Tables
9.     Gift List Tables
10.     Price List Tables
11.     Custom Catalog Tables
12.     Abandoned Order Services Tables
13.     Order Markers Table

    Product Catalog Tables:  ATG Commerce uses the following tables to store product catalog information:

1.         dcs_folder
2.         dcs_media
3.         dcs_media_ext
4.         dcs_media_bin
5.         dcs_media_txt
6.         dcs_category
7.         dcs_product
8.         dcs_product_acl
9.         dcs_sku
10.         dcs_cat_groups
11.         dcs_cat_chldprd
12.         dcs_cat_chldcat
13.         dcs_cat_ancestors
14.         dcs_cat_rltdcat
15.         dcs_cat_keywrds
16.         dcs_cat_media
17.         dcs_cat_aux_media
18.         dcs_prd_keywrds
19.         dcs_prd_media
20.         dcs_prd_aux_media
21.         dcs_prd_chldsku
22.         dcs_prd_skuattr
23.         dcs_prd_groups
24.         dcs_prd_rltdprd
25.         dcs_prd_ancestors
26.         dcs_sku_attr
27.         dcs_sku_link
28.         dcs_sku_bndllnk
29.         dcs_sku_media
30.         dcs_sku_aux_media
31.         dcs_sku_replace
32.         dcs_sku_conf
33.         dcs_config_prop
34.         dcs_conf_options
35.         dcs_config_opt
36.      dcs_foreign_cat

Commerce Users Tables:  ATG Commerce uses the following tables to store information about commerce users:

1.     dps_credit_card
2.     dcs_user
3.     dps_usr_creditcard

Claimable Tables:  ATG Commerce uses the following table to store claimable information:

1.     dcspp_claimable
2.     dcspp_giftcert
3.     dcs_storecred_clm
4.     dcspp_coupon

Shopping Cart Events Table:   ATG Commerce uses the following table to store information about shopping cart events:

1. dcs_cart_event

Inventory Tables:  ATG Commerce uses the following tables to store inventory information:

1. dcs_inventory

Order Tables:   ATG Commerce uses the following tables to store order information:

1.     dcspp_order
2.     dcspp_ship_group
3.     dcspp_pay_group
4.     dcspp_item
5.     dcspp_relationship
6.     dcspp_rel_orders
7.     dcspp_order_inst
8.     dcspp_order_sg
9.     dcspp_order_pg
10.     dcspp_order_item
11.     dcspp_order_rel
12.     dbcpp_sched_order
13.     dcspp_ship_inst
14.     dcspp_hrd_ship_grp
15.     dcspp_ele_ship_grp
16.     dcspp_ship_addr
17.     dcspp_hand_inst
18.     dcspp_gift_inst
19.     dcspp_sg_hand_inst
20.     dcspp_pay_inst
21.     dcspp_config_item
22.     dcspp_subsku_item
23.     dcspp_item_ci
24.     dcspp_gift_cert
25.     dcspp_store_cred
26.     dcspp_credit_card
27.     dcspp_bill_addr
28.     dcspp_pay_status
29.     dcspp_cc_status
30.     dcspp_gc_status
31.     dcspp_auth_status
32.     dcspp_debit_status
33.     dcspp_cred_status
34.     dcspp_shipitem_rel
35.     dcspp_rel_range
36.     dcspp_det_range
37.     dcspp_payitem_rel
38.     dcspp_payship_rel
39.     dcspp_payorder_rel
40.     dcspp_amount_info
41.     dcspp_order_price
42.     dcspp_item_price
43.     dcspp_tax_price
44.     dcspp_ship_price
45.     dcspp_amtinfo_adj
46.     dcspp_price_adjust
47.     dcspp_itmprice_det
48.     dcspp_det_price
49.     dcs_submt_ord_evt
50.     dcs_ord_merge_evt
51.     dcspp_order_adj
52.     dcspp_manual_adj

Promotion Tables:  ATG Commerce uses the following tables to store information about promotions:

1.     dcs_promotion
2.     dcs_promo_media
3.     dcs_discount_promo
4.     dcs_promo_upsell
5.     dcs_upsell_action
6.     dcs_close_qualif
7.     dcs_prm_cls_qlf
8.     dcs_upsell_prods
9.     dcs_prom_used_evt
10.     dcs_promo_rvkd
11.     dcs_promo_grntd

User Promotion Tables:  ATG Commerce uses the following tables to store information about user promotions:

1.     dcs_usr_promostat
2.     dcs_usr_actvpromo
3.     dcs_usr_usedpromo

Gift List Tables:  ATG Commerce uses the following tables to store information about gift lists and wish lists:

1.     dcs_giftlist
2.     dcs_giftinst
3.     dcs_giftitem
4.     dcs_giftlist_item
5.     dcs_user_wishlist
6.     dcs_user_giftlist
7.     dcs_user_otherlist

Price List Tables:  The following database tables store information related to price lists.

1.     dcs_price_list
2.     dcs_complex_price
3.     dcs_price
4.     dcs_price_levels
5.     dcs_price_level
6.     dcs_gen_fol_pl
7.     dcs_child_fol_pl
8.     dcs_plfol_chld

Custom Catalog Tables:  The following database tables store information related to the custom catalogs.

1.     dcs_catalog
2.     dcs_root_cats
3.     dcs_allroot_cats
4.     dcs_root_subcats
5.     dcs_sub_catalogs
6.     dcs_category_info
7.     dcs_product_info
8.     dcs_sku_info
9.     dcs_cat_subcats
10.     dcs_cat_subroots
11.     dcs_cat_catinfo
12.     dcs_catinfo_anc
13.     dcs_prd_prdinfo
14.     dcs_prdinfo_rdprd
15.     dcs_prdinfo_anc
16.     dcs_sku_skuinfo
17.     dcs_skuinfo_rplc
18.     dcs_gen_fol_cat
19.     dcs_child_fol_cat
20.     dcs_catfol_chld
21.     dcs_dir_anc_ctlgs
22.     dcs_ind_anc_ctlgs
23.     dcs_ctlg_anc_cats
24.     dcs_cat_prnt_ctlg
25.     dcs_cat_anc_cats
26.     dcs_prd_prnt_cats
27.     dcs_prd_anc_cats
28.     dcs_cat_catalogs
29.     dcs_prd_catalogs
30.     dcs_sku_catalogs
31.     dcs_user_catalog

Abandoned Order Services Tables:  ATG Commerce uses the following tables to store information about users’ abandoned orders:

1.     dcspp_ord_abandon
2.     dcs_user_abandoned
3.     drpt_conv_order
4.     drpt_session_ord

Order Markers Table:  The following section describes the table used to hold order marker information.

1. dcs_order_marker