OPTIM_CUSTOMERS Table

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_CUSTOMERS table is a child of:



Feedback