From rene@asl.cr.usgs.gov Fri Sep  5 13:43:57 1997
Date: Fri, 5 Sep 1997 14:41:13 -0600
From: rene@asl.cr.usgs.gov (Rene Hallett)
To: stephane@seismo.berkeley.edu
Subject: Re: Schema for Instr. responses
Cc: rene@asl.cr.usgs.gov
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-MD5: RVYV18KrwmAnihT9HBqYrg==
Content-Length: 18726
Status: RO
X-Lines: 531

Stephane,

    I just wanted to let you know that I got your message.  I'm happy to
    send you what we've got.  However, our schema is not optimal.  It was
    developed when we knew next to nothing about ORACLE but needed to
    crank out something in a hurry.  I'm just now getting around to having
    some time to think about the next incarnation.  What we have is a set
    of tables based upon the seed headers as describe in the SEED reference
    manual with some extra fields thrown in for internal processing needs.
    I tried to match each table field to type and size of the seed header
    fields.  Below will be some table definitions.  I working on the idea
    of clustering some or all of these tables in some manner.
        
    As far as applications go I started out by creating a set of proC
    routines which are very simplistic.  They have a lot of constraint
    checking in them because at that time ORACLE had designed constraints
    but had not implemented them yet.  I'm considering redoing those
    routines with dynamic sql.  It will make for ugly hard to read code,
    however, I'm hoping that it will reduce the number of routines I need
    to maintain.
    
    I've also written a few GUIs using MOTIF to interact with the database.
    Same story here.  The main one is old and decrepit and not really all that
    easy to use.  Again, something I wrote when I was just learning ORACLE, SQL,
    and MOTIF.  I simply did not have a clear picture of how the user could best
    interact with the database.
    

