Difference between revisions of "PM.PRINT MEDIA (table)"
| Line 97: | Line 97: | ||
|- valign="top" | |- valign="top" | ||
| SYS_C005057 | | SYS_C005057 | ||
| − | | | + | | |
| AD_TEXTDOCS_NTAB | | AD_TEXTDOCS_NTAB | ||
|} | |} | ||
| Line 112: | Line 112: | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| PRODUCT_ID | | PRODUCT_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:35, 27 August 2011
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 |
