dbo.iasd_observations

Object Type	Table
Datasource	IPMA
Database	publications

Columns

Name	Datatype	Null

obsno	int	No

ra	numeric(13,7)	Yes

dec	numeric(13,7)	Yes

source_name2	char(30)	Yes

source_name3	char(30)	Yes

source_type1	char(30)	Yes

source_type2	char(30)	Yes

source_type3	char(30)	Yes

observing_mode	char(8)	Yes

source_extent	char(1)	No

map_extent	char(20)	Yes

Table Usage (MB)

Distribution of Table Space

Data	0.02	Data	28.13 %
Indexes	0.01	Indexes	9.38 %
Unused	0.04	Unused	62.50 %
Total	0.06	Number of Rows	191

Dependencies

Referencing Objects

Object Name Object Type

dbo.iasd_observations.iasd_observations_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.iasd_observations 
(
    obsno          int           NOT NULL,
    ra             numeric(13,7) NULL,
    dec            numeric(13,7) NULL,
    source_name2   char(30)      NULL,
    source_name3   char(30)      NULL,
    source_type1   char(30)      NULL,
    source_type2   char(30)      NULL,
    source_type3   char(30)      NULL,
    observing_mode char(8)       NULL,
    source_extent  char(1)       NOT NULL,
    map_extent     char(20)      NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.iasd_observations.iasd_observations_ux	INDEX