From dbscript Online Help
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
