| 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
|
|
|
| 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
|
|
