This figure shows the structure of schema PM and its relationships with table oe.product_information
.
The online_media
table has the following attributes:
Columns: product_id
(primary key), product_photo
, product_photo_signature
, product_thumbnail
, product_video
, product_audio
, product_text
, product_testimonials.
Note that the type for product_photo_signature, ORDImageSignature, has been deprecated.
Other Relationships:
Column product_id
relates one or more rows of the table online_media
to one row of the table oe.product_information
with the corresponding value of product_id
.
The online_media
table has the following attributes:
Columns: product_id
(primary key), ad_id
, ad_composite
, ad_sourcetext
, ad_finaltext
, ad_fltextn
, ad_textdocs_ntab
, ad_photo
, ad_graphic
, and ad_header
Other Relationships:
Column product_id
relates one or more rows of the table print_media
to one row of the table oe.product_information
with the corresponding value of product_id
.