SH CUSTOMERS (table)

wikibot

TableSH.CUSTOMERS
Descriptiondimension table

Columns

ColumnData TypeNullableDefaultDescription
CUST_IDNUMBERnot null primary key
CUST_FIRST_NAMEVARCHAR2(20)not null first name of the customer
CUST_LAST_NAMEVARCHAR2(40)not null last name of the customer
CUST_GENDERCHAR(1)not null gender; low cardinality attribute
CUST_YEAR_OF_BIRTHNUMBER(4, 0)not null customer year of birth
CUST_MARITAL_STATUSVARCHAR2(20)null customer marital status; low cardinality attribute
CUST_STREET_ADDRESSVARCHAR2(40)not null customer street address
CUST_POSTAL_CODEVARCHAR2(10)not null postal code of the customer
CUST_CITYVARCHAR2(30)not null city where the customer lives
CUST_CITY_IDNUMBERnot null  
CUST_STATE_PROVINCEVARCHAR2(40)not null customer geography: state or province
CUST_STATE_PROVINCE_IDNUMBERnot null  
COUNTRY_IDNUMBERnot null foreign key to the countries table (snowflake)
CUST_MAIN_PHONE_NUMBERVARCHAR2(25)not null customer main phone number
CUST_INCOME_LEVELVARCHAR2(30)null customer income level
CUST_CREDIT_LIMITNUMBERnull customer credit limit
CUST_EMAILVARCHAR2(30)null customer email id
CUST_TOTALVARCHAR2(14)not null  
CUST_TOTAL_IDNUMBERnot null  
CUST_SRC_IDNUMBERnull  
CUST_EFF_FROMDATE(7)null  
CUST_EFF_TODATE(7)null  
CUST_VALIDVARCHAR2(1)null  

Primary Key

Primary KeyColumns
CUSTOMERS_PKCUST_ID

Indexes

IndexTypeColumns
CUSTOMERS_GENDER_BIX CUST_GENDER
CUSTOMERS_MARITAL_BIX CUST_MARITAL_STATUS
CUSTOMERS_YOB_BIX CUST_YEAR_OF_BIRTH

Check Constraints

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

RelationColumnReferenced Column
SH.COUNTRIESCOUNTRY_IDCOUNTRY_ID

Detail Tables

Detail TableColumnReferencing Column
SH.SALESCUST_IDCUST_ID