Object Type	Table
Datasource	IPMA
Database	controls

Columns

Name	Datatype	Null

reqnum	char(16)	No

obsno	int	No

levstart	varchar(14)	No

levend	varchar(14)	No

reproc	char(1)	No

area	varchar(40)	Yes

cache_file	varchar(42)	Yes

status	varchar(24)	No

download	char(1)	Yes

Table Usage (MB)

Distribution of Table Space

Data	42.35	Data	39.22 %
Indexes	61.39	Indexes	56.87 %
Unused	4.22	Unused	3.91 %
Total	107.96	Number of Rows	682983

Dependencies

Referencing Objects

Object Name Object Type

dbo.product_set.pset_trig TRIGGER

dbo.pmrobs.pmrobs_ix INDEX

dbo.pmrobs.pmrobs_ix2 INDEX

dbo.pmrobs.pmrobs_ix3 INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pmrobs 
(
    reqnum     char(16)    NOT NULL,
    obsno      int         NOT NULL,
    levstart   varchar(14) NOT NULL,
    levend     varchar(14) NOT NULL,
    reproc     char(1)     NOT NULL,
    area       varchar(40) NULL,
    cache_file varchar(42) NULL,
    status     varchar(24) NOT NULL,
    download   char(1)     NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.product_set.pset_trig	TRIGGER
dbo.pmrobs.pmrobs_ix	INDEX
dbo.pmrobs.pmrobs_ix2	INDEX
dbo.pmrobs.pmrobs_ix3	INDEX