This figure shows the structure of the PM schema and its relationships with the oe.product_information table, which was described in the preceding graphic.

Within the PM schema, two tables and two object types are described:

• The online_media table has the columns product_id (primary key), product_photo, product-photo_signature, product_thumbnail, product_video, product_audio, product_text, and product_testimonials.

• The print_media table has the columns product_id (primary key), ad_id, ad_composite, ad_sourcetext, ad_finaltext, ad_fltextn, ad_textdocs_ntab, ad_photo, ad_graphic, ad_header, and press_release. Each product in the print_media table may have one association with the textdoc_typ and one or more associations with the adheader_typ.

• The adheader_typ object type has the attributes header_name, creation_date, header_text, and logo. Each adheader_typ may be associated with a product in the print_media table.

• The textdoc_typ object type has the attributes document_typ and formatted_doc. Each textedoc_typ may be associated with one or more products in the product_media table.

Between the OE and PM schemas:

• Each product in the oe.product_information table may have one or more associations with the products in the pm.online_media table and the pm.print_media table.

• Each product in the pm.online_media table may be associated with one product in the oe.product_information table.

• Each product in the pm.print_media table may be associated with one product in the oe.product_information table.