PM ONLINE_MEDIA (table)
wikibot
¶
Table
PM.ONLINE_MEDIA
Columns
¶
Column
Data Type
Nullable
Default
Description
PRODUCT_ID
NUMBER(6, 0)
not null
PRODUCT_PHOTO
ORDSYS.ORDIMAGE
null
PRODUCT_PHOTO_SIGNATURE
ORDSYS.ORDIMAGESIGNATURE
null
PRODUCT_THUMBNAIL
ORDSYS.ORDIMAGE
null
PRODUCT_VIDEO
ORDSYS.ORDVIDEO
null
PRODUCT_AUDIO
ORDSYS.ORDAUDIO
null
PRODUCT_TEXT
CLOB(4000)
null
PRODUCT_TESTIMONIALS
ORDSYS.ORDDOC
null
Primary Key
¶
Primary Key
Columns
ONLINEMEDIA_PK
PRODUCT_ID
Foreign Keys
¶
Relation
Column
Referenced Column
OE.PRODUCT_INFORMATION
PRODUCT_ID
PRODUCT_ID