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
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| PRODUCT_ID
|
NUMBER(6,0)
|
N
|
|
Primary key column.
|
| LANGUAGE_ID
|
VARCHAR2(3)
|
N
|
|
Primary key column.
|
| TRANSLATED_NAME
|
NVARCHAR2(100)
|
N
|
|
|
| TRANSLATED_DESCRIPTION
|
NVARCHAR2(4000)
|
N
|
|
|
Primary key
Check constraints
| Check constraint
|
Check condition
|
| TRANSLATED_DESC_NN
|
"TRANSLATED_DESCRIPTION" IS NOT NULL
|
| TRANSLATED_NAME_NN
|
"TRANSLATED_NAME" IS NOT NULL
|
Foreign keys
Indexes
Options
| Option
|
Setting
|
| Clustered
|
N
|
| Generated by Oracle
|
N
|
| Index Organized
|
N
|
| Logging
|
Y
|
| Partitioned
|
N
|
| Temporary
|
N
|
| Nested
|
N
|
Generated by OraDoclet, Copyright © Oracle Corporation 2005 Last updated: 01.01.2005