From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| CUST_ID
|
NUMBER
|
not null
|
|
CUSTOMERS_PK
|
|
| CUST_FIRST_NAME
|
VARCHAR2(20)
|
not null
|
|
|
|
| CUST_LAST_NAME
|
VARCHAR2(40)
|
not null
|
|
|
|
| CUST_GENDER
|
CHAR(1)
|
not null
|
|
|
CUSTOMERS_GENDER_BIX
|
| CUST_YEAR_OF_BIRTH
|
NUMBER(4, 0)
|
not null
|
|
|
CUSTOMERS_YOB_BIX
|
| CUST_MARITAL_STATUS
|
VARCHAR2(20)
|
null
|
|
|
CUSTOMERS_MARITAL_BIX
|
| CUST_STREET_ADDRESS
|
VARCHAR2(40)
|
not null
|
|
|
|
| CUST_POSTAL_CODE
|
VARCHAR2(10)
|
not null
|
|
|
|
| CUST_CITY
|
VARCHAR2(30)
|
not null
|
|
|
|
| CUST_CITY_ID
|
NUMBER
|
not null
|
|
|
|
| CUST_STATE_PROVINCE
|
VARCHAR2(40)
|
not null
|
|
|
|
| CUST_STATE_PROVINCE_ID
|
NUMBER
|
not null
|
|
|
|
| COUNTRY_ID
|
NUMBER
|
not null
|
|
|
|
| CUST_MAIN_PHONE_NUMBER
|
VARCHAR2(25)
|
not null
|
|
|
|
| CUST_INCOME_LEVEL
|
VARCHAR2(30)
|
null
|
|
|
|
| CUST_CREDIT_LIMIT
|
NUMBER
|
null
|
|
|
|
| CUST_EMAIL
|
VARCHAR2(30)
|
null
|
|
|
|
| CUST_TOTAL
|
VARCHAR2(14)
|
not null
|
|
|
|
| CUST_TOTAL_ID
|
NUMBER
|
not null
|
|
|
|
| CUST_SRC_ID
|
NUMBER
|
null
|
|
|
|
| CUST_EFF_FROM
|
DATE(7)
|
null
|
|
|
|
| CUST_EFF_TO
|
DATE(7)
|
null
|
|
|
|
| CUST_VALID
|
VARCHAR2(1)
|
null
|
|
|
|
| Relation
|
Column
|
Referenced Column
|
| SH.COUNTRIES
|
COUNTRY_ID
|
COUNTRY_ID
|
| Detail Table
|
Column
|
Referencing Column
|
| SH.SALES
|
CUST_ID
|
CUST_ID
|
