OE.PRODUCT DESCRIPTIONS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table OE.PRODUCT_DESCRIPTIONS
Description Non-industry-specific design, allows selection of NLS-setting-specific data

derived at runtime, for example using the products view.

Columns

Column Data Type Nullable Default Description
PRODUCT_ID NUMBER(6, 0) not null Primary key column.
LANGUAGE_ID VARCHAR2(3) not null Primary key column.
TRANSLATED_NAME NVARCHAR2(150) not null
TRANSLATED_DESCRIPTION NVARCHAR2(4000) not null

Primary Key

Primary Key Columns
PRD_DESC_PK PRODUCT_ID, LANGUAGE_ID

Indexes

Index Type Columns
PROD_NAME_IX TRANSLATED_NAME

Check Constraints

Check Constraint Expression Description
TRANSLATED_DESC_NN "TRANSLATED_DESCRIPTION" IS NOT NULL
TRANSLATED_NAME_NN "TRANSLATED_NAME" IS NOT NULL

Foreign Keys

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID