OE PRODUCT_INFORMATION (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| OE.PRODUCT_INFORMATION
|- valign="top"
| '''Description'''
| Non-industry-specific data in various categories.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| PRODUCT_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| Primary key column.
|- valign="top"
| PRODUCT_NAME
| VARCHAR2(50)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| PRODUCT_DESCRIPTION
| VARCHAR2(2000)
| null
| &nbsp;
| Primary language description corresponding to translated_description in
oe.product_descriptions, added to provide non-NLS text columns for OC views
to accss.
|- valign="top"
| CATEGORY_ID
| NUMBER(2, 0)
| null
| &nbsp;
| Low cardinality column, can be used for bitmap index.
Schema SH uses it as foreign key
|- valign="top"
| WEIGHT_CLASS
| NUMBER(1, 0)
| null
| &nbsp;
| Low cardinality column, can be used for bitmap index.
|- valign="top"
| WARRANTY_PERIOD
| INTERVAL YEAR(2) TO MONTH
| null
| &nbsp;
| INTERVAL YEAER TO MONTH column, low cardinality, can be used for bitmap
index.
|- valign="top"
| SUPPLIER_ID
| NUMBER(6, 0)
| null
| &nbsp;
| Offers possibility of extensions outside Common Schema.
|- valign="top"
| PRODUCT_STATUS
| VARCHAR2(20)
| null
| &nbsp;
| Check constraint. Appropriate for complex rules, such as "All products in
status PRODUCTION must have at least one inventory entry." Also appropriate
for a trigger auditing status change.
|- valign="top"
| LIST_PRICE
| NUMBER(8, 2)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| MIN_PRICE
| NUMBER(8, 2)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| CATALOG_URL
| VARCHAR2(50)
| null
| &nbsp;
| &nbsp;
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| PRODUCT_INFORMATION_PK
| PRODUCT_ID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| PROD_SUPPLIER_IX
| &nbsp;
| SUPPLIER_ID
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| PRODUCT_STATUS_LOV
| product_status in ('orderable'
                                                  ,'planned'
                                                  ,'under development'
                                                  ,'obsolete')
                               
| &nbsp;
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[OE INVENTORIES (table)|OE.INVENTORIES]]
| PRODUCT_ID
| PRODUCT_ID
|- valign="top"
| [[PM ONLINE_MEDIA (table)|PM.ONLINE_MEDIA]]
| PRODUCT_ID
| PRODUCT_ID
|- valign="top"
| [[OE ORDER_ITEMS (table)|OE.ORDER_ITEMS]]
| PRODUCT_ID
| PRODUCT_ID
|- valign="top"
| [[OE PRODUCT_DESCRIPTIONS (table)|OE.PRODUCT_DESCRIPTIONS]]
| PRODUCT_ID
| PRODUCT_ID
|- valign="top"
| [[PM PRINT_MEDIA (table)|PM.PRINT_MEDIA]]
| PRODUCT_ID
| PRODUCT_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

OE PRODUCT_INFORMATION (table)
