dbo.pht_timelines

 

Object Type

Table

Datasource

IPMA

Database

icsa

 

PHT PV and routine phase calibration observation timelines. These files (pvppat_tlRRR.txi files) were generated for each PHT calibration revolution.

Use and Related Data

A timeline is available for each PHT calibration revolution.

Population

Retrieved from PHT calibration account. Note that the timelines for the following revolutions are missing:
086, 105, 360, 395, 420, 441, 661, 662, 665, 672, 673 & 675
These need to be re-generated at some point (B.Schultz).
Columns
Name Datatype Null
revno int No
timeline text No
column revno
The revolution number for which the timeline was generated.
column timeline
The PHT calibration timeline - an ascII file.

Table Usage (MB)

Distribution of Table Space

 

Data

0.01

Data

0.42 %

Indexes

1.34

Indexes

95.42 %

Unused

0.06

Unused

4.17 %

Total

1.41

Number of Rows

150

Dependencies
Referencing Objects
Object Name Object Type
dbo.pht_timelines.pht_timelines_pk INDEX
Referenced Objects
Object Name Object Type

DDL

CREATE TABLE dbo.pht_timelines 
(
    revno    int  NOT NULL,
    timeline text NOT NULL
)
LOCK ALLPAGES
go