ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
OE.PRODUCT_DESCRIPTIONS_(table)
Print
RSS
Modified: 2011/08/27 11:08 by
wikibot
-
Uncategorized
(4)
»
SH.CAL_MONTH_SALES_MV_(table)
»
public.getmanagepercentavailintfwindow_(function)
»
OE.PRODUCT_DESCRIPTIONS_(table)
[X]
»
PM.ADHEADER_TYP_(type)
»
SH.CAL_MONTH_SALES_MV_(table)
»
public.getmanagepercentavailintfwindow_(function)
»
OE.PRODUCT_DESCRIPTIONS_(table)
Edit
wikibot
Table
OE.PRODUCT_DESCRIPTIONS
Description
Non-industry-specific design, allows selection of NLS-setting-specific data
Edit
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
Edit
Primary Key
Primary Key
Columns
PRD_DESC_PK
PRODUCT_ID, LANGUAGE_ID
Edit
Indexes
Index
Type
Columns
PROD_NAME_IX
TRANSLATED_NAME
Edit
Check Constraints
Check Constraint
Expression
Description
TRANSLATED_DESC_NN
"TRANSLATED_DESCRIPTION" IS NOT NULL
TRANSLATED_NAME_NN
"TRANSLATED_NAME" IS NOT NULL
Edit
Foreign Keys
Relation
Column
Referenced Column
OE.PRODUCT_INFORMATION
PRODUCT_ID
PRODUCT_ID
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.