Maintenance Table Definitions

   EXEC SQL CREATE TABLE DCC.SEED_CHANNEL (
        NETWORK VARCHAR2(2)
          CONSTRAINT NN_SCN_NETWORK NOT NULL,
        STATION VARCHAR2(5)
          CONSTRAINT NN_SCN_STATION NOT NULL,
        LOCATION VARCHAR2(2)
          CONSTRAINT NN_SCN_LOCATION NOT NULL
          CONSTRAINT CK_SCN_LOCATION CHECK( LOCATION = UPPER(LOCATION)),
        CHANNEL VARCHAR2(3)
          CONSTRAINT NN_SCN_CHANNEL NOT NULL
          CONSTRAINT CK_SCN_CHANNEL CHECK( CHANNEL = UPPER(CHANNEL)), 
        BEGINNING DATE
          CONSTRAINT NN_SCN_BEGINNING NOT NULL,
        ENDING DATE,
        MODIFIED DATE,
        INSTRUMENT VARCHAR2(20)
          CONSTRAINT NN_SCN_INSTRUMENT NOT NULL
          CONSTRAINT FK_SCN_INSTRUMENT
             REFERENCES DCC.SEED_ABBREVIATION(ID),
        CHAN_COMMENT VARCHAR2(31),
        SIGNAL_RESPONSE VARCHAR2(20)
          CONSTRAINT NN_SCN_RESPONSE NOT NULL
          CONSTRAINT FK_SCN_RESPONSE REFERENCES DCC.SEED_UNIT(ID),
        LATITUDE NUMBER(7,5)
          CONSTRAINT CK_SCN_LATITUDE CHECK(LATITUDE BETWEEN -90 AND 90),
        LAT_PREC NUMBER(1)
          CONSTRAINT CK_SCN_LAT_PREC CHECK( LAT_PREC BETWEEN 0 AND 9 ),
        LONGITUDE NUMBER(8,5)
          CONSTRAINT CK_SCN_LONGITUDE
               CHECK( LONGITUDE BETWEEN -180 AND 180 ),
        LONG_PREC NUMBER(1)
          CONSTRAINT CK_SCN_LONG_PREC CHECK( LONG_PREC BETWEEN 0 AND 9),
        COORD_SET NUMBER(1)
          CONSTRAINT CK_SCN_COORD_SET CHECK( COORD_SET BETWEEN 0 AND 4),
        COORD_TYPE VARCHAR2(20)
          CONSTRAINT FK_SCN_COORD_TYPE
             REFERENCES DCC.SEED_ABBREVIATION(ID),
        COORD_MAP VARCHAR2(100),
        ELEVATION NUMBER(5,1),
        ELEV_PREC NUMBER(1)
          CONSTRAINT CK_SCN_ELEV_PREC CHECK(ELEV_PREC BETWEEN -3 AND 9),
        ELEV_TYPE VARCHAR2(20)
          CONSTRAINT FK_SCN_ELEV_TYPE
             REFERENCES DCC.SEED_ABBREVIATION(ID),
        ELEV_MAP VARCHAR2(100),
        LOCAL_DEPTH NUMBER(4,1)
          CONSTRAINT NN_SCN_LOCAL_DEPTH NOT NULL,
        AZIMUTH NUMBER(4,1)
          CONSTRAINT NN_SCN_AZIMUTH NOT NULL
          CONSTRAINT CK_SCN_AZIMUTH CHECK( AZIMUTH BETWEEN 0 AND 360 ),
        DIP NUMBER(3,1) 
          CONSTRAINT NN_SCN_DIP NOT NULL
          CONSTRAINT CK_SCN_DIP CHECK( DIP BETWEEN -90 AND 90 ),
        SEED_FORMAT VARCHAR2(20)
          CONSTRAINT NN_SCN_SEED_FORMAT NOT NULL
          CONSTRAINT FK_SCN_SEED_FORMAT REFERENCES DCC.SEED_FORMAT(ID),
        EXPONENT NUMBER(2)
          CONSTRAINT NN_SCN_EXPONENT NOT NULL
          CONSTRAINT CK_SCN_EXPONENT CHECK( EXPONENT BETWEEN 8 AND 12 ),
        SAMPLE_RATE FLOAT
          CONSTRAINT NN_SCN_SAMPLE_RATE NOT NULL,
        CLOCK_DRIFT  FLOAT
          CONSTRAINT NN_SCN_CLOCK_DRIFT NOT NULL,
        CLOCK_TYPE VARCHAR2(20)
          CONSTRAINT FK_SCN_CLOCK_TYPE
               REFERENCES DCC.SEED_ABBREVIATION(ID),
        FLAGS VARCHAR2(27)
          CONSTRAINT CK_SCN_FLAGS CHECK( FLAGS = UPPER(FLAGS)), 
        DERIVED_LOCATION VARCHAR2(2),
        DERIVED_CHANNEL VARCHAR2(5),
        CALIBRATION_INPUT VARCHAR2(20)
          CONSTRAINT FK_SCN_CALIBRATION_INPUT
                    REFERENCES DCC.SEED_UNIT(ID),
        CALIBRATION_LOCATION VARCHAR2(2),
        CALIBRATION_CHANNEL VARCHAR2(5),
        DIGITIZER_TYPE VARCHAR2(20)
          CONSTRAINT FK_SCN_DIGITIZER_TYPE
                    REFERENCES DCC.SEED_ABBREVIATION(ID),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SCN_DESC_TYPE NOT NULL
          CONSTRAINT CK_SCN_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
        CONSTRAINT PK_SCN_PRIMARY_KEY
          PRIMARY KEY ( NETWORK, STATION, LOCATION, CHANNEL, BEGINNING),
        CONSTRAINT FK_SCN_NET_STAT_CHAN
               FOREIGN KEY ( NETWORK, STATION, LOCATION, CHANNEL )
               REFERENCES DCC.NET_STAT_CHAN( NETWORK, STATION, LOCATION, CHANNEL ),
        CONSTRAINT FK_SCN_DERIVED_KEY
               FOREIGN KEY ( NETWORK, STATION, DERIVED_LOCATION,
                              DERIVED_CHANNEL, BEGINNING )
               REFERENCES DCC.SEED_CHANNEL( NETWORK, STATION, LOCATION,
                                            CHANNEL, BEGINNING ),
        CONSTRAINT FK_SCN_CAL_KEY
               FOREIGN KEY ( NETWORK, STATION, CALIBRATION_LOCATION,
                             CALIBRATION_CHANNEL, BEGINNING )
               REFERENCES DCC.SEED_CHANNEL( NETWORK, STATION, LOCATION,
                                            CHANNEL, BEGINNING )

   )   TABLESPACE maint_1;

   EXEC SQL CREATE TABLE DCC.SEED_COEFFICIENT (
        NETWORK VARCHAR2(2)
          CONSTRAINT NN_SDC_NETWORK NOT NULL,
	STATION VARCHAR2(5)
          CONSTRAINT NN_SDC_STATION NOT NULL,
	CHANNEL VARCHAR2(3)
          CONSTRAINT NN_SDC_CHANNEL NOT NULL,
        LOCATION VARCHAR2(2),
	BEGINNING DATE
          CONSTRAINT NN_SDC_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
	STAGE_SEQ NUMBER(2)
          CONSTRAINT NN_SDC_STAGE_SEQ NOT NULL,
	DC_KEY VARCHAR2(40)
          CONSTRAINT NN_SDC_DC_KEY NOT NULL
          CONSTRAINT FK_SDC_DC_KEY REFERENCES DCC.SEED_DC(KEY),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SDC_DESC_TYPE NOT NULL
          CONSTRAINT CK_SDC_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
	CONSTRAINT PK_SDC_PRIMARY_KEY
          PRIMARY KEY ( NETWORK, STATION, CHANNEL, LOCATION, BEGINNING,
                        STAGE_SEQ )
   ) TABLESPACE MAINT_1;

   EXEC SQL CREATE TABLE DCC.SEED_STATION_COMMENT (
        NETWORK VARCHAR2(2)
           CONSTRAINT NN_SSC_NETWORK NOT NULL,
	STATION VARCHAR2(5)
           CONSTRAINT NN_SSC_STATION NOT NULL,
	BEGINNING DATE
           CONSTRAINT NN_SSC_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
        COMMENT_ID NUMBER
           CONSTRAINT NN_SSC_COMMENT_ID NOT NULL
           CONSTRAINT FK_SSC_COMMENT_ID
	     REFERENCES DCC.SEED_COMMENT_DEFINITION(ID),
	VALUE VARCHAR2(20),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SSC_DESC_TYPE NOT NULL
          CONSTRAINT CK_SSC_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
        CONSTRAINT PK_SSC_COMMENT_ID
	       PRIMARY KEY ( NETWORK, STATION, BEGINNING, COMMENT_ID )
   ) TABLESPACE MAINT_1;

   EXEC SQL CREATE TABLE DCC.SEED_CHANNEL_COMMENT (
        NETWORK VARCHAR2(2)
           CONSTRAINT NN_SCC_NETWORK NOT NULL,
	STATION VARCHAR2(5)
           CONSTRAINT NN_SCC_STATION NOT NULL,
        LOCATION VARCHAR2(2)
           CONSTRAINT NN_SCC_LOCATION NOT NULL,
	CHANNEL VARCHAR2(3)
           CONSTRAINT NN_SCC_CHANNEL NOT NULL,
	BEGINNING DATE
           CONSTRAINT NN_SCC_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
        COMMENT_ID NUMBER
           CONSTRAINT NN_SCC_COMMENT_ID NOT NULL
           CONSTRAINT FK_SCC_COMMENT_ID
	     REFERENCES DCC.SEED_COMMENT_DEFINITION(ID),
	VALUE VARCHAR2(20),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SCC_DESC_TYPE NOT NULL
          CONSTRAINT CK_SCC_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
        CONSTRAINT PK_SCC_COMMENT_ID
	   PRIMARY KEY ( NETWORK, STATION, LOCATION, CHANNEL,
                         BEGINNING, COMMENT_ID )
   ) TABLESPACE MAINT_1;

   EXEC SQL CREATE TABLE DCC.SEED_DECIMATION (
        NETWORK VARCHAR2(2)
          CONSTRAINT NN_SDM_NETWORK NOT NULL,
	STATION VARCHAR2(5)
          CONSTRAINT NN_SDM_STATION NOT NULL,
	CHANNEL VARCHAR2(3)
          CONSTRAINT NN_SDM_CHANNEL NOT NULL,
        LOCATION VARCHAR2(2),
	BEGINNING DATE
          CONSTRAINT NN_SDM_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
	STAGE_SEQ NUMBER(2)
          CONSTRAINT NN_SDM_STAGE_SEQ NOT NULL,
	DM_KEY VARCHAR2(40)
          CONSTRAINT NN_SDM_DM_KEY NOT NULL
          CONSTRAINT FK_SDM_DM_KEY REFERENCES DCC.SEED_DM(KEY),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SDM_DESC_TYPE NOT NULL
          CONSTRAINT CK_SDM_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
	CONSTRAINT PK_SDM_PRIMARY_KEY
          PRIMARY KEY ( NETWORK, STATION, CHANNEL, LOCATION,
                        BEGINNING, STAGE_SEQ )
   ) TABLESPACE maint_1;

   EXEC SQL CREATE TABLE DCC.SEED_POLE_ZERO (
	NETWORK VARCHAR2(2)
          CONSTRAINT NN_SPZ_NETWORK NOT NULL,
        STATION VARCHAR2(5)
          CONSTRAINT NN_SPZ_STATION NOT NULL,
	CHANNEL VARCHAR2(3)
          CONSTRAINT NN_SPZ_CHANNEL NOT NULL,
        LOCATION VARCHAR2(2),
	BEGINNING DATE
          CONSTRAINT NN_SPZ_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
	STAGE_SEQ NUMBER(2)
          CONSTRAINT NN_SPZ_STAGE_SEQ NOT NULL,
	PZ_KEY VARCHAR2(40)
          CONSTRAINT NN_SPZ_PZ_KEY NOT NULL
          CONSTRAINT FK_SPZ_PZ_KEY REFERENCES DCC.SEED_PZ(KEY),
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SPZ_DESC_TYPE NOT NULL
          CONSTRAINT CK_SPZ_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
	CONSTRAINT PK_SPZ_PRIMARY_KEY
          PRIMARY KEY ( NETWORK, STATION, CHANNEL, LOCATION,
                        BEGINNING, STAGE_SEQ )
   ) TABLESPACE maint_1;

   EXEC SQL CREATE TABLE DCC.SEED_SENSITIVITY (
        NETWORK VARCHAR2(2)
          CONSTRAINT NN_SSN_NETWORK NOT NULL,
	STATION VARCHAR2(5)
          CONSTRAINT NN_SSN_STATION NOT NULL,
        LOCATION VARCHAR2(2)
          CONSTRAINT NN_SSN_LOCATION NOT NULL,
	CHANNEL VARCHAR2(3)
          CONSTRAINT NN_SSN_CHANNEL NOT NULL,
	BEGINNING DATE
          CONSTRAINT NN_SSN_BEGINNING NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
	STAGE_SEQ NUMBER(2)
          CONSTRAINT NN_SSN_STAGE_SEQ NOT NULL,
	SENSITIVITY FLOAT
          CONSTRAINT NN_SSN_SENSITIVITY NOT NULL,
	FREQUENCY FLOAT
          CONSTRAINT NN_SSN_NUMBER NOT NULL,
        DESC_TYPE CHAR(4)
          CONSTRAINT NN_SSN_DESC_TYPE NOT NULL
          CONSTRAINT CK_SSN_DESC_TYPE CHECK ( DESC_TYPE IN ('TEXT') ),
        DESCRIPTION LONG,
        CONSTRAINT PK_SSN_PRIMARY_KEY
          PRIMARY KEY ( NETWORK, STATION, LOCATION,
                        CHANNEL, BEGINNING, STAGE_SEQ )
   ) TABLESPACE maint_1;

   EXEC SQL CREATE TABLE DCC.SEED_STATION (
        NETWORK VARCHAR2(2) CONSTRAINT nn_SST_Network NOT NULL 
                            CONSTRAINT fk_SST_Network REFERENCES
                                                 DCC.NETWORKS(NETWORK),
	STATION VARCHAR2(5) CONSTRAINT nn_SST_Station NOT NULL
                            CONSTRAINT ck_SST_Station
                                       CHECK( STATION = UPPER(STATION)),
	BEGINNING DATE CONSTRAINT nn_SST_Beginning NOT NULL,
	ENDING DATE,
	MODIFIED DATE,
	LATITUDE NUMBER(7,5)  CONSTRAINT nn_SST_Latitude NOT NULL
	                      CONSTRAINT ck_SST_Latitude
                                 CHECK ( LATITUDE BETWEEN -90 AND 90 ),
        LAT_PREC NUMBER(1)
          CONSTRAINT ck_SST_Lat_Prec CHECK( LAT_PREC BETWEEN 0 AND 9 ),
	LONGITUDE NUMBER(8,5) CONSTRAINT nn_SST_Longitude NOT NULL
           CONSTRAINT ck_SST_Longitude
               CHECK ( LONGITUDE BETWEEN -180 AND 180 ),
        LONG_PREC NUMBER(1)
           CONSTRAINT ck_SST_Long_Prec
               CHECK( LONG_PREC BETWEEN 0 AND 9 ),
        COORD_TYPE VARCHAR2(20)
           CONSTRAINT fk_SST_Coord_Type
             REFERENCES DCC.SEED_ABBREVIATION(ID),
        COORD_MAP VARCHAR2(100),
	ELEVATION NUMBER(5,1) CONSTRAINT nn_SST_Elevation NOT NULL,
        ELEV_PREC NUMBER(1)
            CONSTRAINT ck_SST_Elev_Prec
                CHECK( ELEV_PREC BETWEEN -3 AND 9 ),
        ELEV_TYPE VARCHAR2(20)
            CONSTRAINT fk_SST_Elev_Type
                REFERENCES DCC.SEED_ABBREVIATION(ID),
        ELEV_MAP VARCHAR2(100),
	NET_ID VARCHAR2(20) CONSTRAINT nn_SST_Net_Id NOT NULL
              CONSTRAINT fk_SST_Net_Id
                  REFERENCES DCC.SEED_ABBREVIATION(ID),
	STAGE_FORMAT VARCHAR2(6)
                     CONSTRAINT nn_SST_Stage_Format NOT NULL
                     CONSTRAINT fk_SST_Stage_Format
                         REFERENCES DCC.SEED_FORMAT(FORMAT),
	SITE_NAME VARCHAR2(61),
	SUCCESSOR_NET VARCHAR2(2),
	SUCCESSOR_STATION VARCHAR2(5),
	WORD_ORD_32 NUMBER(4),
	WORD_ORD_16 NUMBER(2),
	CLOCK_TYPE VARCHAR2(11)
           CONSTRAINT fk_SST_Clock_Type
               REFERENCES DCC.SEED_ABBREVIATION(ID),
	STATION_TYPE VARCHAR2(20)
           CONSTRAINT fk_SST_Station_Type
               REFERENCES DCC.SEED_ABBREVIATION(ID),
        SOFTWARE_REVS VARCHAR2(2000),
        VAULT_COND VARCHAR2(2000),
        DESC_TYPE CHAR(4) CONSTRAINT nn_SST_DescType NOT NULL
             CONSTRAINT ck_SST_DescType CHECK (DESC_TYPE IN ('TEXT')),
        DESCRIPTION LONG,
        CONSTRAINT pk_SST_Primary_Key
            PRIMARY KEY ( NETWORK, STATION, BEGINNING),
        CONSTRAINT fk_SST_Network_Station
            FOREIGN KEY ( NETWORK, STATION )
              REFERENCES DCC.NETWORK_STATION( NETWORK, STATION ),
        CONSTRAINT fk_SST_Sucessor
            FOREIGN KEY ( SUCCESSOR_NET, SUCCESSOR_STATION, BEGINNING )
              REFERENCES DCC.SEED_STATION( NETWORK, STATION, BEGINNING )
   ) TABLESPACE maint_1;


/* ASL DCC SEED Database Responses files - responses.sql */

drop table dcc.Seed_PZ_Data;
drop table dcc.Seed_PZ;
drop table dcc.Seed_DC_Data;
drop table dcc.Seed_DC;
drop table dcc.Seed_DM;

/* dcc.Seed_PZ - Poles and Zeros Headers */

Create Table	dcc.Seed_PZ
(
	Key		varchar2(40)	/* PZ key */
				not null
				primary key
				check (Key = upper(Key)),
	Title		varchar2(255)	/* General name of function */
				not null,
	Type		char(1)		/* Pole-Zero Type */
				not null
				check (Type in ('A','B','D')),
	In_Unit		varchar2(20)
				not null
				references dcc.Seed_Unit(Id),
	Out_Unit	varchar2(20)
				not null
				references dcc.Seed_Unit(Id),
	PctErr		number(4,3),	/* Percent error in Zeros and Poles */
	A0		float,		/* Normalization value */
	AF		float,		/* Normalization Frequency */
	DescType	char(4)		/* Type of data in description field */
				not null
				check (DescType in ('TEXT')),
	Description	long		/* Description record for data */
)	
	tablespace maint_1
;

Create Table	dcc.Seed_PZ_Data
(
	Key		varchar2(40)
				not null
				references dcc.Seed_PZ(Key),
	RowKey		char(4)		/* Pxxx or Zxxx */
				not null
				check (RowKey = upper(RowKey)),
	R_Value		float,		/* Real value */
	R_Error		float,		/* Real error */
	I_Value		float,		/* Imaginary value */
	I_Error		float,		/* Imaginary error */
	RowCom		varchar2(200),	/* Comment foreach value */
	primary key (Key, RowKey)
)	
	tablespace maint_1
