Difference between revisions of "SH.CUSTOMERS (table)"
| Line 176: | Line 176: | ||
| '''Columns | | '''Columns | ||
| + | |- valign="top" | ||
| + | | CUSTOMERS_GENDER_BIX | ||
| + | | | ||
| + | | CUST_GENDER | ||
|- valign="top" | |- valign="top" | ||
| CUSTOMERS_MARITAL_BIX | | CUSTOMERS_MARITAL_BIX | ||
| Line 184: | Line 188: | ||
| | | | ||
| CUST_YEAR_OF_BIRTH | | CUST_YEAR_OF_BIRTH | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:36, 27 August 2011
Contents
wikibot[edit]
| Table | SH.CUSTOMERS |
| Description | dimension table |
Columns[edit]
| 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[edit]
| Primary Key | Columns |
| CUSTOMERS_PK | CUST_ID |
Indexes[edit]
| Index | Type | Columns |
| CUSTOMERS_GENDER_BIX | CUST_GENDER | |
| CUSTOMERS_MARITAL_BIX | CUST_MARITAL_STATUS | |
| CUSTOMERS_YOB_BIX | CUST_YEAR_OF_BIRTH |
Check Constraints[edit]
| 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[edit]
| Relation | Column | Referenced Column |
| SH.COUNTRIES | COUNTRY_ID | COUNTRY_ID |
Detail Tables[edit]
| Detail Table | Column | Referencing Column |
| SH.SALES | CUST_ID | CUST_ID |
