1. Database Sample Schemas
  2. Sample Schema Scripts and Object Descriptions
  3. CO Sample Schema Table Descriptions

4.13 CO Sample Schema Table Descriptions

Consider the columns of each table of CO sample schema.

4.13.1 Table CO.CUSTOMERS

The table below lists CO.CUSTOMERS table description.

Table 4-38 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)

4.13.2 Table CO.STORES

The table below lists CO.STORES table description.

Table 4-39 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
LONGITUDE YES NUMBER
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.

4.13.3 Table CO.PRODUCTS

The table below lists CO.PRODUCTS table description.

Table 4-40 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

4.13.4 Table CO.ORDERS

The table below lists CO.ORDERS table description.

Table 4-41 Table CO.ORDERS Table Description

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

4.13.5 Table CO.ORDER_ITEMS

The table below lists CO.ORDER_ITEMS table description.

Table 4-42 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