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 »
Discuss (0)
View Page Code
History
SH.CUSTOMERS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(8)
»
public.applications_(table)
»
Sales.SalesTerritoryHistory_(table)
»
SH.CUSTOMERS_(table)
[X]
»
Production.ProductModelIllustration_(table)
»
public.vlan_(table)
»
dbo.ErrorLog_(table)
»
OE.STYLESHEET_TAB_(table)
»
SH.PRODUCTS_(table)
»
public.applications_(table)
»
Sales.SalesTerritoryHistory_(table)
»
SH.CUSTOMERS_(table)
Edit
wikibot
Table
SH.CUSTOMERS
Column
Data Type
Nullable
Default
PK
Index
CUST_ID
NUMBER
not null
CUSTOMERS_PK
CUST_FIRST_NAME
VARCHAR2(20)
not null
CUST_LAST_NAME
VARCHAR2(40)
not null
CUST_GENDER
CHAR(1)
not null
CUSTOMERS_GENDER_BIX
CUST_YEAR_OF_BIRTH
NUMBER(4, 0)
not null
CUSTOMERS_YOB_BIX
CUST_MARITAL_STATUS
VARCHAR2(20)
null
CUSTOMERS_MARITAL_BIX
CUST_STREET_ADDRESS
VARCHAR2(40)
not null
CUST_POSTAL_CODE
VARCHAR2(10)
not null
CUST_CITY
VARCHAR2(30)
not null
CUST_CITY_ID
NUMBER
not null
CUST_STATE_PROVINCE
VARCHAR2(40)
not null
CUST_STATE_PROVINCE_ID
NUMBER
not null
COUNTRY_ID
NUMBER
not null
CUST_MAIN_PHONE_NUMBER
VARCHAR2(25)
not null
CUST_INCOME_LEVEL
VARCHAR2(30)
null
CUST_CREDIT_LIMIT
NUMBER
null
CUST_EMAIL
VARCHAR2(30)
null
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
Relation
Column
Referenced Column
SH.COUNTRIES
COUNTRY_ID
COUNTRY_ID
Detail Table
Column
Referencing Column
SH.SALES
CUST_ID
CUST_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.