The OPTIM_CUSTOMERS table contains customer names, ID numbers,
and addresses.
The OPTIM_CUSTOMERS table has the following
columns:
- CUST_ID
- CHAR; up to 5 characters; cannot contain null; contains
a check constraint.
- CUSTNAME
- CHAR; up to 20 characters; cannot contain null.
- ADDRESS1
- VARCHAR; up to 100 characters; cannot contain null.
- ADDRESS2
- VARCHAR; up to 100 characters; cannot contain null.
- LOCALITY
- VARCHAR; up to 56 characters
- CITY
- VARCHAR; up to 60 characters
- STATE
- VARCHAR; up to 30 characters
- COUNTRY_CODE
- CHAR; up to 2 characters
- POSTAL_CODE
- VARCHAR; up to 15 characters
- POSTAL_CODE_PLUS4
- CHAR; up to 4 characters; can contain a null value.
- EMAIL_ADDRESS
- VARCHAR; up to 70 characters
- PHONE_NUMBER
- VARCHAR; up to 20 characters
- YTD_SALES
- DECIMAL; dollar amount; cannot contain null; has
a default value.
- SALESMAN_ID
- CHAR; up to 6 characters
- NATIONALITY
- VARCHAR; up to 30 characters
- NATIONAL_ID
- VARCHAR; up to 30 characters
- CREDITCARD_NUMBER
- VARCHAR; 19 characters
- CREDITCARD_TYPE
- VARCHAR; up to 30 characters
- CREDITCARD_EXP
- CHAR; 4 characters
- CREDITCARD_CVV
- VARCHAR; up to 4 characters
- DRIVER_LICENSE
- VARCHAR; up to 30 characters
- CUSTOMER_INFO
- XMLTYPE
Primary Keys
The
CUST_ID column is the primary key column.
Relationships to Other Tables
The OPTIM_CUSTOMERS table is a parent of:
- The OPTIM_ORDERS table, through a foreign key on
column CUST_ID.
- The OPTIM_SHIP_TO table, through an Optim™ relationship on column CUST_ID.
The OPTIM_CUSTOMERS table is a child of:
- The OPTIM_SALES table, through its foreign key on
column SALESMAN_ID.