ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
SH.CUSTOMERS_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | SH.CUSTOMERS |- valign="top" | '''Description''' | dimension table |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | CUST_ID | NUMBER | not null | | primary key |- valign="top" | CUST_FIRST_NAME | VARCHAR2(20) | not null | | first name of the customer |- valign="top" | CUST_LAST_NAME | VARCHAR2(40) | not null | | last name of the customer |- valign="top" | CUST_GENDER | CHAR(1) | not null | | gender; low cardinality attribute |- valign="top" | CUST_YEAR_OF_BIRTH | NUMBER(4, 0) | not null | | customer year of birth |- valign="top" | CUST_MARITAL_STATUS | VARCHAR2(20) | null | | customer marital status; low cardinality attribute |- valign="top" | CUST_STREET_ADDRESS | VARCHAR2(40) | not null | | customer street address |- valign="top" | CUST_POSTAL_CODE | VARCHAR2(10) | not null | | postal code of the customer |- valign="top" | CUST_CITY | VARCHAR2(30) | not null | | city where the customer lives |- valign="top" | CUST_CITY_ID | NUMBER | not null | | |- valign="top" | CUST_STATE_PROVINCE | VARCHAR2(40) | not null | | customer geography: state or province |- valign="top" | CUST_STATE_PROVINCE_ID | NUMBER | not null | | |- valign="top" | COUNTRY_ID | NUMBER | not null | | foreign key to the countries table (snowflake) |- valign="top" | CUST_MAIN_PHONE_NUMBER | VARCHAR2(25) | not null | | customer main phone number |- valign="top" | CUST_INCOME_LEVEL | VARCHAR2(30) | null | | customer income level |- valign="top" | CUST_CREDIT_LIMIT | NUMBER | null | | customer credit limit |- valign="top" | CUST_EMAIL | VARCHAR2(30) | null | | customer email id |- valign="top" | CUST_TOTAL | VARCHAR2(14) | not null | | |- valign="top" | CUST_TOTAL_ID | NUMBER | not null | | |- valign="top" | CUST_SRC_ID | NUMBER | null | | |- valign="top" | CUST_EFF_FROM | DATE(7) | null | | |- valign="top" | CUST_EFF_TO | DATE(7) | null | | |- valign="top" | CUST_VALID | VARCHAR2(1) | null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | CUSTOMERS_PK | CUST_ID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | CUSTOMERS_GENDER_BIX | | CUST_GENDER |- valign="top" | CUSTOMERS_MARITAL_BIX | | CUST_MARITAL_STATUS |- valign="top" | CUSTOMERS_YOB_BIX | | CUST_YEAR_OF_BIRTH |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | SYS_C005164 | "CUST_ID" IS NOT NULL | |- valign="top" | SYS_C005165 | "CUST_FIRST_NAME" IS NOT NULL | |- valign="top" | SYS_C005166 | "CUST_LAST_NAME" IS NOT NULL | |- valign="top" | SYS_C005167 | "CUST_GENDER" IS NOT NULL | |- valign="top" | SYS_C005168 | "CUST_YEAR_OF_BIRTH" IS NOT NULL | |- valign="top" | SYS_C005169 | "CUST_STREET_ADDRESS" IS NOT NULL | |- valign="top" | SYS_C005170 | "CUST_POSTAL_CODE" IS NOT NULL | |- valign="top" | SYS_C005171 | "CUST_CITY" IS NOT NULL | |- valign="top" | SYS_C005172 | "CUST_CITY_ID" IS NOT NULL | |- valign="top" | SYS_C005173 | "CUST_STATE_PROVINCE" IS NOT NULL | |- valign="top" | SYS_C005174 | "CUST_STATE_PROVINCE_ID" IS NOT NULL | |- valign="top" | SYS_C005175 | "COUNTRY_ID" IS NOT NULL | |- valign="top" | SYS_C005176 | "CUST_MAIN_PHONE_NUMBER" IS NOT NULL | |- valign="top" | SYS_C005177 | "CUST_TOTAL" IS NOT NULL | |- valign="top" | SYS_C005178 | "CUST_TOTAL_ID" IS NOT NULL | |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[SH.COUNTRIES_(table)|SH.COUNTRIES]] | COUNTRY_ID | COUNTRY_ID |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[SH.SALES_(table)|SH.SALES]] | CUST_ID | CUST_ID |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.