PM Sample Schema Table Descriptions

4.7 PM Sample Schema Table Descriptions

Consider the columns of each table of PM sample schema.

Table 4-21 PM.ONLINE_MEDIA Table Description

Column Name	Null?	Type
`PRODUCT_ID`	`NOT NULL`	`NUMBER(6)`
`PRODUCT_PHOTO`		`ORDSYS.ORDIMAGE`
`PRODUCT_PHOTO_SIGNATURE`		`ORDSYS.ORDIMAGESIGNATURE` This type, `ORDImageSignature`, is deprecated; do not use it in new code. Existing occurrences of this object type will continue to function as in the past.
`PRODUCT_THUMBNAIL`		`ORDSYS.ORDIMAGE`
`PRODUCT_VIDEO`		`ORDSYS.ORDVIDEO`
`PRODUCT_AUDIO`		`ORDSYS.ORDAUDIO`
`PRODUCT_TEXT`		`CLOB`
`PRODUCT_TESTIMONIALS`		`ORDSYS.ORDDOC`

Table 4-22 PM.PRINT_MEDIA Table Description