CO 範例綱要命令檔和物件
下表列出建立客戶訂單 (co) 綱要的指令碼名稱,並描述結構中的物件。
CO 範例結構指令碼
| 命令檔名稱 | 描述 |
|---|---|
co_create.sql |
建立 co 物件 |
co_install.sql |
綱要 co 的主要命令檔;呼叫其他命令檔 |
co_populate.sql |
填入物件 |
co_uninstall.sql |
解除安裝綱要 |
CO 範例綱要物件
| 物件類型 | 物件 |
|---|---|
| 索引 | 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 |
| 表格 | customers, stores, products, orders, order_items, shipments, inventory |
| 檢視 | customer_order_products, store_orders, product_reviews, product_orders |