Object Type	Table
Datasource	IPMA
Database	browseprod

This table contains an icon image for each observation. An icon is a browse product (browse products are icons, postcards and survey products). The browse products are generated, from the Auto Analysis Result (AAR) FITS products, by the browse product generator after BKRP using IPAC, PHT NDC and CAM NDC software.

Use and Related Data

The 'icon' of an observation is automatically displayed next to an observation description in the IDA UI. See also 'postcards' table in the following section.

Population

This table is populated by the script icons.csh after BKRP. The script uses the icon GIF files produced by the browse product generator.

The script can take one or more of the following arguments:

no argsuments:

This assumes that all tables have been created in the database browseprod, and that all temporary tables have been built and populated with the necessary uplink data.

-build:

Forces the building of the ISO Data Archive tables in the browseprod database

-build_all:

Forces the building and population of all temporary tables needed.

-compress:

Is used to indicate that the datafiles have been compressed with the UNIX utility 'compress'. The data files will be re-compressed after use.

-nodrop:

Indicates that temporary tables should not be dropped after use.

Columns

Name	Datatype	Null

obsno	int	No

icon	image	Yes

column icon

Icon image.

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type (0 for prime, 1 for parallel).

Please see SCREW 385.

Table Usage (MB)

Distribution of Table Space

Data	2.29	Data	1.21 %
Indexes	184.71	Indexes	97.33 %
Unused	2.78	Unused	1.47 %
Total	189.78	Number of Rows	59143

Dependencies

Referencing Objects

Object Name Object Type

dbo.icons.icons_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.icons 
(
    obsno int   NOT NULL,
    icon  image NULL
)
LOCK ALLPAGES
go