ScrewTurn Wiki

Edit

wikibot

TablePM.PRINT_MEDIA

Edit

Columns

ColumnData TypeNullableDefaultDescription
PRODUCT_IDNUMBER(6, 0)not null  
AD_IDNUMBER(6, 0)not null  
AD_COMPOSITEBLOB(4000)null  
AD_SOURCETEXTCLOB(4000)null  
AD_FINALTEXTCLOB(4000)null  
AD_FLTEXTNNCLOB(4000)null  
AD_TEXTDOCS_NTABPM.TEXTDOC_TABnull  
AD_PHOTOBLOB(4000)null  
AD_GRAPHICBFILE(530)null  
AD_HEADERPM.ADHEADER_TYPnull  

Edit

Primary Key

Primary KeyColumns
PRINTMEDIA_PKPRODUCT_ID, AD_ID

Edit

Indexes

IndexTypeColumns
SYS_C005057 AD_TEXTDOCS_NTAB

Edit

Foreign Keys

RelationColumnReferenced Column
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.