Object Type	Table
Datasource	IPMA
Database	icsa

All attributes of this data entity are derived directly from the sdarkcur table of the IPA database.

Use and Related Data

See the ISO Data Product Document, IDPD SAI/94-1266/Dc for a further description of the columns in this table.

Population

This table has been populated during BKRP by db-import.

Columns

Name	Datatype	Null

itk_start	int	No

itk_end	int	No

obsno	int	Yes

detector	smallint	No

flux	real	No

noise	real	No

gain	smallint	No

flag	tinyint	No

re_set	smallint	No

column detector

Detector number.

column flag

Was checked data applied (0, 1).

column flux

Mean photometric check flux.

column gain

Gain factor per detector.

column itk_end

End time ITK.

column itk_start

Start time ITK.

column noise

Photometric check noise.

column obsno

Observation number constructed as follows:

revolution number * 1000000 + target number * 1000 + observation sequence number * 10 + type (0, 1 or 2 depending on prime, CAM or LWS ||).

See SCREW 385 for further details.

column reset

Reset time per grating.

Table Usage (MB)

Distribution of Table Space

Data	67.95	Data	50.22 %
Indexes	67.21	Indexes	49.68 %
Unused	0.13	Unused	0.10 %
Total	135.29	Number of Rows	1948128

Dependencies

Referencing Objects

Object Name Object Type

dbo.sdarkcur.sdarkcur_ux INDEX

dbo.sdarkcur.sdarkcur_ux2 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sdarkcur 
(
    itk_start int      NOT NULL,
    itk_end   int      NOT NULL,
    obsno     int      NULL,
    detector  smallint NOT NULL,
    flux      real     NOT NULL,
    noise     real     NOT NULL,
    gain      smallint NOT NULL,
    flag      tinyint  NOT NULL,
    re_set    smallint NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sdarkcur.sdarkcur_ux	INDEX
dbo.sdarkcur.sdarkcur_ux2	INDEX