Object Type	Table
Datasource	IPMA
Database	icsa

This table contains ISO keywords associated with proposals. This information has been derived directly from the uplink MDB prp_key table.

Use and Related Data

Keywords are associated with each proposal. See uplink mdb.ddl file for further details.

Population

This table is populated by the script uplink_data.csh. The script uses bcp dump files produced by the utility programs dump_mdb and dump_isolog.

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

no args:

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

-build:

Forces the building of the icsa tables in the icsa 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

obsid	char(8)	No

propid	char(8)	No

keyword	varchar(32)	No

column keyword

Keyword(s) associated to a proposal. The keywords have been chosen from a pre-defined set by the PGA user.

column obsid

Observer identifier. Proposal Handling (PH) assigned identifier containing between one and eight characters (upper case, alpha-numeric or underscore; spaces are not allowed).

column propid

Proposal identifier assigned by Proposal Handling (PH). This is a user provided identifier of between one and eight characters (alpha-numeric or underscore, spaces not allowed). Note that the two character launch window extension:
' S' - for the Spring window
' A' - for the Autumn window
present in the uplink MDB has been dropped.

Table Usage (MB)

Distribution of Table Space

Data	0.28	Data	34.38 %
Indexes	0.47	Indexes	58.84 %
Unused	0.05	Unused	6.78 %
Total	0.81	Number of Rows	7084

Dependencies

Referencing Objects

Object Name Object Type

dbo.keywords.keyword_ix INDEX

dbo.keywords.keywords_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.keywords 
(
    obsid   char(8)     NOT NULL,
    propid  char(8)     NOT NULL,
    keyword varchar(32) NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.keywords.keyword_ix	INDEX
dbo.keywords.keywords_ux	INDEX