ADDONS schema

The ADDONS schema contains the two BLOB tables IMAGES and DESCRIPTIONS. These tables store two different classes of BLOB object. The table contents cannot be depicted due to the structure of the BLOB tables.

BLOB table IMAGES

The BLOB table IMAGES contains BLOB objects of image class. The BLOB table contains the images referenced by the REF column image in the ITEM_CAT table. The BLOB table is defined as follows:

CREATE TABLE	images OF BLOB
(MIME	('image/gif'),
USAGE	('images for parts.item_cat.image'),
	'Photographer: Hans Sesamer'
)

In the supplied demonstration database, the BLOB table IMAGES contains images in GIF format that can be edited using commercially available graphics programs. For example, it includes the following picture of a bicycle:

BLOB table DESCRIPTIONS

The DESCRIPTIONS table contains BLOB objects of Word document class. The BLOB table contains the documents referenced by the REF column DESC in the ITEM_CAT table. The BLOB table is defined as follows:

CREATE TABLE	description OF BLOB
(MIME	('application/msword'),
USAGE	('word documents for parts.item_cat.desc'),
	'<AUTHOR>Herta Sesamer</AUTHOR>'
)

In the supplied demonstration database, the BLOB table DESCRIPTIONS contains Word documents that can be edited with Microsoft Word. For example, the following document is included as a description of the bicycle: