ScrewTurn Wiki

Edit

wikibot

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

Edit

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  

Edit

Primary Key

Primary KeyColumns
PRD_DESC_PKPRODUCT_ID, LANGUAGE_ID

Edit

Indexes

IndexTypeColumns
PROD_NAME_IX TRANSLATED_NAME

Edit

Check Constraints

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

Edit

Foreign Keys

RelationColumnReferenced Column
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.