CO Sample Schema Scripts and Objects

The following tables list the names of the scripts that create the customer orders (co) schema and describe the objects in the schema.

CO Sample Schema Scripts

Script Name Description
co_create.sql Creates the co objects
co_install.sql Main script for schema co; calls other scripts
co_populate.sql Populates the objects
co_uninstall.sql Uninstalls the schema

CO Sample Schema Objects

Object Type Objects
Index customers_name_i, orders_customer_id_i, orders_store_id_i, products_pk, stores_pk, store_name_u, customers_pk, customers_email_u, orders_pk, order_items_pk, order_items_product_u, inventory_product_id_i, inventory_pk, inventory_store_product_u, shipments_store_id_i, shipments_customer_id_i, shipments_pk
Table customers, stores, products, orders, order_items, shipments, inventory
View customer_order_products, store_orders, product_reviews, product_orders