From dbscript Online Help
wikibot
| Table
|
SH.CUSTOMERS
|
| Description
|
dimension table
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| CUST_ID
|
NUMBER
|
not null
|
|
primary key
|
| CUST_FIRST_NAME
|
VARCHAR2(20)
|
not null
|
|
first name of the customer
|
| CUST_LAST_NAME
|
VARCHAR2(40)
|
not null
|
|
last name of the customer
|
| CUST_GENDER
|
CHAR(1)
|
not null
|
|
gender; low cardinality attribute
|
| CUST_YEAR_OF_BIRTH
|
NUMBER(4, 0)
|
not null
|
|
customer year of birth
|
| CUST_MARITAL_STATUS
|
VARCHAR2(20)
|
null
|
|
customer marital status; low cardinality attribute
|
| CUST_STREET_ADDRESS
|
VARCHAR2(40)
|
not null
|
|
customer street address
|
| CUST_POSTAL_CODE
|
VARCHAR2(10)
|
not null
|
|
postal code of the customer
|
| CUST_CITY
|
VARCHAR2(30)
|
not null
|
|
city where the customer lives
|
| CUST_CITY_ID
|
NUMBER
|
not null
|
|
|
| CUST_STATE_PROVINCE
|
VARCHAR2(40)
|
not null
|
|
customer geography: state or province
|
| CUST_STATE_PROVINCE_ID
|
NUMBER
|
not null
|
|
|
| COUNTRY_ID
|
NUMBER
|
not null
|
|
foreign key to the countries table (snowflake)
|
| CUST_MAIN_PHONE_NUMBER
|
VARCHAR2(25)
|
not null
|
|
customer main phone number
|
| CUST_INCOME_LEVEL
|
VARCHAR2(30)
|
null
|
|
customer income level
|
| CUST_CREDIT_LIMIT
|
NUMBER
|
null
|
|
customer credit limit
|
| CUST_EMAIL
|
VARCHAR2(30)
|
null
|
|
customer email id
|
| 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
|
|
|
Primary Key
| Primary Key
|
Columns
|
| CUSTOMERS_PK
|
CUST_ID
|
Indexes
| Index
|
Type
|
Columns
|
| CUSTOMERS_GENDER_BIX
|
|
CUST_GENDER
|
| CUSTOMERS_MARITAL_BIX
|
|
CUST_MARITAL_STATUS
|
| CUSTOMERS_YOB_BIX
|
|
CUST_YEAR_OF_BIRTH
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| SYS_C005164
|
"CUST_ID" IS NOT NULL
|
|
| SYS_C005165
|
"CUST_FIRST_NAME" IS NOT NULL
|
|
| SYS_C005166
|
"CUST_LAST_NAME" IS NOT NULL
|
|
| SYS_C005167
|
"CUST_GENDER" IS NOT NULL
|
|
| SYS_C005168
|
"CUST_YEAR_OF_BIRTH" IS NOT NULL
|
|
| SYS_C005169
|
"CUST_STREET_ADDRESS" IS NOT NULL
|
|
| SYS_C005170
|
"CUST_POSTAL_CODE" IS NOT NULL
|
|
| SYS_C005171
|
"CUST_CITY" IS NOT NULL
|
|
| SYS_C005172
|
"CUST_CITY_ID" IS NOT NULL
|
|
| SYS_C005173
|
"CUST_STATE_PROVINCE" IS NOT NULL
|
|
| SYS_C005174
|
"CUST_STATE_PROVINCE_ID" IS NOT NULL
|
|
| SYS_C005175
|
"COUNTRY_ID" IS NOT NULL
|
|
| SYS_C005176
|
"CUST_MAIN_PHONE_NUMBER" IS NOT NULL
|
|
| SYS_C005177
|
"CUST_TOTAL" IS NOT NULL
|
|
| SYS_C005178
|
"CUST_TOTAL_ID" IS NOT NULL
|
|
Foreign Keys
| Relation
|
Column
|
Referenced Column
|
| SH.COUNTRIES
|
COUNTRY_ID
|
COUNTRY_ID
|
Detail Tables
| Detail Table
|
Column
|
Referencing Column
|
| SH.SALES
|
CUST_ID
|
CUST_ID
|
