CO Sample Schema Table Descriptions

The following tables describe the columns of each table of the co sample schema.

If the value of a primary key column is NULL, an integer is generated by default for all of the co Sample Schema tables.

• Table CO.CUSTOMERS
• Table CO.STORES
• Table CO.PRODUCTS
• Table CO.ORDERS
• Table CO.ORDER_ITEMS
• Table CO.SHIPMENTS
• Table CO.INVENTORY

Table CO.CUSTOMERS

The table below lists CO.CUSTOMERS table description.

Table 4-12 CO.CUSTOMERS Table Description

Column Name	Nulls Allowed?	Type
CUSTOMER_ID	NO	INTEGER
EMAIL_ADDRESS	NO	VARCHAR2(255 CHAR)
FULL_NAME	NO	VARCHAR2(255 CHAR)

Table CO.STORES

The table below lists CO.STORES table description.

Table 4-13 Table CO.STORES Table Description

Column Name	Nulls Allowed?	Type
STORE_ID	NO	INTEGER
STORE_NAME	NO	VARCHAR2(255 CHAR)
WEB_ADDRESS	YES	VARCHAR2(100 CHAR)
PHYSICAL_ADDRESS	YES	VARCHAR2(512 CHAR)
LATITUDE	YES	NUMBER(9,6)
LONGITUDE	YES	NUMBER(9,6)
LOGO	YES	BLOB
LOGO_MIME_TYPE	YES	VARCHAR2(512 CHAR)
LOGO_FILENAME	YES	VARCHAR2(512 CHAR)
LOGO_CHARSET	YES	VARCHAR2(512 CHAR)
LOGO_LAST_UPDATED	YES	DATE

Note:

The table has a constraint to verify either WEB_ADDRESS or PHYSICAL ADDRESS is NOT NULL.

Table CO.PRODUCTS

The table below lists CO.PRODUCTS table description.

Table 4-14 Table CO.PRODUCTS Table Description

Column Name	Nulls Allowed?	Type
PRODUCT_ID	NO	INTEGER
PRODUCT_NAME	NO	VARCHAR2(255 CHAR)
UNIT_PRICE	YES	NUMBER(10,2)
PRODUCT_DETAILS	YES	BLOB
PRODUCT_IMAGE	YES	BLOB
IMAGE_MIME_TYPE	YES	VARCHAR2(512 CHAR)
IMAGE_FILENAME	YES	VARCHAR2(512 CHAR)
IMAGE_CHARSET	YES	VARCHAR2(512 CHAR)
IMAGE_LAST_UPDATED	YES	DATE

Table CO.ORDERS

The table below lists CO.ORDERS table description.

Table 4-15 Table CO.ORDERS Table Description

Column Name	Nulls Allowed?	Type
ORDER_ID	NO	INTEGER
ORDER_TMS	NO	TIMESTAMP(6)
CUSTOMER_ID	NO	INTEGER
ORDER_STATUS	NO	VARCHAR2(10 CHAR)
STORE_ID	NO	INTEGER

Table CO.ORDER_ITEMS

The table below lists CO.ORDER_ITEMS table description.

Table 4-16 Table CO.ORDER_ITEMS Table Description

Column Name	Nulls Allowed?	Type
ORDER_ID	NO	INTEGER
LINE_ITEM_ID	NO	INTEGER
PRODUCT_ID	NO	INTEGER
UNIT_PRICE	NO	NUMBER(10,2)
QUANTITY	NO	INTEGER
SHIPMENT_ID	YES	INTEGER

Table CO.SHIPMENTS

The table below lists CO.SHIPMENTS table description.

Table 4-17 Table CO.SHIPMENTS Table Description

Column Name	Nulls Allowed?	Type
SHIPMENT_ID	NO	INTEGER
STORE_ID	NO	INTEGER
CUSTOMER_ID	NO	INTEGER
DELIVERY_ADDRESS	NO	VARCHAR2(512 CHAR)
SHIPMENT_STATUS	NO	VARCHAR2(100 CHAR)

Table CO.INVENTORY

The table below lists CO.INVENTORY table description.

Table 4-18 Table CO.INVENTORY Table Description

Column Name	Nulls Allowed?	Type
INVENTORY_ID	NO	INTEGER
STORE_ID	NO	INTEGER
PRODUCT_ID	NO	INTEGER
PRODUCT_INVENTORY	NO	INTEGER