dbo.pprs

Object Type	Table
Datasource	IPMA
Database	icsa

Columns

Name	Datatype	Null

obsno	int	No

subsys	char(2)	No

pixel	smallint	No

readauto	int	No

readsusp	int	No

readofft	int	No

readcop	int	No

rampsat	int	No

rampdegl	int	No

ramppct	real	No

rampuset	real	No

platnorp	int	No

platdrop	int	No

numdrs	int	No

numndrs	int	No

mindegl	smallint	No

maxerr	real	No

numiter	smallint	No

numlocal	int	No

numstep	int	No

numsigma	real	No

numbad	smallint	No

drift	char(1)	No

rfitdeg	tinyint	No

discndrs	smallint	No

drflag	char(1)	No

Table Usage (MB)

Distribution of Table Space

Data	1.58	Data	85.07 %
Indexes	0.22	Indexes	11.88 %
Unused	0.06	Unused	3.05 %
Total	1.86	Number of Rows	18541

Dependencies

Referencing Objects

Object Name Object Type

dbo.pprs.pprs_pk INDEX

dbo.pprs.observations_pht_p_det_resp_fk INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.pprs 
(
    obsno    int      NOT NULL,
    subsys   char(2)  NOT NULL,
    pixel    smallint NOT NULL,
    readauto int      NOT NULL,
    readsusp int      NOT NULL,
    readofft int      NOT NULL,
    readcop  int      NOT NULL,
    rampsat  int      NOT NULL,
    rampdegl int      NOT NULL,
    ramppct  real     NOT NULL,
    rampuset real     NOT NULL,
    platnorp int      NOT NULL,
    platdrop int      NOT NULL,
    numdrs   int      NOT NULL,
    numndrs  int      NOT NULL,
    mindegl  smallint NOT NULL,
    maxerr   real     NOT NULL,
    numiter  smallint NOT NULL,
    numlocal int      NOT NULL,
    numstep  int      NOT NULL,
    numsigma real     NOT NULL,
    numbad   smallint NOT NULL,
    drift    char(1)  NOT NULL,
    rfitdeg  tinyint  NOT NULL,
    discndrs smallint NOT NULL,
    drflag   char(1)  NOT NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.pprs.pprs_pk	INDEX
dbo.pprs.observations_pht_p_det_resp_fk	INDEX