PM PRINT_MEDIA (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| PM.PRINT_MEDIA
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| PRODUCT_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_COMPOSITE
| BLOB(4000)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_SOURCETEXT
| CLOB(4000)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_FINALTEXT
| CLOB(4000)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_FLTEXTN
| NCLOB(4000)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_TEXTDOCS_NTAB
| PM.TEXTDOC_TAB
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_PHOTO
| BLOB(4000)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_GRAPHIC
| BFILE(530)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| AD_HEADER
| PM.ADHEADER_TYP
| null
| &nbsp;
| &nbsp;
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| PRINTMEDIA_PK
| PRODUCT_ID, AD_ID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| SYS_C005057
| &nbsp;
| AD_TEXTDOCS_NTAB
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[OE PRODUCT_INFORMATION (table)|OE.PRODUCT_INFORMATION]]
| PRODUCT_ID
| PRODUCT_ID
|}

devio dbscript ScrewTurn Wiki

Navigation¶

PM PRINT_MEDIA (table)