|
Object
Type
|
Table
|
|
Datasource
|
IPMA
|
|
Database
|
icsa
|
The CAL-G time dependency table. This gives the period of
validity for each time dependent CAL-G file with respect to the products
contained in the product store (CD jukebox).
This is taken from the timedep table in the current IPA.
Use and Related Data
Each entry corresponds to a CAL-G FITS file. Each entry should
be related to the ASCII version of the CAL-G file located in the on-line
library. This can be done either by adding the reference to the entity
or by using a fixed filenaming standard.
Population
The table is populated by the script calg.csh. The tables
are populated with bcp character dump files of the current IPA database
table timedep.
The script can take one or more of the following arguments:
no args:
This assumes that the table has been created in the database
icsa, and that any temporary tables needed have been built and populated
with the necessary data.
-build:
Forces the building of the table 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.
| Name |
Datatype |
Null |
| |
| root |
char(12) |
No |
|
|
| fname |
char(12) |
No |
|
|
| tstart |
char(11) |
No |
|
|
| revstart |
smallint |
No |
|
|
| revtime |
int |
No |
|
|
| comment |
varchar(45) |
No |
|
|
column comment
column fname
column revstart
Revolution number from which CALG file is effective.
column revtime
Time in UTC from which CALG file is effective.
column root
Stem of full FITS CALG filename only.
column tstart
Time from which CALG file is effective. Units: YYDDDHHMMSS.
|
Table
Usage (MB)
|
Distribution
of Table Space
|
|
Data
|
0.01
|
Data
|
37.50
%
|
|
Indexes
|
0.00
|
Indexes
|
0.00
%
|
|
Unused
|
0.01
|
Unused
|
62.50
%
|
|
Total
|
0.02
|
Number
of Rows
|
81
|
CREATE TABLE dbo.cal_g_bkrp_validity
(
root char(12) NOT NULL,
fname char(12) NOT NULL,
tstart char(11) NOT NULL,
revstart smallint NOT NULL,
revtime int NOT NULL,
comment varchar(45) NOT NULL
)
LOCK ALLPAGES
go