OE PRODUCT_DESCRIPTIONS (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_DESCRIPTIONS
|- valign="top"
| '''Description'''
| Non-industry-specific design, allows selection of NLS-setting-specific data
derived at runtime, for example using the products view.
|}

=== 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"
| LANGUAGE_ID
| VARCHAR2(3)
| not null
| &nbsp;
| Primary key column.
|- valign="top"
| TRANSLATED_NAME
| NVARCHAR2(150)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| TRANSLATED_DESCRIPTION
| NVARCHAR2(4000)
| not null
| &nbsp;
| &nbsp;
|}

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

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

|- valign="top"
| PROD_NAME_IX
| &nbsp;
| TRANSLATED_NAME
|}

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

|- valign="top"
| TRANSLATED_DESC_NN
| "TRANSLATED_DESCRIPTION" IS NOT NULL
| &nbsp;
|- valign="top"
| TRANSLATED_NAME_NN
| "TRANSLATED_NAME" IS NOT NULL
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[OE PRODUCT_INFORMATION (table)|OE.PRODUCT_INFORMATION]]
| PRODUCT_ID
| PRODUCT_ID
|}

devio dbscript ScrewTurn Wiki

Navigation¶

OE PRODUCT_DESCRIPTIONS (table)