;

/* dcc.Seed_DC - Digital Coefficients Files */

Create Table	dcc.Seed_DC
(
	Key		varchar2(40)	/* DC key */
				not null,
	Title		varchar2(255)	/* General name of function */
				not null,
	Type		char(1)		/* Coefficient Type (Usually D) */ 
				not null
				check (Type in ('A','B','D')),
	In_Unit		varchar2(20)
				not null
				references dcc.Seed_Unit(Id),
	Out_Unit	varchar2(20)
				not null
				references dcc.Seed_Unit(Id),
	PctErr		number(4,3),	/* Percent error of Coefficients */
	DescType	char(4)		/* Type of data in description field */
				not null,
	Description	long,		/* Description record for data */
	primary key(Key),
	check (Key = upper(Key)),
	check (DescType in ('TEXT'))
)	
	tablespace maint_1
;

Create Table	dcc.Seed_DC_Data
(
	Key		varchar2(40)
				not null
				references dcc.Seed_DC(Key),
	RowKey		char(4)		/* Nxxx or Dxxx */
				not null
				check (RowKey = upper(RowKey)),
	Value		float,
	ErrVal		float,
	RowCom		varchar2(200),	/* Comment foreach value */
	primary key (Key, RowKey)
)
	tablespace maint_1
;

/* dcc.Seed_DM - Digital Decimation Info */

Create Table	dcc.Seed_DM
(
	Key		varchar2(40)	/* DM key */
				not null
				primary key
				check (Key = upper(Key)),
	Title		varchar2(255)	/* General name of function */
				not null,
	Rate		float,		/* Input sample rate */
					/* Output rate = Rate*Factor */
	Factor		number(8),	/* Decimation factor In/Out */
	Offset		number(8),	/* Which sample to keep */
	Delay		float,		/* Estimated delay (in secs) */
	Correction	float,		/* Corrected delay (in secs) */
	DescType	char(4)		/* Type of data in description field */
				not null
				check (DescType in ('TEXT')),
	Description	long		/* Description record for data */
)	
	tablespace maint_1
;





The following sql commands were implemented to create the dictionary
tables for the netbase tables.

The Abbreviation Dictionary:

Create Table dcc.SEED_Abbreviation (
	ID		char(20) NOT NULL CHECK ( ID = UPPER( ID ) ),
	DESCRIPTION	CHAR(50),
	PRIMARY KEY 	(ID) )

The Unit Dictionary:

Create Table dcc.SEED_Unit (
	ID		char(20) NOT NULL CHECK ( ID = UPPER( ID ) ),
	DESCRIPTION	CHAR(50),
	PRIMARY KEY	(ID) )

The Comment Definition Dictionary:

Create Table dcc.SEED_Comment_Definition (
	ID 		number NOT NULL,
	TYPE		char(1) NOT NULL,
	TEXT		char(70) NOT NULL,
	UNIT		char(20),
	PRIMARY KEY	(ID),
	FOREIGN KEY	(UNIT) REFERENCES UNIT(ID) )

The Format Dictionary:

Create Table dcc.SEED_Format (
	ID char(20) NOT NULL, CHECK ( ID = UPPER (ID) ),
	FAMILY		number NOT NULL,
	NAME		char(50) NOT NULL,
	NUMBER_KEYS	number NOT NULL,
	KEY_1		char(80),
	KEY_2		char(80),
	KEY_3		char(80),
	KEY_4		char(80),
	KEY_5		char(80),
	KEY_6		char(80),
	KEY_7		char(80),
	KEY_8		char(80),
	KEY_9		char(80),
	KEY_10		char(80),
	PRIMARY KEY	(ID) );

    
    
    Let me know what else I can send you or help you with.
    
    Rene'

