dbo.observers

 

Object Type

Table

Datasource

IPMA

Database

icsa

 


Contains the administration data for an observer. The values for the following columns are taken directly from the uplink MDB proposal table:

observer identifier
name
department
institution.

Use and Related Data

Every one of these records 'owns' all the proposal records submitted by the corresponding observer.

Population

A script called observers.csh has been developed to create and populate this table. This script creates a temporary table and populates it from the bcp dump of the uplink MDB table observers.

The script can take one or more of the following arguments:

no args: This assumes that the observers table has been created in the database
icsa, and that all temporary tables have been built and populated
with the necessary data.

-build: Forces the building of the observers table in the icsa database

-build_all: Forces the building and population of all temporary tables needed.

-compress: Is used to indicate that the datafiles have been compressed with
the UNIX utility 'compress'. The data files will be re-compressed
after use.

-nodrop: Indicates that temporary tables should not be dropped after use.
Columns
Name Datatype Null
obsid char(8) No
name char(52) Yes
depart char(10) Yes
instit char(52) Yes
column depart

     Departement of the observer.

column instit

     Institute of the observer.

column name

     Name of the observer.

column obsid

     Observer identifier.
 

Table Usage (MB)

Distribution of Table Space

 

Data

0.04

Data

50.00 %

Indexes

0.01

Indexes

15.00 %

Unused

0.03

Unused

35.00 %

Total

0.08

Number of Rows

582

Dependencies
Referencing Objects
Object Name Object Type
dbo.observers.observers_pk INDEX
Referenced Objects
Object Name Object Type

DDL 

CREATE TABLE dbo.observers 
(
    obsid  char(8)  NOT NULL,
    name   char(52) NULL,
    depart char(10) NULL,
    instit char(52) NULL
)
LOCK ALLPAGES
go