Object Type	Table
Datasource	IPMA
Database	icsa

A utility table that is used to link an observation (in the observations table) to a list of the pointings that correspond to that observation (in the aph table).

Use and Related Data

Used to relate aph information (aperture ID, guide star used, etc) to an observation.

Population

Done as part of the post-BKRP tasks. Basically, every slew that occurs during an observation is attached to that observation, together with the last slew directly before the start of the observation.

Columns

Name	Datatype	Null

obsno	int	No

pointing_id	numeric(5,0)	No

column obsno

The observation number, a reference to the observations table.

column pointing_id

The pointing ID, a reference to the aph table.

Table Usage (MB)

Distribution of Table Space

Data	2.67	Data	31.77 %
Indexes	5.67	Indexes	67.51 %
Unused	0.06	Unused	0.72 %
Total	8.40	Number of Rows	229378

Dependencies

Referencing Objects

Object Name Object Type

dbo.obs_pointing.obs_pointing_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.obs_pointing 
(
    obsno       int          NOT NULL,
    pointing_id numeric(5,0) NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.obs_pointing.obs_pointing_ix	INDEX