Difference between revisions of "PM.PRINT MEDIA (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 97: Line 97:
 
|- valign="top"
 
|- valign="top"
 
| SYS_C005057
 
| SYS_C005057
| Unique
+
|  
 
| AD_TEXTDOCS_NTAB
 
| AD_TEXTDOCS_NTAB
 
|}
 
|}
Line 112: Line 112:
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
 
| PRODUCT_ID
|}
 
 
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Dependency Type
 
| '''Object Type
 
| '''Referenced Object
 
 
|- valign="top"
 
| Data Type
 
| Type
 
| [[PM.ADHEADER_TYP_(type)|PM.ADHEADER_TYP]]
 
 
|- valign="top"
 
| Data Type
 
| Type
 
| [[PM.TEXTDOC_TAB_(type)|PM.TEXTDOC_TAB]]
 
 
 
|}
 
|}

Latest revision as of 10:35, 27 August 2011

wikibot[edit]

Table PM.PRINT_MEDIA

Columns[edit]

Column Data Type Nullable Default Description
PRODUCT_ID NUMBER(6, 0) not null
AD_ID NUMBER(6, 0) not null
AD_COMPOSITE BLOB(4000) null
AD_SOURCETEXT CLOB(4000) null
AD_FINALTEXT CLOB(4000) null
AD_FLTEXTN NCLOB(4000) null
AD_TEXTDOCS_NTAB PM.TEXTDOC_TAB null
AD_PHOTO BLOB(4000) null
AD_GRAPHIC BFILE(530) null
AD_HEADER PM.ADHEADER_TYP null

Primary Key[edit]

Primary Key Columns
PRINTMEDIA_PK PRODUCT_ID, AD_ID

Indexes[edit]

Index Type Columns
SYS_C005057 AD_TEXTDOCS_NTAB

Foreign Keys[edit]

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID