OE PRODUCT_DESCRIPTIONS (table)

wikibot

TableOE.PRODUCT_DESCRIPTIONS
DescriptionNon-industry-specific design, allows selection of NLS-setting-specific data

Columns

ColumnData TypeNullableDefaultDescription
PRODUCT_IDNUMBER(6, 0)not null Primary key column.
LANGUAGE_IDVARCHAR2(3)not null Primary key column.
TRANSLATED_NAMENVARCHAR2(150)not null  
TRANSLATED_DESCRIPTIONNVARCHAR2(4000)not null  

Primary Key

Primary KeyColumns
PRD_DESC_PKPRODUCT_ID, LANGUAGE_ID

Indexes

IndexTypeColumns
PROD_NAME_IX TRANSLATED_NAME

Check Constraints

Check ConstraintExpressionDescription
TRANSLATED_DESC_NN"TRANSLATED_DESCRIPTION" IS NOT NULL 
TRANSLATED_NAME_NN"TRANSLATED_NAME" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID