PM.PRINT MEDIA (table)

From dbscript Online Help
Revision as of 10:35, 27 August 2011 by Bot (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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