Object Type	Table
Datasource	IPMA
Database	browseprod

This table contains a postcard image for each observation. A postcard is a browse product (browse products are icons, postcards and survey products). The browse products are generated, form the AAR FIRS products, by the browse product generator after BKRP using IPAC, PHT NDC and CAM NDC software.

Use and Related Data

A postcard can be displayed and manipulated using the Survey Product Display Tool (SPDT), which can be accessed by selecting the icon of an observation in the IDA UI.

Population

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

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

no args:

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

postcard	image	Yes

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.

Please see SCREW 385.

column postcard

Postcard image.

Table Usage (MB)

Distribution of Table Space

Data	10.50	Data	0.86 %
Indexes	1207.89	Indexes	98.82 %
Unused	3.97	Unused	0.32 %
Total	1222.37	Number of Rows	59143

Dependencies

Referencing Objects

Object Name Object Type

dbo.postcards.postcards_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.postcards 
(
    obsno    int   NOT NULL,
    postcard image NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.postcards.postcards_ux	INDEX