PM.PRINT MEDIA (table)

From dbscript Online Help
Jump to: navigation, search

wikibot

Table PM.PRINT_MEDIA

Columns

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

Primary Key Columns
PRINTMEDIA_PK PRODUCT_ID, AD_ID

Indexes

Index Type Columns
SYS_C005057 AD_TEXTDOCS_NTAB

Foreign Keys

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID