dbo.pht_common

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


Planned details of PHT observations using the following AOTs:

PHT P AOTs: P03, P04, P05, P17, P18, P19

PHT C AOTs: P22, P25, P37, P38, P29

PHT S AOTs: P40

The data attributes of this entity have been directly derived from the uplink MDB table pht_pcs_common.

Use and RelatedData

None.

Population

This table is populated by the script uplink_data.csh, as have other uplink derived tables.

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 icsa, and that all temporary
tables have been built and populated with the necessary uplink data.

-build: Forces the building of the IDA 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
obsno int No
srctype char(1) Yes
nmes int Yes


column nmes

Extended component for P04.
column obsno
Observation number constructed as follows:
revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type.
Please see SCREW 385.
column srctype
Source type as follows:
P     point source
E     extended source.

 

Table Usage (MB)

Distribution of Table Space

 

Data

0.28

Data

85.12 %

Indexes

0.00

Indexes

0.60 %

Unused

0.05

Unused

14.29 %

Total

0.33

Number of Rows

15057

Dependencies
Referencing Objects
Object Name Object Type
dbo.pht_common.pht_common_pk INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.pht_common 
(
    obsno   int     NOT NULL,
    srctype char(1) NULL,
    nmes    int     NULL
)
LOCK ALLPAGES
go