Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
− | | '''Table | + | | '''table |
| | OE.CUSTOMERS | | | OE.CUSTOMERS |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Contains customers data either entered by an employee or by the customer
| |
− | him/herself over the Web.
| |
− | |}
| |
− | | |
− | === Columns ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description
| |
− | | |
− | |- valign="top"
| |
− | | CUSTOMER_ID
| |
− | | NUMBER(6, 0)
| |
− | | not null
| |
− | |
| |
− | | Primary key column.
| |
− | |- valign="top"
| |
− | | CUST_FIRST_NAME
| |
− | | VARCHAR2(20)
| |
− | | not null
| |
− | |
| |
− | | NOT NULL constraint.
| |
− | |- valign="top"
| |
− | | CUST_LAST_NAME
| |
− | | VARCHAR2(20)
| |
− | | not null
| |
− | |
| |
− | | NOT NULL constraint.
| |
− | |- valign="top"
| |
− | | CUST_ADDRESS
| |
− | | OE.CUST_ADDRESS_TYP
| |
− | | null
| |
− | |
| |
− | | Object column of type address_typ.
| |
− | |- valign="top"
| |
− | | PHONE_NUMBERS
| |
− | | OE.PHONE_LIST_TYP
| |
− | | null
| |
− | |
| |
− | | Varray column of type phone_list_typ
| |
− | |- valign="top"
| |
− | | NLS_LANGUAGE
| |
− | | VARCHAR2(3)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | NLS_TERRITORY
| |
− | | VARCHAR2(30)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | CREDIT_LIMIT
| |
− | | NUMBER(9, 2)
| |
− | | null
| |
− | |
| |
− | | Check constraint.
| |
− | |- valign="top"
| |
− | | CUST_EMAIL
| |
− | | VARCHAR2(30)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | ACCOUNT_MGR_ID
| |
− | | NUMBER(6, 0)
| |
− | | null
| |
− | |
| |
− | | References hr.employees.employee_id.
| |
− | |- valign="top"
| |
− | | CUST_GEO_LOCATION
| |
− | | MDSYS.SDO_GEOMETRY
| |
− | | null
| |
− | |
| |
− | | SDO (spatial) column.
| |
− | |- valign="top"
| |
− | | DATE_OF_BIRTH
| |
− | | DATE(7)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | MARITAL_STATUS
| |
− | | VARCHAR2(20)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | GENDER
| |
− | | VARCHAR2(1)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | INCOME_LEVEL
| |
− | | VARCHAR2(20)
| |
− | | null
| |
− | |
| |
− | |
| |
− | |}
| |
− | | |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | CUSTOMERS_PK
| |
− | | CUSTOMER_ID
| |
− | |}
| |
− | | |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− | | |
− | |- valign="top"
| |
− | | CUST_ACCOUNT_MANAGER_IX
| |
− | |
| |
− | | ACCOUNT_MGR_ID
| |
− | |- valign="top"
| |
− | | CUST_EMAIL_IX
| |
− | |
| |
− | | CUST_EMAIL
| |
− | |- valign="top"
| |
− | | CUST_LNAME_IX
| |
− | |
| |
− | | CUST_LAST_NAME
| |
− | |- valign="top"
| |
− | | CUST_UPPER_NAME_IX
| |
− | |
| |
− | |
| |
− | |}
| |
− | | |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− | | |
− | |- valign="top"
| |
− | | CUST_FNAME_NN
| |
− | | "CUST_FIRST_NAME" IS NOT NULL
| |
− | |
| |
− | |- valign="top"
| |
− | | CUST_LNAME_NN
| |
− | | "CUST_LAST_NAME" IS NOT NULL
| |
− | |
| |
− | |- valign="top"
| |
− | | CUSTOMER_CREDIT_LIMIT_MAX
| |
− | | credit_limit <= 5000
| |
− | |
| |
− | |- valign="top"
| |
− | | CUSTOMER_ID_MIN
| |
− | | customer_id > 0
| |
− | |
| |
− | |}
| |
− | | |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− | | |
− | |- valign="top"
| |
− | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| |
− | | ACCOUNT_MGR_ID
| |
− | | EMPLOYEE_ID
| |
− | |}
| |
− | | |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− | | |
− | |- valign="top"
| |
− | | [[OE.ORDERS_(table)|OE.ORDERS]]
| |
− | | CUSTOMER_ID
| |
− | | CUSTOMER_ID
| |
| |} | | |} |