| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| CUST_ID
|
NUMBER(,)
|
N
|
|
primary key
|
| CUST_FIRST_NAME
|
VARCHAR2(20)
|
N
|
|
first name of the customer
|
| CUST_LAST_NAME
|
VARCHAR2(40)
|
N
|
|
last name of the customer
|
| CUST_GENDER
|
CHAR(1)
|
Y
|
|
gender; low cardinality attribute
|
| CUST_YEAR_OF_BIRTH
|
NUMBER(4,0)
|
Y
|
|
customer year of birth
|
| CUST_MARITAL_STATUS
|
VARCHAR2(20)
|
Y
|
|
customer marital status; low cardinality attribute
|
| CUST_STREET_ADDRESS
|
VARCHAR2(40)
|
N
|
|
customer street address
|
| CUST_POSTAL_CODE
|
VARCHAR2(10)
|
N
|
|
postal code of the customer
|
| CUST_CITY
|
VARCHAR2(30)
|
N
|
|
city where the customer lives
|
| CUST_STATE_PROVINCE
|
VARCHAR2(40)
|
Y
|
|
customer geography: state or province
|
| COUNTRY_ID
|
CHAR(2)
|
N
|
|
foreign key to the countries table (snowflake)
|
| CUST_MAIN_PHONE_NUMBER
|
VARCHAR2(25)
|
Y
|
|
customer main phone number
|
| CUST_INCOME_LEVEL
|
VARCHAR2(30)
|
Y
|
|
customer income level
|
| CUST_CREDIT_LIMIT
|
NUMBER(,)
|
Y
|
|
customer credit limit
|
| CUST_EMAIL
|
VARCHAR2(30)
|
Y
|
|
customer email id
|
| CUST_TOTAL
|
VARCHAR2(14)
|
Y
|
'Customer total'
|
|