PM.PRINT MEDIA (table)

From dbscript Online Help
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