au_pix table

au_pix is defined as follows:

create table au_pix
(au_id char(11) not null,
pic image null,
format_type char(11) null,
bytesize int null,
pixwidth_hor char(14) null,
pixwidth_vert char(14) null)

Its primary key is au_id:

sp_primarykey au_pix, au_id

Its au_id column is a foreign key to authors:

sp_foreignkey au_pix, authors, au_id

Table A-11 lists the contents of au_pix:

**Table A-11: au_pix table**
au_id	pic	format_type	bytesize	pixwidth_hor	pixwidth_vert
409-56-7008	0x0000...	PICT	30220	626	635
486-29-1786	0x59a6...	Sunraster	27931	647	640
648-92-1872	0x59a6...	Sunraster	36974	647	640
672-71-3249	0x000a...	PICT	13487	654	639
899-46-2035	0x4949...	TIF	52023	648	641
998-72-3567	0x4949...	TIF	52336	653	637

The pic column contains binary data, which is not reproduced in its entirety in this table. The pictures represented by this data are shown on the next page. Since the image data (six pictures, two each in PICT, TIF, and Sunraster file formats) is quite large, you should run the installpix2 script only if you want to use or test the image datatype. The image data is supplied to show how Sybase stores image data. Sybase does not supply any tools for displaying image data: you must use the appropriate screen graphics tools in order to display the images once you have extracted them from the database.

Figure A-1: Author portraits from the au_pix table