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