Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableOE.CUSTOMERS
DescriptionContains customers data either entered by an employee or by the customer

Columns

ColumnData TypeNullableDefaultDescription
CUSTOMER_IDNUMBER(6, 0)not null Primary key column.
CUST_FIRST_NAMEVARCHAR2(20)not null NOT NULL constraint.
CUST_LAST_NAMEVARCHAR2(20)not null NOT NULL constraint.
CUST_ADDRESSOE.CUST_ADDRESS_TYPnull Object column of type address_typ.
PHONE_NUMBERSOE.PHONE_LIST_TYPnull Varray column of type phone_list_typ
NLS_LANGUAGEVARCHAR2(3)null  
NLS_TERRITORYVARCHAR2(30)null  
CREDIT_LIMITNUMBER(9, 2)null Check constraint.
CUST_EMAILVARCHAR2(30)null  
ACCOUNT_MGR_IDNUMBER(6, 0)null References hr.employees.employee_id.
CUST_GEO_LOCATIONMDSYS.SDO_GEOMETRYnull SDO (spatial) column.
DATE_OF_BIRTHDATE(7)null  
MARITAL_STATUSVARCHAR2(20)null  
GENDERVARCHAR2(1)null  
INCOME_LEVELVARCHAR2(20)null  

Primary Key

Primary KeyColumns
CUSTOMERS_PKCUSTOMER_ID

Indexes

IndexTypeColumns
CUST_ACCOUNT_MANAGER_IX ACCOUNT_MGR_ID
CUST_EMAIL_IX CUST_EMAIL
CUST_LNAME_IX CUST_LAST_NAME
CUST_UPPER_NAME_IX  

Check Constraints

Check ConstraintExpressionDescription
CUST_FNAME_NN"CUST_FIRST_NAME" IS NOT NULL 
CUST_LNAME_NN"CUST_LAST_NAME" IS NOT NULL 
CUSTOMER_CREDIT_LIMIT_MAXcredit_limit <= 5000 
CUSTOMER_ID_MINcustomer_id > 0 

Foreign Keys

RelationColumnReferenced Column
HR.EMPLOYEESACCOUNT_MGR_IDEMPLOYEE_ID

Detail Tables

Detail TableColumnReferencing Column
OE.ORDERSCUSTOMER_IDCUSTOMER_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.