OE.PRODUCT DESCRIPTIONS (table)
From dbscript Online Help
Contents |
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 |
