dbo.sphtgain

Object Type	Table
Datasource	IPMA
Database	icsa

Columns

Name	Datatype	Null

obsno	int	No

utc_start	int	Yes

utc_end	int	Yes

itk_start	int	No

itk_end	int	No

band	int	No

gain	float	No

error_gain	float	No

npoints	int	No

Table Usage (MB)

Distribution of Table Space

Data	0.88	Data	58.63 %
Indexes	0.58	Indexes	38.52 %
Unused	0.04	Unused	2.85 %
Total	1.51	Number of Rows	22590

Dependencies

Referencing Objects

Object Name Object Type

dbo.sphtgain.sphtgain_ux INDEX

dbo.sphtgain.sphtgain_ix INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.sphtgain 
(
    obsno      int   NOT NULL,
    utc_start  int   NULL,
    utc_end    int   NULL,
    itk_start  int   NOT NULL,
    itk_end    int   NOT NULL,
    band       int   NOT NULL,
    gain       float NOT NULL,
    error_gain float NOT NULL,
    npoints    int   NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.sphtgain.sphtgain_ux	INDEX
dbo.sphtgain.sphtgain_ix	INDEX