Physical Design Dictionary

 NCEDC/TriNet Hardware Tracking
Version 1.5.2

Berkeley Seismological Laboratory
Stephane Zuzlewski
Last Modified 11/20/2002
Copyright 2002 NCEDC/TriNet

NCEDC/TriNet Hardware Tracking

Diagram Name	NCEDC/TriNet Hardware Tracking	
Description	NCEDC/TriNet Hardware Tracking Schema ER Diagram	
Author	Stephane Zuzlewski	
Company	Berkeley Seismological Laboratory	
Version	1.5.2	
Copyright	NCEDC/TriNet	
Copyright Year	2002	

NCEDC

Model Name	NCEDC	
Database Platform	Oracle 9i	

Table Summary Report

Table Name	Table Type	Primary Keys	# Col	
Datalogger	Independent	data_id	12	
Datalogger_Board	Dependent	data_id,board_nb	6	
Datalogger_Module	Dependent	data_id,board_nb,module_nb	7	
Filamp	Independent	filamp_id	7	
Filamp_PChannel	Dependent	filamp_id,pchannel_nb	6	
Filter	Independent	filter_id	10	
Filter_FIR	Independent	fir_id	5	
Filter_FIR_Data	Dependent	fir_id,coeff_nb	5	
Filter_Sequence	Independent	seqfil_id	6	
Filter_Sequence_Data	Dependent	seqfil_id,filter_nb	3	
Response	Independent	seqresp_id,resp_nb	8	
Response_HP	Independent	hp_id	6	
Response_LP	Independent	lp_id	6	
Response_PN	Independent	pn_id	8	
Response_PN_Data	Dependent	pn_id,pn_nb	3	
Response_PZ	Independent	pz_id,pz_nb	8	
Sensor	Independent	sensor_id	7	
Sensor_Component	Dependent	sensor_id,component_nb	8	
Station	Independent	sta,net,ondate	15	
Station_Datalogger	Dependent	sta,net,data_nb,ondate	8	
Station_Datalogger_LChannel	Dependent	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	24	
Station_Datalogger_PChannel	Dependent	sta,net,data_nb,pchannel_nb,ondate	11	
Station_Digitizer	Dependent	sta,net,digi_nb,ondate	9	
Station_Digitizer_PChannel	Dependent	sta,net,digi_nb,pchannel_nb,ondate	12	
Station_Filamp	Dependent	sta,net,filamp_nb,ondate	8	
Station_Filamp_PChannel	Dependent	sta,net,filamp_nb,pchannel_nb,ondate	10	
Station_Sensor	Dependent	sta,net,sensor_nb,ondate	14	
Station_Sensor_Component	Dependent	stanetsensor_nbcomponent_nbondate	12	

Table Detail Reports

Datalogger

Table Name	Datalogger	
Owner Name		
Primary Keys	data_id	
Definition	Summary information on a datalogger	
Columns 

Column Name	Domain	Datatype	Null	Definition	
data_id		NUMBER(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
data_type		VARCHAR2(80)	Y	This attribute represents a datalogger type	 
serial_nb		VARCHAR2(80)	Y	This attribute denotes a serial number of a datalogger	 
firmware_nb		VARCHAR2(80)	Y	This attribute describes the firmware number of a datalogger	 
software		VARCHAR2(80)	Y	Datalogger’s software (mshear, ushear, ...)	 
software_nb		VARCHAR2(80)	Y	Datalogger’s software version number	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_board		NUMBER(8, 0)	Y	This attribute denotes the number of boards of a datalogger	 
word_32		NUMBER(8, 0)	N	The swap order in which 32-bit quantities are specified in the data headers	 
word_16		NUMBER(8, 0)	N	16-bit quantity byte swapping order, for the data headers only	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Da01	nb_board >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Datalogger	Datalogger_Board	Identifying	Dat_Boa_Dat	 
Datalogger	Station_Datalogger	Non-Identifying	Sta_Dat_Dat	 
DDL Code 

CREATE TABLE Datalogger(
    data_id        NUMBER(8, 0)    NOT NULL,
    data_type      VARCHAR2(80),
    serial_nb      VARCHAR2(80),
    firmware_nb    VARCHAR2(80),
    software       VARCHAR2(80),
    software_nb    VARCHAR2(80),
    ondate         DATE            NOT NULL,
    offdate        DATE,
    nb_board       NUMBER(8, 0),
    word_32        NUMBER(8, 0)    NOT NULL,
    word_16        NUMBER(8, 0)    NOT NULL,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT Da01 CHECK (nb_board >= 0),
    CONSTRAINT Da00 PRIMARY KEY (data_id)
) 
TABLESPACE HT_DATA
;

	

data_id

Column Name	data_id	Table Name	Datalogger	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

data_type

Column Name	data_type	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents a datalogger type	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

serial_nb

Column Name	serial_nb	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a datalogger	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

firmware_nb

Column Name	firmware_nb	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute describes the firmware number of a datalogger	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

software

Column Name	software	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datalogger’s software (mshear, ushear, ...)	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

software_nb

Column Name	software_nb	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datalogger’s software version number	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

ondate

Column Name	ondate	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

nb_board

Column Name	nb_board	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of boards of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

word_32

Column Name	word_32	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The swap order in which 32-bit quantities are specified in the data headers	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

word_16

Column Name	word_16	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

16-bit quantity byte swapping order, for the data headers only	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Datalogger_Board

Table Name	Datalogger_Board	
Owner Name		
Primary Keys	data_id,board_nb	
Definition	Board of a datalogger	
Columns 

Column Name	Domain	Datatype	Null	Definition	
data_id		NUMBER(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
board_nb		NUMBER(8, 0)	N	This attribute denotes the number of boards of a datalogger	 
serial_nb		VARCHAR2(80)	Y	This attribute denotes a serial number of a datalogger board	 
nb_module		NUMBER(8, 0)	N	This attribute denotes the number of modules of a datalogger’s board	 
firmware_nb		VARCHAR2(80)	Y	This attribute describes the firmware number of a datalogger	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DaB01	board_nb >= 1	 
	Check	DaB02	nb_module >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Datalogger	Datalogger_Board	Identifying	Dat_Boa_Dat	 
Datalogger_Board	Datalogger_Module	Identifying	Dat_Mod_Dat_Boa	 
DDL Code 

CREATE TABLE Datalogger_Board(
    data_id        NUMBER(8, 0)    NOT NULL,
    board_nb       NUMBER(8, 0)    NOT NULL,
    serial_nb      VARCHAR2(80),
    nb_module      NUMBER(8, 0)    NOT NULL,
    firmware_nb    VARCHAR2(80),
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT DaB01 CHECK (board_nb >= 1),
    CONSTRAINT DaB02 CHECK (nb_module >= 0),
    CONSTRAINT DaB00 PRIMARY KEY (data_id, board_nb), 
    CONSTRAINT Dat_Boa_Dat FOREIGN KEY (data_id)
    REFERENCES Datalogger(data_id)
) 
TABLESPACE HT_DATA
;

	

data_id

Column Name	data_id	Table Name	Datalogger_Board	
Role Name	data_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Datalogger	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

board_nb

Column Name	board_nb	Table Name	Datalogger_Board	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of boards of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

serial_nb

Column Name	serial_nb	Table Name	Datalogger_Board	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a datalogger board	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

nb_module

Column Name	nb_module	Table Name	Datalogger_Board	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of modules of a datalogger’s board	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

firmware_nb

Column Name	firmware_nb	Table Name	Datalogger_Board	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute describes the firmware number of a datalogger	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

lddate

Column Name	lddate	Table Name	Datalogger_Board	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Datalogger_Module

Table Name	Datalogger_Module	
Owner Name		
Primary Keys	data_id,board_nb,module_nb	
Definition	Module of a datalogger’s board	
Columns 

Column Name	Domain	Datatype	Null	Definition	
data_id		NUMBER(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
board_nb		NUMBER(8, 0)	N	This attribute denotes the number of boards of a datalogger	 
module_nb		NUMBER(8, 0)	N	This attribute represents the module number of a datalogger’s board	 
serial_nb		VARCHAR2(80)	Y	This attribute denotes a serial number of a datalogger module	 
firmware_nb		VARCHAR2(80)	Y	This attribute describes the firmware number of a datalogger	 
sensitivity		DOUBLE PRECISION	Y	This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	DaM01	board_nb >= 1	 
	Check	DaM02	module_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Datalogger_Board	Datalogger_Module	Identifying	Dat_Mod_Dat_Boa	 
DDL Code 

CREATE TABLE Datalogger_Module(
    data_id        NUMBER(8, 0)        NOT NULL,
    board_nb       NUMBER(8, 0)        NOT NULL,
    module_nb      NUMBER(8, 0)        NOT NULL,
    serial_nb      VARCHAR2(80),
    firmware_nb    VARCHAR2(80),
    sensitivity    DOUBLE PRECISION,
    lddate         DATE                DEFAULT (SYSDATE),
    CONSTRAINT DaM01 CHECK (board_nb >= 1),
    CONSTRAINT DaM02 CHECK (module_nb >= 1),
    CONSTRAINT DaM00 PRIMARY KEY (data_id, board_nb, module_nb), 
    CONSTRAINT Dat_Mod_Dat_Boa FOREIGN KEY (data_id,board_nb)
    REFERENCES Datalogger_Board(data_id,board_nb)
) 
TABLESPACE HT_DATA
;

	

data_id

Column Name	data_id	Table Name	Datalogger_Module	
Role Name	data_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Datalogger_Board	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

board_nb

Column Name	board_nb	Table Name	Datalogger_Module	
Role Name	board_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Datalogger_Board	
Definition 

This attribute denotes the number of boards of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

module_nb

Column Name	module_nb	Table Name	Datalogger_Module	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the module number of a datalogger’s board	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

serial_nb

Column Name	serial_nb	Table Name	Datalogger_Module	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a datalogger module	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

firmware_nb

Column Name	firmware_nb	Table Name	Datalogger_Module	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute describes the firmware number of a datalogger	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

sensitivity

Column Name	sensitivity	Table Name	Datalogger_Module	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Datalogger_Module	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filamp

Table Name	Filamp	
Owner Name		
Primary Keys	filamp_id	
Definition	Summary information on a filter-amplifier	
Columns 

Column Name	Domain	Datatype	Null	Definition	
filamp_id		NUMBER(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
name		VARCHAR2(80)	Y	This attribute denotes a descriptive name for a filter-amplifier	 
serial_nb		VARCHAR2(80)	Y	This attribute denotes a serial number of a filter-amplifier	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_pchannel		NUMBER(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Filamp01	nb_pchannel >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filamp	Filamp_PChannel	Identifying	Fil_PCh_Fil	 
Filamp	Station_Filamp	Non-Identifying	Sta_Fil_Fil	 
DDL Code 

CREATE TABLE Filamp(
    filamp_id      NUMBER(8, 0)    NOT NULL,
    name           VARCHAR2(80),
    serial_nb      VARCHAR2(80),
    ondate         DATE            NOT NULL,
    offdate        DATE,
    nb_pchannel    NUMBER(8, 0)    NOT NULL,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT Filamp01 CHECK (nb_pchannel >= 0),
    CONSTRAINT Filamp00 PRIMARY KEY (filamp_id)
) 
TABLESPACE HT_DATA
;

	

filamp_id

Column Name	filamp_id	Table Name	Filamp	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

name

Column Name	name	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a descriptive name for a filter-amplifier	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

serial_nb

Column Name	serial_nb	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a filter-amplifier	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

ondate

Column Name	ondate	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

nb_pchannel

Column Name	nb_pchannel	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filamp_PChannel

Table Name	Filamp_PChannel	
Owner Name		
Primary Keys	filamp_id,pchannel_nb	
Definition	Physical channel of a filter-amplifier	
Columns 

Column Name	Domain	Datatype	Null	Definition	
filamp_id		NUMBER(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
pchannel_nb		NUMBER(8, 0)	N	This attribute denotes a physical channel	 
gain		DOUBLE PRECISION	Y	This attribute denotes the gain	 
frequency		DOUBLE PRECISION	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
seqresp_id		NUMBER(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FiP01	pchannel_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filamp	Filamp_PChannel	Identifying	Fil_PCh_Fil	 
DDL Code 

CREATE TABLE Filamp_PChannel(
    filamp_id      NUMBER(8, 0)        NOT NULL,
    pchannel_nb    NUMBER(8, 0)        NOT NULL,
    gain           DOUBLE PRECISION,
    frequency      DOUBLE PRECISION,
    seqresp_id     NUMBER(8, 0),
    lddate         DATE                DEFAULT (SYSDATE),
    CONSTRAINT FiP01 CHECK (pchannel_nb >= 1),
    CONSTRAINT FiP00 PRIMARY KEY (filamp_id, pchannel_nb), 
    CONSTRAINT Fil_PCh_Fil FOREIGN KEY (filamp_id)
    REFERENCES Filamp(filamp_id)
) 
TABLESPACE HT_DATA
;

	

filamp_id

Column Name	filamp_id	Table Name	Filamp_PChannel	
Role Name	filamp_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Filamp	
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pchannel_nb

Column Name	pchannel_nb	Table Name	Filamp_PChannel	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

gain

Column Name	gain	Table Name	Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the gain	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

frequency

Column Name	frequency	Table Name	Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

seqresp_id

Column Name	seqresp_id	Table Name	Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filter

Table Name	Filter	
Owner Name		
Primary Keys	filter_id	
Definition	Summary information on a filter	
Columns 

Column Name	Domain	Datatype	Null	Definition	
filter_id		NUMBER(8, 0)	N	Filter identifier. Each filter is assigned a unique integer which identifies it in a database	 
gain		DOUBLE PRECISION	Y	This attribute denotes the gain	 
frequency		DOUBLE PRECISION	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
in_sp_rate		DOUBLE PRECISION	Y	Sampling rate. This attribute is the input sample rate in samples/second	 
out_sp_rate		DOUBLE PRECISION	Y	Sampling rate. This attribute is the output sample rate in samples/second	 
offset		NUMBER(8, 0)	Y	This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor	 
delay		DOUBLE PRECISION	Y	The estimated pure delay for the filter	 
correction		DOUBLE PRECISION	N	The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done	 
seqresp_id		NUMBER(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Fi01	frequency >= 0.0	 
	Check	Fi02	in_sp_rate > 0.0	 
	Check	Fi03	out_sp_rate > 0.0	 
	Check	Fi04	offset >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter	Filter_Sequence_Data	Non-Identifying	Fil_Seq_Dat_Fil	 
DDL Code 

CREATE TABLE Filter(
    filter_id      NUMBER(8, 0)        NOT NULL,
    gain           DOUBLE PRECISION,
    frequency      DOUBLE PRECISION,
    in_sp_rate     DOUBLE PRECISION,
    out_sp_rate    DOUBLE PRECISION,
    offset         NUMBER(8, 0),
    delay          DOUBLE PRECISION,
    correction     DOUBLE PRECISION    NOT NULL,
    seqresp_id     NUMBER(8, 0),
    lddate         DATE                DEFAULT (SYSDATE),
    CONSTRAINT Fi01 CHECK (frequency >= 0.0),
    CONSTRAINT Fi02 CHECK (in_sp_rate > 0.0),
    CONSTRAINT Fi03 CHECK (out_sp_rate > 0.0),
    CONSTRAINT Fi04 CHECK (offset >= 0),
    CONSTRAINT Fi00 PRIMARY KEY (filter_id)
) 
TABLESPACE HT_DATA
;

	

filter_id

Column Name	filter_id	Table Name	Filter	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Filter identifier. Each filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

gain

Column Name	gain	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the gain	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

frequency

Column Name	frequency	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

in_sp_rate

Column Name	in_sp_rate	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sampling rate. This attribute is the input sample rate in samples/second	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

out_sp_rate

Column Name	out_sp_rate	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sampling rate. This attribute is the output sample rate in samples/second	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

offset

Column Name	offset	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

delay

Column Name	delay	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The estimated pure delay for the filter	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

correction

Column Name	correction	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

seqresp_id

Column Name	seqresp_id	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filter	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filter_FIR

Table Name	Filter_FIR	
Owner Name		
Primary Keys	fir_id	
Definition	Summary information on a FIR filter	
Columns 

Column Name	Domain	Datatype	Null	Definition	
fir_id		NUMBER(8, 0)	N	FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	 
name		VARCHAR2(80)	Y	This attribute denotes a descriptive name for a FIR filter	 
symmetry		VARCHAR2(1)	N	This attribute denotes the eventual symmetry of a response	 
gain		DOUBLE PRECISION	Y	This attribute denotes the gain	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FFIR01	symmetry IN ('E','O','N')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter_FIR	Filter_FIR_Data	Identifying	Fil_FIR_Dat_Fil_FIR	 
Filter_FIR	Response	Non-Identifying	Res_Fil_FIR	 
DDL Code 

CREATE TABLE Filter_FIR(
    fir_id      NUMBER(8, 0)        NOT NULL,
    name        VARCHAR2(80),
    symmetry    VARCHAR2(1)         NOT NULL,
    gain        DOUBLE PRECISION,
    lddate      DATE                DEFAULT (SYSDATE),
    CONSTRAINT FFIR01 CHECK (symmetry IN ('E','O','N')),
    CONSTRAINT FFIR00 PRIMARY KEY (fir_id)
) 
TABLESPACE HT_DATA
;

	

fir_id

Column Name	fir_id	Table Name	Filter_FIR	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

name

Column Name	name	Table Name	Filter_FIR	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a descriptive name for a FIR filter	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

symmetry

Column Name	symmetry	Table Name	Filter_FIR	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the eventual symmetry of a response	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

gain

Column Name	gain	Table Name	Filter_FIR	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the gain	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filter_FIR	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filter_FIR_Data

Table Name	Filter_FIR_Data	
Owner Name		
Primary Keys	fir_id,coeff_nb	
Definition	Coefficients of a FIR filter	
Columns 

Column Name	Domain	Datatype	Null	Definition	
fir_id		NUMBER(8, 0)	N	FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	 
coeff_nb		NUMBER(8, 0)	N	The numerator/denominator number	 
type		VARCHAR2(1)	N	This attribute denotes whether a value is associated with a numerator/denominator	 
coefficient		DOUBLE PRECISION	N	The numerator/denominator coefficient value	 
error		DOUBLE PRECISION	Y	This attributes denotes the numerator/denominator error	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	FFD01	coeff_nb >= 1	 
	Check	FFD02	type IN ('N','D')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter_FIR	Filter_FIR_Data	Identifying	Fil_FIR_Dat_Fil_FIR	 
DDL Code 

CREATE TABLE Filter_FIR_Data(
    fir_id         NUMBER(8, 0)        NOT NULL,
    coeff_nb       NUMBER(8, 0)        NOT NULL,
    type           VARCHAR2(1)         NOT NULL,
    coefficient    DOUBLE PRECISION    NOT NULL,
    error          DOUBLE PRECISION,
    CONSTRAINT FFD01 CHECK (coeff_nb >= 1),
    CONSTRAINT FFD02 CHECK (type IN ('N','D')),
    CONSTRAINT FFD00 PRIMARY KEY (fir_id, coeff_nb), 
    CONSTRAINT Fil_FIR_Dat_Fil_FIR FOREIGN KEY (fir_id)
    REFERENCES Filter_FIR(fir_id)
) 
TABLESPACE HT_DATA
;

	

fir_id

Column Name	fir_id	Table Name	Filter_FIR_Data	
Role Name	fir_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Filter_FIR	
Definition 

FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

coeff_nb

Column Name	coeff_nb	Table Name	Filter_FIR_Data	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

The numerator/denominator number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

type

Column Name	type	Table Name	Filter_FIR_Data	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes whether a value is associated with a numerator/denominator	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

coefficient

Column Name	coefficient	Table Name	Filter_FIR_Data	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The numerator/denominator coefficient value	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

error

Column Name	error	Table Name	Filter_FIR_Data	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attributes denotes the numerator/denominator error	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filter_Sequence

Table Name	Filter_Sequence	
Owner Name		
Primary Keys	seqfil_id	
Definition	Summary information on a sequence of filters	
Columns 

Column Name	Domain	Datatype	Null	Definition	
seqfil_id		NUMBER(8, 0)	N	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
name		VARCHAR2(32)	N	This attribute denotes a descriptive name for a chain of filters	 
nb_filter		NUMBER(8, 0)	N	This attribute denotes the number of filters of a sequence	 
gain		DOUBLE PRECISION	Y	This attribute denotes the gain	 
frequency		DOUBLE PRECISION	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	FiS01	frequency >= 0.0	 
	Check	FiS02	nb_filter >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter_Sequence	Filter_Sequence_Data	Identifying	Fil_Seq_Dat_Fil_Seq	 
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	Sta_Dat_LCh_Fil_Seq	 
DDL Code 

CREATE TABLE Filter_Sequence(
    seqfil_id    NUMBER(8, 0)        NOT NULL,
    name         VARCHAR2(32)        NOT NULL,
    nb_filter    NUMBER(8, 0)        NOT NULL,
    gain         DOUBLE PRECISION,
    frequency    DOUBLE PRECISION,
    lddate       DATE                DEFAULT (SYSDATE),
    CONSTRAINT FiS01 CHECK (frequency >= 0.0),
    CONSTRAINT FiS02 CHECK (nb_filter >= 0),
    CONSTRAINT FiS00 PRIMARY KEY (seqfil_id)
) 
TABLESPACE HT_DATA
;

	

seqfil_id

Column Name	seqfil_id	Table Name	Filter_Sequence	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

name

Column Name	name	Table Name	Filter_Sequence	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a descriptive name for a chain of filters	
Column Properties 

Data Type	VARCHAR2(32)	Width	32	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

nb_filter

Column Name	nb_filter	Table Name	Filter_Sequence	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of filters of a sequence	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

gain

Column Name	gain	Table Name	Filter_Sequence	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the gain	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

frequency

Column Name	frequency	Table Name	Filter_Sequence	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Filter_Sequence	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Filter_Sequence_Data

Table Name	Filter_Sequence_Data	
Owner Name		
Primary Keys	seqfil_id,filter_nb	
Definition	Filter of a sequence	
Columns 

Column Name	Domain	Datatype	Null	Definition	
seqfil_id		NUMBER(8, 0)	N	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
filter_nb		NUMBER(8, 0)	N	This attribute represents the filter number in a sequence	 
filter_id		NUMBER(8, 0)	N	Filter identifier. Each filter is assigned a unique integer which identifies it in a database	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	FiSeD01	filter_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter	Filter_Sequence_Data	Non-Identifying	Fil_Seq_Dat_Fil	 
Filter_Sequence	Filter_Sequence_Data	Identifying	Fil_Seq_Dat_Fil_Seq	 
DDL Code 

CREATE TABLE Filter_Sequence_Data(
    seqfil_id    NUMBER(8, 0)    NOT NULL,
    filter_nb    NUMBER(8, 0)    NOT NULL,
    filter_id    NUMBER(8, 0)    NOT NULL,
    CONSTRAINT FiSeD01 CHECK (filter_nb >= 1),
    CONSTRAINT FiSeD00 PRIMARY KEY (seqfil_id, filter_nb), 
    CONSTRAINT Fil_Seq_Dat_Fil FOREIGN KEY (filter_id)
    REFERENCES Filter(filter_id),
    CONSTRAINT Fil_Seq_Dat_Fil_Seq FOREIGN KEY (seqfil_id)
    REFERENCES Filter_Sequence(seqfil_id)
) 
TABLESPACE HT_DATA
;

	

seqfil_id

Column Name	seqfil_id	Table Name	Filter_Sequence_Data	
Role Name	seqfil_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Filter_Sequence	
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

filter_nb

Column Name	filter_nb	Table Name	Filter_Sequence_Data	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the filter number in a sequence	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

filter_id

Column Name	filter_id	Table Name	Filter_Sequence_Data	
Role Name	filter_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Filter	
Definition 

Filter identifier. Each filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

Response

Table Name	Response	
Owner Name		
Primary Keys	seqresp_id,resp_nb	
Definition	Summary information on a sequence of responses	
Columns 

Column Name	Domain	Datatype	Null	Definition	
seqresp_id		NUMBER(8, 0)	N	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
resp_nb		NUMBER(8, 0)	N	This attribute denotes the response number of a sequence	 
resp_type		VARCHAR2(1)	N	This attribute denotes the response type	 
resp_id		NUMBER(8, 0)	N	Response identifier. Each response is assigned a unique integer which identifies it in a database	 
unit_in		NUMBER(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system	 
unit_out		NUMBER(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts	 
r_type		VARCHAR2(1)	Y	A single character describing the type of response	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Re01	r_type IN ('A','B','C','D','P')	 
	Check	Re02	resp_nb >= 1	 
	Check	Re03	resp_type IN ('H','L','P','Z','F','N')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter_FIR	Response	Non-Identifying	Res_Fil_FIR	 
Response_HP	Response	Non-Identifying	Res_Res_HP	 
Response_LP	Response	Non-Identifying	Res_Res_LP	 
Response_PN	Response	Non-Identifying	Res_Res_PN	 
DDL Code 

CREATE TABLE Response(
    seqresp_id    NUMBER(8, 0)    NOT NULL,
    resp_nb       NUMBER(8, 0)    NOT NULL,
    resp_type     VARCHAR2(1)     NOT NULL,
    resp_id       NUMBER(8, 0)    NOT NULL,
    unit_in       NUMBER(8, 0)    NOT NULL,
    unit_out      NUMBER(8, 0)    NOT NULL,
    r_type        VARCHAR2(1),
    lddate        DATE            DEFAULT (SYSDATE),
    CONSTRAINT Re01 CHECK (r_type IN ('A','B','C','D','P')),
    CONSTRAINT Re02 CHECK (resp_nb >= 1),
    CONSTRAINT Re03 CHECK (resp_type IN ('H','L','P','Z','F','N')),
    CONSTRAINT Re00 PRIMARY KEY (seqresp_id, resp_nb), 
    CONSTRAINT Res_Fil_FIR FOREIGN KEY (resp_id)
    REFERENCES Filter_FIR(fir_id),
    CONSTRAINT Res_Res_HP FOREIGN KEY (resp_id)
    REFERENCES Response_HP(hp_id),
    CONSTRAINT Res_Res_LP FOREIGN KEY (resp_id)
    REFERENCES Response_LP(lp_id),
    CONSTRAINT Res_Res_PN FOREIGN KEY (resp_id)
    REFERENCES Response_PN(pn_id)
) 
TABLESPACE HT_DATA
;

	

seqresp_id

Column Name	seqresp_id	Table Name	Response	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

resp_nb

Column Name	resp_nb	Table Name	Response	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the response number of a sequence	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

resp_type

Column Name	resp_type	Table Name	Response	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the response type	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

resp_id

Column Name	resp_id	Table Name	Response	
Role Name	resp_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Filter_FIR	
Definition 

Response identifier. Each response is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

unit_in

Column Name	unit_in	Table Name	Response	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

unit_out

Column Name	unit_out	Table Name	Response	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

r_type

Column Name	r_type	Table Name	Response	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A single character describing the type of response	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

lddate

Column Name	lddate	Table Name	Response	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Response_HP

Table Name	Response_HP	
Owner Name		
Primary Keys	hp_id	
Definition	Summary information on a high-pass filter	
Columns 

Column Name	Domain	Datatype	Null	Definition	
hp_id		NUMBER(8, 0)	N	High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database	 
filter_type		VARCHAR2(2)	N	This attribute denotes the type of a high-pass filter	 
nb_pole		NUMBER(8, 0)	N	This attribute denotes the number of poles of a high-pass filter	 
corner_freq		DOUBLE PRECISION	N	This attribute represents the corner frequency of a high-pass filter	 
damping_value		DOUBLE PRECISION	N	This attribute represents the fraction of critical damping of a high-pass filter	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RHP01	filter_type IN ('BW','DG','ND')	 
	Check	RHP02	nb_pole > 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Response_HP	Response	Non-Identifying	Res_Res_HP	 
DDL Code 

CREATE TABLE Response_HP(
    hp_id            NUMBER(8, 0)        NOT NULL,
    filter_type      VARCHAR2(2)         NOT NULL,
    nb_pole          NUMBER(8, 0)        NOT NULL,
    corner_freq      DOUBLE PRECISION    NOT NULL,
    damping_value    DOUBLE PRECISION    NOT NULL,
    lddate           DATE                DEFAULT (SYSDATE),
    CONSTRAINT RHP01 CHECK (filter_type IN ('BW','DG','ND')),
    CONSTRAINT RHP02 CHECK (nb_pole > 0),
    CONSTRAINT RHP00 PRIMARY KEY (hp_id)
) 
TABLESPACE HT_DATA
;

	

hp_id

Column Name	hp_id	Table Name	Response_HP	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

filter_type

Column Name	filter_type	Table Name	Response_HP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the type of a high-pass filter	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

nb_pole

Column Name	nb_pole	Table Name	Response_HP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of poles of a high-pass filter	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

corner_freq

Column Name	corner_freq	Table Name	Response_HP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the corner frequency of a high-pass filter	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

damping_value

Column Name	damping_value	Table Name	Response_HP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the fraction of critical damping of a high-pass filter	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Response_HP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Response_LP

Table Name	Response_LP	
Owner Name		
Primary Keys	lp_id	
Definition	Summary information on a low-pass filter	
Columns 

Column Name	Domain	Datatype	Null	Definition	
lp_id		NUMBER(8, 0)	N	Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database	 
filter_type		VARCHAR2(2)	Y	This attribute denotes the type of a low-pass filter	 
nb_pole		NUMBER(8, 0)	Y	This attribute denotes the number of poles of a low-pass filter	 
corner_freq		DOUBLE PRECISION	N	This attribute represents the corner frequency of a low-pass filter	 
damping_value		DOUBLE PRECISION	N	This attribute represents the fraction of critical damping of a low-pass filter	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RLP01	filter_type IN ('BW','DG','ND')	 
	Check	RLP02	nb_pole > 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Response_LP	Response	Non-Identifying	Res_Res_LP	 
DDL Code 

CREATE TABLE Response_LP(
    lp_id            NUMBER(8, 0)        NOT NULL,
    filter_type      VARCHAR2(2),
    nb_pole          NUMBER(8, 0),
    corner_freq      DOUBLE PRECISION    NOT NULL,
    damping_value    DOUBLE PRECISION    NOT NULL,
    lddate           DATE                DEFAULT (SYSDATE),
    CONSTRAINT RLP01 CHECK (filter_type IN ('BW','DG','ND')),
    CONSTRAINT RLP02 CHECK (nb_pole > 0),
    CONSTRAINT RLP00 PRIMARY KEY (lp_id)
) 
TABLESPACE HT_DATA
;

	

lp_id

Column Name	lp_id	Table Name	Response_LP	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

filter_type

Column Name	filter_type	Table Name	Response_LP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the type of a low-pass filter	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

nb_pole

Column Name	nb_pole	Table Name	Response_LP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of poles of a low-pass filter	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

corner_freq

Column Name	corner_freq	Table Name	Response_LP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the corner frequency of a low-pass filter	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

damping_value

Column Name	damping_value	Table Name	Response_LP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the fraction of critical damping of a low-pass filter	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Response_LP	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Response_PN

Table Name	Response_PN	
Owner Name		
Primary Keys	pn_id	
Definition	Summary information on a polynomial	
Columns 

Column Name	Domain	Datatype	Null	Definition	
pn_id		NUMBER(8, 0)	N	Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	 
name		VARCHAR2(80)	Y	This attribute denotes a descriptive name for a polynomial	 
poly_type		VARCHAR2(1)	N	This attribute represents the type of polynomial approximation	 
lower_bound		DOUBLE PRECISION	Y	This attribute denotes the polynomial lower bound	 
upper_bound		DOUBLE PRECISION	Y	This attribute denotes the polynomial upper bound	 
max_error		DOUBLE PRECISION	Y	This attribute represents the maximum error of polynomial approximation	 
nb_coeff		NUMBER(8, 0)	Y	This attribute denotes the number of polynomial coefficients	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RPN01	nb_coeff >= 0	 
	Check	RPN02	poly_type IN ('C','L','M')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Response_PN	Response_PN_Data	Identifying	Res_PN_Dat_Res_PN	 
Response_PN	Response	Non-Identifying	Res_Res_PN	 
DDL Code 

CREATE TABLE Response_PN(
    pn_id          NUMBER(8, 0)        NOT NULL,
    name           VARCHAR2(80),
    poly_type      VARCHAR2(1)         NOT NULL,
    lower_bound    DOUBLE PRECISION,
    upper_bound    DOUBLE PRECISION,
    max_error      DOUBLE PRECISION,
    nb_coeff       NUMBER(8, 0),
    lddate         DATE                DEFAULT (SYSDATE),
    CONSTRAINT RPN01 CHECK (nb_coeff >= 0),
    CONSTRAINT RPN02 CHECK (poly_type IN ('C','L','M')),
    CONSTRAINT RPN00 PRIMARY KEY (pn_id)
) 
TABLESPACE HT_DATA
;

	

pn_id

Column Name	pn_id	Table Name	Response_PN	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

name

Column Name	name	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a descriptive name for a polynomial	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

poly_type

Column Name	poly_type	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the type of polynomial approximation	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

lower_bound

Column Name	lower_bound	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the polynomial lower bound	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

upper_bound

Column Name	upper_bound	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the polynomial upper bound	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

max_error

Column Name	max_error	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the maximum error of polynomial approximation	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

nb_coeff

Column Name	nb_coeff	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of polynomial coefficients	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Response_PN	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Response_PN_Data

Table Name	Response_PN_Data	
Owner Name		
Primary Keys	pn_id,pn_nb	
Definition	Coefficients of a polynomial	
Columns 

Column Name	Domain	Datatype	Null	Definition	
pn_id		NUMBER(8, 0)	N	Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	 
pn_nb		NUMBER(8, 0)	N	This attribute denotes the coefficient number of a polynomial	 
pn_value		DOUBLE PRECISION	N	This attribute denotes the coefficient value of a polynomial	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
	Check	RPND01	pn_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Response_PN	Response_PN_Data	Identifying	Res_PN_Dat_Res_PN	 
DDL Code 

CREATE TABLE Response_PN_Data(
    pn_id       NUMBER(8, 0)        NOT NULL,
    pn_nb       NUMBER(8, 0)        NOT NULL,
    pn_value    DOUBLE PRECISION    NOT NULL,
    CONSTRAINT RPND01 CHECK (pn_nb >= 1),
    CONSTRAINT RPND00 PRIMARY KEY (pn_id, pn_nb), 
    CONSTRAINT Res_PN_Dat_Res_PN FOREIGN KEY (pn_id)
    REFERENCES Response_PN(pn_id)
) 
TABLESPACE HT_DATA
;

	

pn_id

Column Name	pn_id	Table Name	Response_PN_Data	
Role Name	pn_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Response_PN	
Definition 

Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pn_nb

Column Name	pn_nb	Table Name	Response_PN_Data	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the coefficient number of a polynomial	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pn_value

Column Name	pn_value	Table Name	Response_PN_Data	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the coefficient value of a polynomial	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

Response_PZ

Table Name	Response_PZ	
Owner Name		
Primary Keys	pz_id,pz_nb	
Definition	Summary information on poles & zeros	
Columns 

Column Name	Domain	Datatype	Null	Definition	
pz_id		NUMBER(8, 0)	N	Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database	 
pz_nb		NUMBER(8, 0)	N	This attribute denotes the pole/zero number of a response	 
type		VARCHAR2(1)	N	This attribute denotes whether a value is associated with a pole/zero	 
r_value		DOUBLE PRECISION	N	The real portion of a complex pole/zero	 
r_error		DOUBLE PRECISION	Y	The error value for the real portion of a complex pole/zero	 
i_value		DOUBLE PRECISION	N	The imaginary portion of a complex pole/zero	 
i_error		DOUBLE PRECISION	Y	The error value for the imaginary portion of a complex pole/zero	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	RPZ01	pz_nb >= 1	 
	Check	RPZ02	type IN ('P','Z')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
DDL Code 

CREATE TABLE Response_PZ(
    pz_id      NUMBER(8, 0)        NOT NULL,
    pz_nb      NUMBER(8, 0)        NOT NULL,
    type       VARCHAR2(1)         NOT NULL,
    r_value    DOUBLE PRECISION    NOT NULL,
    r_error    DOUBLE PRECISION,
    i_value    DOUBLE PRECISION    NOT NULL,
    i_error    DOUBLE PRECISION,
    lddate     DATE                DEFAULT (SYSDATE),
    CONSTRAINT RPZ01 CHECK (pz_nb >= 1),
    CONSTRAINT RPZ02 CHECK (type IN ('P','Z')),
    CONSTRAINT RPZ00 PRIMARY KEY (pz_id, pz_nb)
) 
TABLESPACE HT_DATA
;

	

pz_id

Column Name	pz_id	Table Name	Response_PZ	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pz_nb

Column Name	pz_nb	Table Name	Response_PZ	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the pole/zero number of a response	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

type

Column Name	type	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes whether a value is associated with a pole/zero	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

r_value

Column Name	r_value	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The real portion of a complex pole/zero	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

r_error

Column Name	r_error	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The error value for the real portion of a complex pole/zero	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

i_value

Column Name	i_value	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The imaginary portion of a complex pole/zero	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

i_error

Column Name	i_error	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The error value for the imaginary portion of a complex pole/zero	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Response_PZ	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Sensor

Table Name	Sensor	
Owner Name		
Primary Keys	sensor_id	
Definition	Summary information on a sensor	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sensor_id		NUMBER(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
name		VARCHAR2(80)	Y	This attribute denotes a descriptive name for a sensor	 
serial_nb		VARCHAR2(80)	Y	This attribute denotes a serial number of a sensor	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
nb_component		NUMBER(8, 0)	N	This attribute denotes the number of components of a sensor	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	Sensor01	nb_component >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Sensor	Sensor_Component	Identifying	Sen_Com_Sen	 
Sensor	Station_Sensor	Non-Identifying	Sta_Sen_Sen	 
DDL Code 

CREATE TABLE Sensor(
    sensor_id       NUMBER(8, 0)    NOT NULL,
    name            VARCHAR2(80),
    serial_nb       VARCHAR2(80),
    ondate          DATE            NOT NULL,
    offdate         DATE,
    nb_component    NUMBER(8, 0)    NOT NULL,
    lddate          DATE            DEFAULT (SYSDATE),
    CONSTRAINT Sensor01 CHECK (nb_component >= 0),
    CONSTRAINT Sensor00 PRIMARY KEY (sensor_id)
) 
TABLESPACE HT_DATA
;

	

sensor_id

Column Name	sensor_id	Table Name	Sensor	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

name

Column Name	name	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a descriptive name for a sensor	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

serial_nb

Column Name	serial_nb	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a sensor	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

ondate

Column Name	ondate	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

nb_component

Column Name	nb_component	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of components of a sensor	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Sensor_Component

Table Name	Sensor_Component	
Owner Name		
Primary Keys	sensor_id,component_nb	
Definition	Component of a sensor	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sensor_id		NUMBER(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
component_nb		NUMBER(8, 0)	N	This attribute represents the component number	 
channel_comp		VARCHAR2(2)	Y	Component channel	 
component_type		VARCHAR2(1)	Y	This attribute denotes the component type	 
sensitivity		DOUBLE PRECISION	N	This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	 
frequency		DOUBLE PRECISION	Y	The frequency (fs) at which the value in sensitivity/gain is correct	 
seqresp_id		NUMBER(8, 0)	Y	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION	Heap	
CACHE	NO	
LOGGING	Logged	
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS	FreeLists	
FREELIST GROUPS	FreeList Groups	
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	SeC01	component_nb >= 1	 
	Check	SeC02	frequency >= 0.0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Sensor	Sensor_Component	Identifying	Sen_Com_Sen	 
DDL Code 

CREATE TABLE Sensor_Component(
    sensor_id         NUMBER(8, 0)        NOT NULL,
    component_nb      NUMBER(8, 0)        NOT NULL,
    channel_comp      VARCHAR2(2),
    component_type    VARCHAR2(1),
    sensitivity       DOUBLE PRECISION    NOT NULL,
    frequency         DOUBLE PRECISION,
    seqresp_id        NUMBER(8, 0),
    lddate            DATE                DEFAULT (SYSDATE),
    CONSTRAINT SeC01 CHECK (component_nb >= 1),
    CONSTRAINT SeC02 CHECK (frequency >= 0.0),
    CONSTRAINT SeC00 PRIMARY KEY (sensor_id, component_nb), 
    CONSTRAINT Sen_Com_Sen FOREIGN KEY (sensor_id)
    REFERENCES Sensor(sensor_id)
) 
TABLESPACE HT_DATA
;

	

sensor_id

Column Name	sensor_id	Table Name	Sensor_Component	
Role Name	sensor_id	
Primary Key	YES	
Foreign Key	YES	Parent Table	Sensor	
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

component_nb

Column Name	component_nb	Table Name	Sensor_Component	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the component number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

channel_comp

Column Name	channel_comp	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Component channel	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

component_type

Column Name	component_type	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the component type	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

sensitivity

Column Name	sensitivity	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the sensitivity (Sd) for a sensor or a digitizer	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

frequency

Column Name	frequency	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The frequency (fs) at which the value in sensitivity/gain is correct	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

seqresp_id

Column Name	seqresp_id	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station

Table Name	Station	
Owner Name		
Primary Keys	sta,net,ondate	
Definition	Summary information on a station	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
lat		DOUBLE PRECISION	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		DOUBLE PRECISION	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		DOUBLE PRECISION	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
staname		VARCHAR2(50)	Y	Station name/description. This is the full name of the station whose code-name is in sta	 
nb_sensor		NUMBER(8, 0)	Y	This attribute denotes the number of sensors of a station	 
nb_filamp		NUMBER(8, 0)	Y	This attribute denotes the number of filter-amplifiers of a station	 
nb_digi		NUMBER(8, 0)	N	This attribute denotes the number of digitizers of a station	 
nb_data		NUMBER(8, 0)	N	This attribute denotes the number of dataloggers of a station	 
datumhor		VARCHAR2(8)	Y	Datum type for horizontal (latitude and longitude) coordinates	 
datumver		VARCHAR2(8)	Y	Datum type for depth or elevation	 
ondate		DATE	N	This attribute denotes the start date	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	St03	elev >= -5000.0 AND elev <= 5000.0	 
	Check	St04	lat >= -90.0 AND lat <= 90.0	 
	Check	St05	lon >= -180.0 AND lon <= 180.0	 
	Check	St06	nb_data >= 0	 
	Check	St07	nb_digi >= 0	 
	Check	St08	nb_filamp >= 0	 
	Check	St09	nb_sensor >= 0	 
	Check	St01	datumhor IN ('NAD27','WGS84')	 
	Check	St02	datumver IN ('NAD27','WGS84','AVERAGE')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station	Station_Datalogger	Identifying	Sta_Dat_Sta	 
Station	Station_Digitizer	Identifying	Sta_Dig_Sta	 
Station	Station_Filamp	Identifying	Sta_Fil_Sta	 
Station	Station_Sensor	Identifying	Sta_Sen_Sta	 
DDL Code 

CREATE TABLE Station(
    sta          VARCHAR2(6)         NOT NULL,
    net          VARCHAR2(8)         NOT NULL,
    lat          DOUBLE PRECISION,
    lon          DOUBLE PRECISION,
    elev         DOUBLE PRECISION,
    staname      VARCHAR2(50),
    nb_sensor    NUMBER(8, 0),
    nb_filamp    NUMBER(8, 0),
    nb_digi      NUMBER(8, 0)        NOT NULL,
    nb_data      NUMBER(8, 0)        NOT NULL,
    datumhor     VARCHAR2(8),
    datumver     VARCHAR2(8),
    ondate       DATE                NOT NULL,
    offdate      DATE,
    lddate       DATE                DEFAULT (SYSDATE),
    CONSTRAINT St03 CHECK (elev >= -5000.0 AND elev <= 5000.0),
    CONSTRAINT St04 CHECK (lat >= -90.0 AND lat <= 90.0),
    CONSTRAINT St05 CHECK (lon >= -180.0 AND lon <= 180.0),
    CONSTRAINT St06 CHECK (nb_data >= 0),
    CONSTRAINT St07 CHECK (nb_digi >= 0),
    CONSTRAINT St08 CHECK (nb_filamp >= 0),
    CONSTRAINT St09 CHECK (nb_sensor >= 0),
    CONSTRAINT St01 CHECK (datumhor IN ('NAD27','WGS84')),
    CONSTRAINT St02 CHECK (datumver IN ('NAD27','WGS84','AVERAGE')),
    CONSTRAINT St00 PRIMARY KEY (sta, net, ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

lat

Column Name	lat	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lon

Column Name	lon	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

elev

Column Name	elev	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Elevation. This attribute is the elevation of a seismic station relative to mean sea level	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

staname

Column Name	staname	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Station name/description. This is the full name of the station whose code-name is in sta	
Column Properties 

Data Type	VARCHAR2(50)	Width	50	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

nb_sensor

Column Name	nb_sensor	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of sensors of a station	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

nb_filamp

Column Name	nb_filamp	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of filter-amplifiers of a station	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

nb_digi

Column Name	nb_digi	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of digitizers of a station	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

nb_data

Column Name	nb_data	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of dataloggers of a station	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

datumhor

Column Name	datumhor	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datum type for horizontal (latitude and longitude) coordinates	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

datumver

Column Name	datumver	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datum type for depth or elevation	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

ondate

Column Name	ondate	Table Name	Station	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Datalogger

Table Name	Station_Datalogger	
Owner Name		
Primary Keys	sta,net,data_nb,ondate	
Definition	Data associating a station with a datalogger	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMBER(8, 0)	N	This attribute represents the datalogger number	 
ondate		DATE	N	This attribute denotes the start date	 
data_id		NUMBER(8, 0)	N	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	 
nb_pchannel		NUMBER(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDa01	data_nb >= 1	 
	Check	StDa02	nb_pchannel >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Datalogger	Station_Datalogger	Non-Identifying	Sta_Dat_Dat	 
Station	Station_Datalogger	Identifying	Sta_Dat_Sta	 
Station_Datalogger	Station_Datalogger_PChannel	Identifying	Sta_Dat_PCh_Sta_Dat	 
DDL Code 

CREATE TABLE Station_Datalogger(
    sta            VARCHAR2(6)     NOT NULL,
    net            VARCHAR2(8)     NOT NULL,
    data_nb        NUMBER(8, 0)    NOT NULL,
    ondate         DATE            NOT NULL,
    data_id        NUMBER(8, 0)    NOT NULL,
    nb_pchannel    NUMBER(8, 0)    NOT NULL,
    offdate        DATE,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT StDa01 CHECK (data_nb >= 1),
    CONSTRAINT StDa02 CHECK (nb_pchannel >= 0),
    CONSTRAINT StDa00 PRIMARY KEY (sta, net, data_nb, ondate), 
    CONSTRAINT Sta_Dat_Dat FOREIGN KEY (data_id)
    REFERENCES Datalogger(data_id),
    CONSTRAINT Sta_Dat_Sta FOREIGN KEY (sta,net,ondate)
    REFERENCES Station(sta,net,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Datalogger	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Datalogger	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

data_nb

Column Name	data_nb	Table Name	Station_Datalogger	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the datalogger number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Datalogger	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

data_id

Column Name	data_id	Table Name	Station_Datalogger	
Role Name	data_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Datalogger	
Definition 

Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

nb_pchannel

Column Name	nb_pchannel	Table Name	Station_Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Datalogger	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Datalogger_LChannel

Table Name	Station_Datalogger_LChannel	
Owner Name		
Primary Keys	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	
Definition	Summary information on a channel	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMBER(8, 0)	N	This attribute represents the datalogger number	 
pchannel_nb		NUMBER(8, 0)	N	This attribute denotes a physical channel	 
lchannel_nb		NUMBER(8, 0)	N	This attribute denotes a logical channel of a datalogger	 
ondate		DATE	N	This attribute denotes the start date	 
seqfil_id		NUMBER(8, 0)	Y	Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	 
seedchan		VARCHAR2(3)	Y	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	 
channel		VARCHAR2(3)	Y	Channel name	 
channelsrc		VARCHAR2(8)	Y	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)	 
location		VARCHAR2(2)	Y	Describes the individual sites on an array station, operated by the same network operator	 
rgain		DOUBLE PRECISION	Y	This attribute denotes the gain at the response frequency	 
rfrequency		DOUBLE PRECISION	Y	The frequency (fs) at which the value in rgain is correct	 
samprate		DOUBLE PRECISION	N	Sampling rate. This attribute is the sample rate in samples/second	 
clock_drift		DOUBLE PRECISION	Y	A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series	 
flags		VARCHAR2(27)	Y	Channel flags	 
data_format		VARCHAR2(80)	N	This attribute represents the data format	 
comp_type		NUMBER(8, 0)	N	Compression type. A lookup key that refers to the Format Dictionary	 
unit_signal		NUMBER(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices	 
unit_calib		NUMBER(8, 0)	N	A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps	 
block_size		NUMBER(8, 0)	N	The record length of the data	 
offdate		DATE	Y	This attribute denotes the end date	 
remark		VARCHAR2(30)	Y	An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDaL01	block_size >= 256 AND block_size <= 4096	 
	Check	StDaL02	clock_drift >= 0.0	 
	Check	StDaL03	data_nb >= 1	 
	Check	StDaL04	lchannel_nb >= 1	 
	Check	StDaL05	pchannel_nb >= 1	 
	Check	StDaL06	rfrequency > 0.0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	Sta_Dat_LCh_Fil_Seq	 
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	Sta_Dat_LCh_Sta_Dat_PCh	 
DDL Code 

CREATE TABLE Station_Datalogger_LChannel(
    sta            VARCHAR2(6)         NOT NULL,
    net            VARCHAR2(8)         NOT NULL,
    data_nb        NUMBER(8, 0)        NOT NULL,
    pchannel_nb    NUMBER(8, 0)        NOT NULL,
    lchannel_nb    NUMBER(8, 0)        NOT NULL,
    ondate         DATE                NOT NULL,
    seqfil_id      NUMBER(8, 0),
    seedchan       VARCHAR2(3),
    channel        VARCHAR2(3),
    channelsrc     VARCHAR2(8),
    location       VARCHAR2(2),
    rgain          DOUBLE PRECISION,
    rfrequency     DOUBLE PRECISION,
    samprate       DOUBLE PRECISION    NOT NULL,
    clock_drift    DOUBLE PRECISION,
    flags          VARCHAR2(27),
    data_format    VARCHAR2(80)        NOT NULL,
    comp_type      NUMBER(8, 0)        NOT NULL,
    unit_signal    NUMBER(8, 0)        NOT NULL,
    unit_calib     NUMBER(8, 0)        NOT NULL,
    block_size     NUMBER(8, 0)        NOT NULL,
    offdate        DATE,
    remark         VARCHAR2(30),
    lddate         DATE                DEFAULT (SYSDATE),
    CONSTRAINT StDaL01 CHECK (block_size >= 256 AND block_size <= 4096),
    CONSTRAINT StDaL02 CHECK (clock_drift >= 0.0),
    CONSTRAINT StDaL03 CHECK (data_nb >= 1),
    CONSTRAINT StDaL04 CHECK (lchannel_nb >= 1),
    CONSTRAINT StDaL05 CHECK (pchannel_nb >= 1),
    CONSTRAINT StDaL06 CHECK (rfrequency > 0.0),
    CONSTRAINT StDaL00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, lchannel_nb, ondate), 
    CONSTRAINT Sta_Dat_LCh_Fil_Seq FOREIGN KEY (seqfil_id)
    REFERENCES Filter_Sequence(seqfil_id),
    CONSTRAINT Sta_Dat_LCh_Sta_Dat_PCh FOREIGN KEY (sta,net,data_nb,pchannel_nb,ondate)
    REFERENCES Station_Datalogger_PChannel(sta,net,data_nb,pchannel_nb,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Datalogger_LChannel	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger_PChannel	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Datalogger_LChannel	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger_PChannel	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

data_nb

Column Name	data_nb	Table Name	Station_Datalogger_LChannel	
Role Name	data_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger_PChannel	
Definition 

This attribute represents the datalogger number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pchannel_nb

Column Name	pchannel_nb	Table Name	Station_Datalogger_LChannel	
Role Name	pchannel_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger_PChannel	
Definition 

This attribute denotes a physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lchannel_nb

Column Name	lchannel_nb	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a logical channel of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Datalogger_LChannel	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger_PChannel	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

seqfil_id

Column Name	seqfil_id	Table Name	Station_Datalogger_LChannel	
Role Name	seqfil_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Filter_Sequence	
Definition 

Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	YES	
Identity	NO	
Identity	NO	

seedchan

Column Name	seedchan	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code	
Column Properties 

Data Type	VARCHAR2(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

channel

Column Name	channel	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel name	
Column Properties 

Data Type	VARCHAR2(3)	Width	3	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

channelsrc

Column Name	channelsrc	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

location

Column Name	location	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Describes the individual sites on an array station, operated by the same network operator	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

rgain

Column Name	rgain	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the gain at the response frequency	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

rfrequency

Column Name	rfrequency	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The frequency (fs) at which the value in rgain is correct	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

samprate

Column Name	samprate	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Sampling rate. This attribute is the sample rate in samples/second	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

clock_drift

Column Name	clock_drift	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

flags

Column Name	flags	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Channel flags	
Column Properties 

Data Type	VARCHAR2(27)	Width	27	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

data_format

Column Name	data_format	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the data format	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

comp_type

Column Name	comp_type	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Compression type. A lookup key that refers to the Format Dictionary	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

unit_signal

Column Name	unit_signal	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

unit_calib

Column Name	unit_calib	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

block_size

Column Name	block_size	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The record length of the data	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

remark

Column Name	remark	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications	
Column Properties 

Data Type	VARCHAR2(30)	Width	30	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

lddate

Column Name	lddate	Table Name	Station_Datalogger_LChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Datalogger_PChannel

Table Name	Station_Datalogger_PChannel	
Owner Name		
Primary Keys	sta,net,data_nb,pchannel_nb,ondate	
Definition	Data associating channels	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
data_nb		NUMBER(8, 0)	N	This attribute represents the datalogger number	 
pchannel_nb		NUMBER(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
board_type		VARCHAR2(1)	N	This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)	 
channel_type		VARCHAR2(1)	N	This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)	 
seed_io		VARCHAR2(2)	N	This attribute represents the SEED instrument and orientation	 
nb_lchannel		NUMBER(8, 0)	N	This attribute denotes the number of logical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDaP01	data_nb >= 1	 
	Check	StDaP02	nb_lchannel >= 1	 
	Check	StDaP03	pchannel_nb >= 1	 
	Check	StDaP04	board_type IN ('P', 'A', 'E', 'D')	 
	Check	StDaP05	channel_type IN ('P', 'S')	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station_Datalogger	Station_Datalogger_PChannel	Identifying	Sta_Dat_PCh_Sta_Dat	 
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	Sta_Dat_LCh_Sta_Dat_PCh	 
DDL Code 

CREATE TABLE Station_Datalogger_PChannel(
    sta             VARCHAR2(6)     NOT NULL,
    net             VARCHAR2(8)     NOT NULL,
    data_nb         NUMBER(8, 0)    NOT NULL,
    pchannel_nb     NUMBER(8, 0)    NOT NULL,
    ondate          DATE            NOT NULL,
    board_type      VARCHAR2(1)     NOT NULL,
    channel_type    VARCHAR2(1)     NOT NULL,
    seed_io         VARCHAR2(2)     NOT NULL,
    nb_lchannel     NUMBER(8, 0)    NOT NULL,
    offdate         DATE,
    lddate          DATE            DEFAULT (SYSDATE),
    CONSTRAINT StDaP01 CHECK (data_nb >= 1),
    CONSTRAINT StDaP02 CHECK (nb_lchannel >= 1),
    CONSTRAINT StDaP03 CHECK (pchannel_nb >= 1),
    CONSTRAINT StDaP04 CHECK (board_type IN ('P', 'A', 'E', 'D')),
    CONSTRAINT StDaP05 CHECK (channel_type IN ('P', 'S')),
    CONSTRAINT StDaP00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, ondate), 
    CONSTRAINT Sta_Dat_PCh_Sta_Dat FOREIGN KEY (sta,net,data_nb,ondate)
    REFERENCES Station_Datalogger(sta,net,data_nb,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Datalogger_PChannel	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Datalogger_PChannel	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

data_nb

Column Name	data_nb	Table Name	Station_Datalogger_PChannel	
Role Name	data_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger	
Definition 

This attribute represents the datalogger number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pchannel_nb

Column Name	pchannel_nb	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Datalogger_PChannel	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Datalogger	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

board_type

Column Name	board_type	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

channel_type

Column Name	channel_type	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

seed_io

Column Name	seed_io	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the SEED instrument and orientation	
Column Properties 

Data Type	VARCHAR2(2)	Width	2	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

nb_lchannel

Column Name	nb_lchannel	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of logical channels of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Datalogger_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Digitizer

Table Name	Station_Digitizer	
Owner Name		
Primary Keys	sta,net,digi_nb,ondate	
Definition	Data associating a station with a digitizer	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
digi_nb		NUMBER(8, 0)	N	This attribute represents the digitizer number	 
ondate		DATE	N	This attribute denotes the start date	 
serial_nb		VARCHAR2(80)	N	This attribute denotes a serial number of a datalogger board	 
nb_pri_pchannel		NUMBER(8, 0)	N	This attribute denotes the number of primary physical channels of a digitizer	 
nb_aux_pchannel		NUMBER(8, 0)	N	This attribute denotes the number of auxiliary physical channels of a digitizer	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDi01	digi_nb >= 1	 
	Check	StDi02	nb_aux_pchannel >= 0	 
	Check	StDi03	nb_pri_pchannel >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station	Station_Digitizer	Identifying	Sta_Dig_Sta	 
Station_Digitizer	Station_Digitizer_PChannel	Identifying	Sta_Dig_PCh_Sta_Dig	 
DDL Code 

CREATE TABLE Station_Digitizer(
    sta                VARCHAR2(6)     NOT NULL,
    net                VARCHAR2(8)     NOT NULL,
    digi_nb            NUMBER(8, 0)    NOT NULL,
    ondate             DATE            NOT NULL,
    serial_nb          VARCHAR2(80)    NOT NULL,
    nb_pri_pchannel    NUMBER(8, 0)    NOT NULL,
    nb_aux_pchannel    NUMBER(8, 0)    NOT NULL,
    offdate            DATE,
    lddate             DATE            DEFAULT (SYSDATE),
    CONSTRAINT StDi01 CHECK (digi_nb >= 1),
    CONSTRAINT StDi02 CHECK (nb_aux_pchannel >= 0),
    CONSTRAINT StDi03 CHECK (nb_pri_pchannel >= 0),
    CONSTRAINT StDi00 PRIMARY KEY (sta, net, digi_nb, ondate), 
    CONSTRAINT Sta_Dig_Sta FOREIGN KEY (sta,net,ondate)
    REFERENCES Station(sta,net,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Digitizer	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Digitizer	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

digi_nb

Column Name	digi_nb	Table Name	Station_Digitizer	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the digitizer number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Digitizer	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

serial_nb

Column Name	serial_nb	Table Name	Station_Digitizer	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a serial number of a datalogger board	
Column Properties 

Data Type	VARCHAR2(80)	Width	80	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

nb_pri_pchannel

Column Name	nb_pri_pchannel	Table Name	Station_Digitizer	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of primary physical channels of a digitizer	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

nb_aux_pchannel

Column Name	nb_aux_pchannel	Table Name	Station_Digitizer	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of auxiliary physical channels of a digitizer	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Digitizer	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Digitizer	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Digitizer_PChannel

Table Name	Station_Digitizer_PChannel	
Owner Name		
Primary Keys	sta,net,digi_nb,pchannel_nb,ondate	
Definition	Data associating physical channels	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
digi_nb		NUMBER(8, 0)	N	This attribute represents the digitizer number	 
pchannel_nb		NUMBER(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
data_nb		NUMBER(8, 0)	N	This attribute represents the datalogger number	 
data_pchannel		NUMBER(8, 0)	N	This attribute represents a datalogger physical channel	 
digi_type		VARCHAR2(3)	N	This attribute represents the digitizer type	 
digi_polarity		VARCHAR2(1)	N	This attribute represents the digitizer polarity	 
digi_channel		NUMBER(8, 0)	N	This attribute represents a digitizer module on a board	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StDiP01	data_nb >= 1	 
	Check	StDiP02	data_pchannel >= 1	 
	Check	StDiP03	digi_nb >= 1	 
	Check	StDiP05	pchannel_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station_Digitizer	Station_Digitizer_PChannel	Identifying	Sta_Dig_PCh_Sta_Dig	 
DDL Code 

CREATE TABLE Station_Digitizer_PChannel(
    sta              VARCHAR2(6)     NOT NULL,
    net              VARCHAR2(8)     NOT NULL,
    digi_nb          NUMBER(8, 0)    NOT NULL,
    pchannel_nb      NUMBER(8, 0)    NOT NULL,
    ondate           DATE            NOT NULL,
    data_nb          NUMBER(8, 0)    NOT NULL,
    data_pchannel    NUMBER(8, 0)    NOT NULL,
    digi_type        VARCHAR2(3)     NOT NULL,
    digi_polarity    VARCHAR2(1)     NOT NULL,
    digi_channel     NUMBER(8, 0)    NOT NULL,
    offdate          DATE,
    lddate           DATE            DEFAULT (SYSDATE),
    CONSTRAINT StDiP01 CHECK (data_nb >= 1),
    CONSTRAINT StDiP02 CHECK (data_pchannel >= 1),
    CONSTRAINT StDiP03 CHECK (digi_nb >= 1),
    CONSTRAINT StDiP05 CHECK (pchannel_nb >= 1),
    CONSTRAINT StDiP00 PRIMARY KEY (sta, net, digi_nb, pchannel_nb, ondate), 
    CONSTRAINT Sta_Dig_PCh_Sta_Dig FOREIGN KEY (sta,net,digi_nb,ondate)
    REFERENCES Station_Digitizer(sta,net,digi_nb,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Digitizer_PChannel	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Digitizer	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Digitizer_PChannel	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Digitizer	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

digi_nb

Column Name	digi_nb	Table Name	Station_Digitizer_PChannel	
Role Name	digi_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Digitizer	
Definition 

This attribute represents the digitizer number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pchannel_nb

Column Name	pchannel_nb	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Digitizer_PChannel	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Digitizer	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

data_nb

Column Name	data_nb	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the datalogger number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

data_pchannel

Column Name	data_pchannel	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents a datalogger physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

digi_type

Column Name	digi_type	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the digitizer type	
Column Properties 

Data Type	VARCHAR2(3)	Width	3	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

digi_polarity

Column Name	digi_polarity	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the digitizer polarity	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

digi_channel

Column Name	digi_channel	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents a digitizer module on a board	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Digitizer_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Filamp

Table Name	Station_Filamp	
Owner Name		
Primary Keys	sta,net,filamp_nb,ondate	
Definition	Data associating a station with a filter-amplifier	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
filamp_nb		NUMBER(8, 0)	N	This attribute represents the filter-amplifier number	 
ondate		DATE	N	This attribute denotes the start date	 
filamp_id		NUMBER(8, 0)	N	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	 
nb_pchannel		NUMBER(8, 0)	N	This attribute denotes the number of physical channels of a datalogger	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StFi01	filamp_nb >= 1	 
	Check	StFi02	nb_pchannel >= 0	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Filamp	Station_Filamp	Non-Identifying	Sta_Fil_Fil	 
Station	Station_Filamp	Identifying	Sta_Fil_Sta	 
Station_Filamp	Station_Filamp_PChannel	Identifying	Sta_Fil_PCh_Sta_Fil	 
DDL Code 

CREATE TABLE Station_Filamp(
    sta            VARCHAR2(6)     NOT NULL,
    net            VARCHAR2(8)     NOT NULL,
    filamp_nb      NUMBER(8, 0)    NOT NULL,
    ondate         DATE            NOT NULL,
    filamp_id      NUMBER(8, 0)    NOT NULL,
    nb_pchannel    NUMBER(8, 0)    NOT NULL,
    offdate        DATE,
    lddate         DATE            DEFAULT (SYSDATE),
    CONSTRAINT StFi01 CHECK (filamp_nb >= 1),
    CONSTRAINT StFi02 CHECK (nb_pchannel >= 0),
    CONSTRAINT StFi00 PRIMARY KEY (sta, net, filamp_nb, ondate), 
    CONSTRAINT Sta_Fil_Fil FOREIGN KEY (filamp_id)
    REFERENCES Filamp(filamp_id),
    CONSTRAINT Sta_Fil_Sta FOREIGN KEY (sta,net,ondate)
    REFERENCES Station(sta,net,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Filamp	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Filamp	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

filamp_nb

Column Name	filamp_nb	Table Name	Station_Filamp	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the filter-amplifier number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Filamp	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

filamp_id

Column Name	filamp_id	Table Name	Station_Filamp	
Role Name	filamp_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Filamp	
Definition 

Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

nb_pchannel

Column Name	nb_pchannel	Table Name	Station_Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of physical channels of a datalogger	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Filamp	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Filamp_PChannel

Table Name	Station_Filamp_PChannel	
Owner Name		
Primary Keys	sta,net,filamp_nb,pchannel_nb,ondate	
Definition	Data associating physical channels	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
filamp_nb		NUMBER(8, 0)	N	This attribute represents the filter-amplifier number	 
pchannel_nb		NUMBER(8, 0)	N	This attribute denotes a physical channel	 
ondate		DATE	N	This attribute denotes the start date	 
next_hard_type		VARCHAR2(1)	N	This attribute denotes the next hardware type	 
next_hard_nb		NUMBER(8, 0)	N	This attribute denotes the next hardware number	 
next_hard_pchannel		NUMBER(8, 0)	N	This attribute denotes the next hardware physical channel	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StFiP01	filamp_nb >= 1	 
	Check	StFiP02	next_hard_nb >= 1	 
	Check	StFiP03	next_hard_pchannel >= 1	 
	Check	StFiP04	next_hard_type IN ('F','D')	 
	Check	StFiP05	pchannel_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station_Filamp	Station_Filamp_PChannel	Identifying	Sta_Fil_PCh_Sta_Fil	 
DDL Code 

CREATE TABLE Station_Filamp_PChannel(
    sta                   VARCHAR2(6)     NOT NULL,
    net                   VARCHAR2(8)     NOT NULL,
    filamp_nb             NUMBER(8, 0)    NOT NULL,
    pchannel_nb           NUMBER(8, 0)    NOT NULL,
    ondate                DATE            NOT NULL,
    next_hard_type        VARCHAR2(1)     NOT NULL,
    next_hard_nb          NUMBER(8, 0)    NOT NULL,
    next_hard_pchannel    NUMBER(8, 0)    NOT NULL,
    offdate               DATE,
    lddate                DATE            DEFAULT (SYSDATE),
    CONSTRAINT StFiP01 CHECK (filamp_nb >= 1),
    CONSTRAINT StFiP02 CHECK (next_hard_nb >= 1),
    CONSTRAINT StFiP03 CHECK (next_hard_pchannel >= 1),
    CONSTRAINT StFiP04 CHECK (next_hard_type IN ('F','D')),
    CONSTRAINT StFiP05 CHECK (pchannel_nb >= 1),
    CONSTRAINT StFiP00 PRIMARY KEY (sta, net, filamp_nb, pchannel_nb, ondate), 
    CONSTRAINT Sta_Fil_PCh_Sta_Fil FOREIGN KEY (sta,net,filamp_nb,ondate)
    REFERENCES Station_Filamp(sta,net,filamp_nb,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Filamp_PChannel	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Filamp	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Filamp_PChannel	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Filamp	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

filamp_nb

Column Name	filamp_nb	Table Name	Station_Filamp_PChannel	
Role Name	filamp_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Filamp	
Definition 

This attribute represents the filter-amplifier number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

pchannel_nb

Column Name	pchannel_nb	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes a physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Filamp_PChannel	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Filamp	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

next_hard_type

Column Name	next_hard_type	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware type	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

next_hard_nb

Column Name	next_hard_nb	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

next_hard_pchannel

Column Name	next_hard_pchannel	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Filamp_PChannel	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Sensor

Table Name	Station_Sensor	
Owner Name		
Primary Keys	sta,net,sensor_nb,ondate	
Definition	Data associating a station with a sensor	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sensor_nb		NUMBER(8, 0)	N	This attribute represents the sensor number	 
ondate		DATE	N	This attribute denotes the start date	 
sensor_id		NUMBER(8, 0)	N	Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	 
lat		DOUBLE PRECISION	Y	Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	 
lon		DOUBLE PRECISION	Y	Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	 
elev		DOUBLE PRECISION	Y	Elevation. This attribute is the elevation of a seismic station relative to mean sea level	 
edepth		DOUBLE PRECISION	Y	Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev	 
nb_component		NUMBER(8, 0)	N	This attribute denotes the number of components of a sensor	 
datumhor		VARCHAR2(8)	Y	Datum type for horizontal (latitude and longitude) coordinates	 
datumver		VARCHAR2(8)	Y	Datum type for depth or elevation	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StSe01	datumhor IN ('NAD27','WGS84')	 
	Check	StSe02	datumver IN ('NAD27','WGS84','AVERAGE')	 
	Check	StSe03	edepth >= 0.0	 
	Check	StSe04	elev >= -5000.0 AND elev <= 5000.0	 
	Check	StSe05	lat >= -90.0 AND lat <= 90.0	 
	Check	StSe06	lon >= -180.0 AND lon <= 180.0	 
	Check	StSe07	nb_component >= 0	 
	Check	StSe08	sensor_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Sensor	Station_Sensor	Non-Identifying	Sta_Sen_Sen	 
Station	Station_Sensor	Identifying	Sta_Sen_Sta	 
Station_Sensor	Station_Sensor_Component	Identifying	Sta_Sen_Com_Sta_Sen	 
DDL Code 

CREATE TABLE Station_Sensor(
    sta             VARCHAR2(6)         NOT NULL,
    net             VARCHAR2(8)         NOT NULL,
    sensor_nb       NUMBER(8, 0)        NOT NULL,
    ondate          DATE                NOT NULL,
    sensor_id       NUMBER(8, 0)        NOT NULL,
    lat             DOUBLE PRECISION,
    lon             DOUBLE PRECISION,
    elev            DOUBLE PRECISION,
    edepth          DOUBLE PRECISION,
    nb_component    NUMBER(8, 0)        NOT NULL,
    datumhor        VARCHAR2(8),
    datumver        VARCHAR2(8),
    offdate         DATE,
    lddate          DATE                DEFAULT (SYSDATE),
    CONSTRAINT StSe01 CHECK (datumhor IN ('NAD27','WGS84')),
    CONSTRAINT StSe02 CHECK (datumver IN ('NAD27','WGS84','AVERAGE')),
    CONSTRAINT StSe03 CHECK (edepth >= 0.0),
    CONSTRAINT StSe04 CHECK (elev >= -5000.0 AND elev <= 5000.0),
    CONSTRAINT StSe05 CHECK (lat >= -90.0 AND lat <= 90.0),
    CONSTRAINT StSe06 CHECK (lon >= -180.0 AND lon <= 180.0),
    CONSTRAINT StSe07 CHECK (nb_component >= 0),
    CONSTRAINT StSe08 CHECK (sensor_nb >= 1),
    CONSTRAINT StSe00 PRIMARY KEY (sta, net, sensor_nb, ondate), 
    CONSTRAINT Sta_Sen_Sen FOREIGN KEY (sensor_id)
    REFERENCES Sensor(sensor_id),
    CONSTRAINT Sta_Sen_Sta FOREIGN KEY (sta,net,ondate)
    REFERENCES Station(sta,net,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Sensor	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Sensor	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

sensor_nb

Column Name	sensor_nb	Table Name	Station_Sensor	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the sensor number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Sensor	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

sensor_id

Column Name	sensor_id	Table Name	Station_Sensor	
Role Name	sensor_id	
Primary Key	NO	
Foreign Key	YES	Parent Table	Sensor	
Definition 

Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

lat

Column Name	lat	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lon

Column Name	lon	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

elev

Column Name	elev	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Elevation. This attribute is the elevation of a seismic station relative to mean sea level	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

edepth

Column Name	edepth	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

nb_component

Column Name	nb_component	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the number of components of a sensor	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

datumhor

Column Name	datumhor	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datum type for horizontal (latitude and longitude) coordinates	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

datumver

Column Name	datumver	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Datum type for depth or elevation	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	YES	
Identity	NO	
Character Set	BYTE	

offdate

Column Name	offdate	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Sensor	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Station_Sensor_Component

Table Name	Station_Sensor_Component	
Owner Name		
Primary Keys	sta,net,sensor_nb,component_nb,ondate	
Definition	Data associating physical channels	
Columns 

Column Name	Domain	Datatype	Null	Definition	
sta		VARCHAR2(6)	N	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	 
net		VARCHAR2(8)	N	Unique network identifier. This character string is the name of a seismic network	 
sensor_nb		NUMBER(8, 0)	N	This attribute represents the sensor number	 
component_nb		NUMBER(8, 0)	N	This attribute represents the component number	 
ondate		DATE	N	This attribute denotes the start date	 
next_hard_type		VARCHAR2(1)	N	This attribute denotes the next hardware type	 
next_hard_nb		NUMBER(8, 0)	N	This attribute denotes the next hardware number	 
next_hard_pchannel		NUMBER(8, 0)	N	This attribute denotes the next hardware physical channel	 
azimuth		DOUBLE PRECISION	Y	The azimuth of the instrument from north, clockwise	 
dip		DOUBLE PRECISION	Y	The dip of the instrument, down from horizontal	 
offdate		DATE	Y	This attribute denotes the end date	 
lddate		DATE	Y	Load date. Date and time that the record was created or last modified, in Oracle date datatype	 
Storage 

TABLESPACE	HT_DATA	
PCTFREE		
PCTUSED 		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
ORGANIZATION		
CACHE	NO	
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

Defaults, Rules and Check Constraints 

Column	Type	Name	Restriction	
lddate	Default		(SYSDATE)	 
	Check	StSeC01	azimuth >= 0.0 AND azimuth <= 360.0	 
	Check	StSeC02	component_nb >= 1	 
	Check	StSec03	dip >= -90.0 AND dip <= 90.0	 
	Check	StSec04	next_hard_nb >= 1	 
	Check	StSec05	next_hard_pchannel >= 1	 
	Check	StSec06	next_hard_type IN ('F','D')	 
	Check	StSec07	sensor_nb >= 1	 
Foreign Keys 

Parent Table	Child Table	Type	Relationship Name	
Station_Sensor	Station_Sensor_Component	Identifying	Sta_Sen_Com_Sta_Sen	 
DDL Code 

CREATE TABLE Station_Sensor_Component(
    sta                   VARCHAR2(6)         NOT NULL,
    net                   VARCHAR2(8)         NOT NULL,
    sensor_nb             NUMBER(8, 0)        NOT NULL,
    component_nb          NUMBER(8, 0)        NOT NULL,
    ondate                DATE                NOT NULL,
    next_hard_type        VARCHAR2(1)         NOT NULL,
    next_hard_nb          NUMBER(8, 0)        NOT NULL,
    next_hard_pchannel    NUMBER(8, 0)        NOT NULL,
    azimuth               DOUBLE PRECISION,
    dip                   DOUBLE PRECISION,
    offdate               DATE,
    lddate                DATE                DEFAULT (SYSDATE),
    CONSTRAINT StSeC01 CHECK (azimuth >= 0.0 AND azimuth <= 360.0),
    CONSTRAINT StSeC02 CHECK (component_nb >= 1),
    CONSTRAINT StSec03 CHECK (dip >= -90.0 AND dip <= 90.0),
    CONSTRAINT StSec04 CHECK (next_hard_nb >= 1),
    CONSTRAINT StSec05 CHECK (next_hard_pchannel >= 1),
    CONSTRAINT StSec06 CHECK (next_hard_type IN ('F','D')),
    CONSTRAINT StSec07 CHECK (sensor_nb >= 1),
    CONSTRAINT StSeC00 PRIMARY KEY (sta, net, sensor_nb, component_nb, ondate), 
    CONSTRAINT Sta_Sen_Com_Sta_Sen FOREIGN KEY (sta,net,sensor_nb,ondate)
    REFERENCES Station_Sensor(sta,net,sensor_nb,ondate)
) 
TABLESPACE HT_DATA
;

	

sta

Column Name	sta	Table Name	Station_Sensor_Component	
Role Name	sta	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Sensor	
Definition 

Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used	
Column Properties 

Data Type	VARCHAR2(6)	Width	6	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

net

Column Name	net	Table Name	Station_Sensor_Component	
Role Name	net	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Sensor	
Definition 

Unique network identifier. This character string is the name of a seismic network	
Column Properties 

Data Type	VARCHAR2(8)	Width	8	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

sensor_nb

Column Name	sensor_nb	Table Name	Station_Sensor_Component	
Role Name	sensor_nb	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Sensor	
Definition 

This attribute represents the sensor number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

component_nb

Column Name	component_nb	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	YES	
Foreign Key	NO	Parent Table		
Definition 

This attribute represents the component number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

ondate

Column Name	ondate	Table Name	Station_Sensor_Component	
Role Name	ondate	
Primary Key	YES	
Foreign Key	YES	Parent Table	Station_Sensor	
Definition 

This attribute denotes the start date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	NO	
Identity	NO	
Identity	NO	

next_hard_type

Column Name	next_hard_type	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware type	
Column Properties 

Data Type	VARCHAR2(1)	Width	1	Scale		
Nullable	NO	
Identity	NO	
Character Set	BYTE	

next_hard_nb

Column Name	next_hard_nb	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware number	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

next_hard_pchannel

Column Name	next_hard_pchannel	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the next hardware physical channel	
Column Properties 

Data Type	NUMBER(8, 0)	Width	8	Scale	0	
Nullable	NO	
Identity	NO	
Identity	NO	

azimuth

Column Name	azimuth	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The azimuth of the instrument from north, clockwise	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

dip

Column Name	dip	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

The dip of the instrument, down from horizontal	
Column Properties 

Data Type	DOUBLE PRECISION	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

offdate

Column Name	offdate	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

This attribute denotes the end date	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

lddate

Column Name	lddate	Table Name	Station_Sensor_Component	
Role Name		
Primary Key	NO	
Foreign Key	NO	Parent Table		
Definition 

Load date. Date and time that the record was created or last modified, in Oracle date datatype	
Column Properties 

Data Type	DATE	Width		Scale		
Nullable	YES	
Identity	NO	
Identity	NO	

Index Summary Report

Table Name	Index Name	 Index Type	Unique	
Datalogger	Da00	PrimaryKey	YES	 
Datalogger_Board	DaB00	PrimaryKey	YES	 
Datalogger_Module	DaM00	PrimaryKey	YES	 
Filamp	Filamp00	PrimaryKey	YES	 
Filamp_PChannel	FiP00	PrimaryKey	YES	 
Filter	Fi00	PrimaryKey	YES	 
Filter_FIR	FFIR00	PrimaryKey	YES	 
Filter_FIR_Data	FFD00	PrimaryKey	YES	 
Filter_Sequence	FiS00	PrimaryKey	YES	 
Filter_Sequence_Data	FiSeD00	PrimaryKey	YES	 
Response	Re00	PrimaryKey	YES	 
Response_HP	RHP00	PrimaryKey	YES	 
Response_LP	RLP00	PrimaryKey	YES	 
Response_PN	RPN00	PrimaryKey	YES	 
Response_PN_Data	RPND00	PrimaryKey	YES	 
Response_PZ	RPZ00	PrimaryKey	YES	 
Sensor	Sensor00	PrimaryKey	YES	 
Sensor_Component	SeC00	PrimaryKey	YES	 
Station	St00	PrimaryKey	YES	 
Station_Datalogger	StDa00	PrimaryKey	YES	 
Station_Datalogger_LChannel	StDaL00	PrimaryKey	YES	 
Station_Datalogger_PChannel	StDaP00	PrimaryKey	YES	 
Station_Digitizer	StDi00	PrimaryKey	YES	 
Station_Digitizer_PChannel	StDiP00	PrimaryKey	YES	 
Station_Filamp	StFi00	PrimaryKey	YES	 
Station_Filamp_PChannel	StFiP00	PrimaryKey	YES	 
Station_Sensor	StSe00	PrimaryKey	YES	 
Station_Sensor_Component	StSeC00	PrimaryKey	YES	 

Index Detail Reports

Da00

Index Name	Da00	
Table Name	Datalogger	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	data_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

DaB00

Index Name	DaB00	
Table Name	Datalogger_Board	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	data_id,board_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

DaM00

Index Name	DaM00	
Table Name	Datalogger_Module	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	data_id,board_nb,module_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Filamp00

Index Name	Filamp00	
Table Name	Filamp	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	filamp_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

FiP00

Index Name	FiP00	
Table Name	Filamp_PChannel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	filamp_id,pchannel_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Fi00

Index Name	Fi00	
Table Name	Filter	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	filter_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

FFIR00

Index Name	FFIR00	
Table Name	Filter_FIR	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	fir_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

FFD00

Index Name	FFD00	
Table Name	Filter_FIR_Data	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	fir_id,coeff_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

FiS00

Index Name	FiS00	
Table Name	Filter_Sequence	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	seqfil_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

FiSeD00

Index Name	FiSeD00	
Table Name	Filter_Sequence_Data	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	seqfil_id,filter_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Re00

Index Name	Re00	
Table Name	Response	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	seqresp_id,resp_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

RHP00

Index Name	RHP00	
Table Name	Response_HP	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	hp_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

RLP00

Index Name	RLP00	
Table Name	Response_LP	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	lp_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

RPN00

Index Name	RPN00	
Table Name	Response_PN	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	pn_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

RPND00

Index Name	RPND00	
Table Name	Response_PN_Data	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	pn_id,pn_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

RPZ00

Index Name	RPZ00	
Table Name	Response_PZ	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	pz_id,pz_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Sensor00

Index Name	Sensor00	
Table Name	Sensor	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sensor_id	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

SeC00

Index Name	SeC00	
Table Name	Sensor_Component	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sensor_id,component_nb	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

St00

Index Name	St00	
Table Name	Station	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StDa00

Index Name	StDa00	
Table Name	Station_Datalogger	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,data_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StDaL00

Index Name	StDaL00	
Table Name	Station_Datalogger_LChannel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,data_nb,pchannel_nb,lchannel_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StDaP00

Index Name	StDaP00	
Table Name	Station_Datalogger_PChannel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,data_nb,pchannel_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StDi00

Index Name	StDi00	
Table Name	Station_Digitizer	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,digi_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StDiP00

Index Name	StDiP00	
Table Name	Station_Digitizer_PChannel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,digi_nb,pchannel_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StFi00

Index Name	StFi00	
Table Name	Station_Filamp	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,filamp_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StFiP00

Index Name	StFiP00	
Table Name	Station_Filamp_PChannel	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,filamp_nb,pchannel_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StSe00

Index Name	StSe00	
Table Name	Station_Sensor	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,sensor_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

StSeC00

Index Name	StSeC00	
Table Name	Station_Sensor_Component	
Index Type	PrimaryKey	
Unique	YES	
Index Keys	sta,net,sensor_nb,component_nb,ondate	
Properties 

TABLESPACE		
PCTFREE		
MINEXTENTS		
MAXEXTENTS		
INITIAL		
NEXT		
PCTINCREASE		
INITRANS		
MAXTRANS		
NO SORT	NO	
TYPE		
BYTE ORDER		
LOGGING		
PARALLEL	NO	
PARALLEL DEGREES		
PARALLEL INSTANCES		
FREELISTS		
FREELIST GROUPS		
BUFFER POOL		
Partitions 

DDL Code 

Foreign Key Summary Report

Parent Table	Child Table	Type	No. of Keys	
Datalogger	Datalogger_Board	Identifying	1	
Datalogger_Board	Datalogger_Module	Identifying	2	
Filamp	Filamp_PChannel	Identifying	1	
Filter_FIR	Filter_FIR_Data	Identifying	1	
Filter	Filter_Sequence_Data	Non-Identifying	1	
Filter_Sequence	Filter_Sequence_Data	Identifying	1	
Filter_FIR	Response	Non-Identifying	1	
Response_HP	Response	Non-Identifying	1	
Response_LP	Response	Non-Identifying	1	
Response_PN	Response	Non-Identifying	1	
Response_PN	Response_PN_Data	Identifying	1	
Sensor	Sensor_Component	Identifying	1	
Datalogger	Station_Datalogger	Non-Identifying	1	
Station	Station_Datalogger	Identifying	3	
Filter_Sequence	Station_Datalogger_LChannel	Non-Identifying	1	
Station_Datalogger_PChannel	Station_Datalogger_LChannel	Identifying	5	
Station_Datalogger	Station_Datalogger_PChannel	Identifying	4	
Station	Station_Digitizer	Identifying	3	
Station_Digitizer	Station_Digitizer_PChannel	Identifying	4	
Filamp	Station_Filamp	Non-Identifying	1	
Station	Station_Filamp	Identifying	3	
Station_Filamp	Station_Filamp_PChannel	Identifying	4	
Sensor	Station_Sensor	Non-Identifying	1	
Station	Station_Sensor	Identifying	3	
Station_Sensor	Station_Sensor_Component	Identifying	4	

Foreign Key Detail Reports

Foreign Key: Datalogger to Datalogger_Board

Name	Dat_Boa_Dat	
Type	Identifying	
Parent Table	Datalogger	
Child Table	Datalogger_Board	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
data_id	data_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Datalogger_Board to Datalogger_Module

Name	Dat_Mod_Dat_Boa	
Type	Identifying	
Parent Table	Datalogger_Board	
Child Table	Datalogger_Module	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
data_id	data_id	 
board_nb	board_nb	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filamp to Filamp_PChannel

Name	Fil_PCh_Fil	
Type	Identifying	
Parent Table	Filamp	
Child Table	Filamp_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
filamp_id	filamp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filter_FIR to Filter_FIR_Data

Name	Fil_FIR_Dat_Fil_FIR	
Type	Identifying	
Parent Table	Filter_FIR	
Child Table	Filter_FIR_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
fir_id	fir_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filter to Filter_Sequence_Data

Name	Fil_Seq_Dat_Fil	
Type	Non-Identifying	
Parent Table	Filter	
Child Table	Filter_Sequence_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
filter_id	filter_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filter_Sequence to Filter_Sequence_Data

Name	Fil_Seq_Dat_Fil_Seq	
Type	Identifying	
Parent Table	Filter_Sequence	
Child Table	Filter_Sequence_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
seqfil_id	seqfil_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filter_FIR to Response

Name	Res_Fil_FIR	
Type	Non-Identifying	
Parent Table	Filter_FIR	
Child Table	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
fir_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Response_HP to Response

Name	Res_Res_HP	
Type	Non-Identifying	
Parent Table	Response_HP	
Child Table	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
hp_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Response_LP to Response

Name	Res_Res_LP	
Type	Non-Identifying	
Parent Table	Response_LP	
Child Table	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
lp_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Response_PN to Response

Name	Res_Res_PN	
Type	Non-Identifying	
Parent Table	Response_PN	
Child Table	Response	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
pn_id	resp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Response_PN to Response_PN_Data

Name	Res_PN_Dat_Res_PN	
Type	Identifying	
Parent Table	Response_PN	
Child Table	Response_PN_Data	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
pn_id	pn_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Sensor to Sensor_Component

Name	Sen_Com_Sen	
Type	Identifying	
Parent Table	Sensor	
Child Table	Sensor_Component	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sensor_id	sensor_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Datalogger to Station_Datalogger

Name	Sta_Dat_Dat	
Type	Non-Identifying	
Parent Table	Datalogger	
Child Table	Station_Datalogger	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
data_id	data_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station to Station_Datalogger

Name	Sta_Dat_Sta	
Type	Identifying	
Parent Table	Station	
Child Table	Station_Datalogger	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filter_Sequence to Station_Datalogger_LChannel

Name	Sta_Dat_LCh_Fil_Seq	
Type	Non-Identifying	
Parent Table	Filter_Sequence	
Child Table	Station_Datalogger_LChannel	
Cardinality	Zero or One to Zero or More	
Existence	Optional	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
seqfil_id	seqfil_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station_Datalogger_PChannel to Station_Datalogger_LChannel

Name	Sta_Dat_LCh_Sta_Dat_PCh	
Type	Identifying	
Parent Table	Station_Datalogger_PChannel	
Child Table	Station_Datalogger_LChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
data_nb	data_nb	 
pchannel_nb	pchannel_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station_Datalogger to Station_Datalogger_PChannel

Name	Sta_Dat_PCh_Sta_Dat	
Type	Identifying	
Parent Table	Station_Datalogger	
Child Table	Station_Datalogger_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
data_nb	data_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station to Station_Digitizer

Name	Sta_Dig_Sta	
Type	Identifying	
Parent Table	Station	
Child Table	Station_Digitizer	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station_Digitizer to Station_Digitizer_PChannel

Name	Sta_Dig_PCh_Sta_Dig	
Type	Identifying	
Parent Table	Station_Digitizer	
Child Table	Station_Digitizer_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
digi_nb	digi_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Filamp to Station_Filamp

Name	Sta_Fil_Fil	
Type	Non-Identifying	
Parent Table	Filamp	
Child Table	Station_Filamp	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
filamp_id	filamp_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station to Station_Filamp

Name	Sta_Fil_Sta	
Type	Identifying	
Parent Table	Station	
Child Table	Station_Filamp	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station_Filamp to Station_Filamp_PChannel

Name	Sta_Fil_PCh_Sta_Fil	
Type	Identifying	
Parent Table	Station_Filamp	
Child Table	Station_Filamp_PChannel	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
filamp_nb	filamp_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Sensor to Station_Sensor

Name	Sta_Sen_Sen	
Type	Non-Identifying	
Parent Table	Sensor	
Child Table	Station_Sensor	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sensor_id	sensor_id	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station to Station_Sensor

Name	Sta_Sen_Sta	
Type	Identifying	
Parent Table	Station	
Child Table	Station_Sensor	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Foreign Key: Station_Sensor to Station_Sensor_Component

Name	Sta_Sen_Com_Sta_Sen	
Type	Identifying	
Parent Table	Station_Sensor	
Child Table	Station_Sensor_Component	
Cardinality	One To Zero or More	
Existence	Mandatory	
Propagated Key	Primary Key	
Foreign Key Description 

Verb Sentence		
Inverse Verb Sentence		
Definition		
Keys 

Parent Key	Child Key	
sta	sta	 
net	net	 
sensor_nb	sensor_nb	 
ondate	ondate	 
Trigger Templates 

Trigger Event	Trigger Action	
Parent Insert	None	 
Parent Update	None	 
Parent Delete	None	 
Child Insert	None	 
Child Update	None	 
Child Delete	None	 

Oracle Sequence Summary Report

Name	ObjectType	
ncedcdba.dataseq	Sequence	
ncedcdba.filampseq	Sequence	
ncedcdba.filterseq	Sequence	
ncedcdba.firseq	Sequence	
ncedcdba.hpseq	Sequence	
ncedcdba.lpseq	Sequence	
ncedcdba.pnseq	Sequence	
ncedcdba.pzseq	Sequence	
ncedcdba.respseq	Sequence	
ncedcdba.sensorseq	Sequence	
ncedcdba.seqfilseq	Sequence	

Oracle Sequence Detail Report

ncedcdba.dataseq

Name	dataseq	
ObjectType	Sequence	
Description 

Sequence for primary key Datalogger.data_id	
SQL 

CREATE SEQUENCE NCEDCDBA.DATASEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.filampseq

Name	filampseq	
ObjectType	Sequence	
Description 

Sequence for primary key Filamp.filamp_id	
SQL 

CREATE SEQUENCE NCEDCDBA.FILAMPSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.filterseq

Name	filterseq	
ObjectType	Sequence	
Description 

Sequence for primary key Filter.filter_id	
SQL 

CREATE SEQUENCE NCEDCDBA.FILTERSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.firseq

Name	firseq	
ObjectType	Sequence	
Description 

Sequence for primary key Filter_FIR.fir_id	
SQL 

CREATE SEQUENCE NCEDCDBA.FIRSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.hpseq

Name	hpseq	
ObjectType	Sequence	
Description 

Sequence for primary key Response_HP.hp_id	
SQL 

CREATE SEQUENCE NCEDCDBA.HPSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.lpseq

Name	lpseq	
ObjectType	Sequence	
Description 

Sequence for primary key Response_LP.lp_id	
SQL 

CREATE SEQUENCE NCEDCDBA.LPSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.pnseq

Name	pnseq	
ObjectType	Sequence	
Description 

Sequence for primary key Response_PN.pn_id	
SQL 

CREATE SEQUENCE NCEDCDBA.PNSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.pzseq

Name	pzseq	
ObjectType	Sequence	
Description 

Sequence for primary key Response_PZ.pz_id	
SQL 

CREATE SEQUENCE NCEDCDBA.PZSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.respseq

Name	respseq	
ObjectType	Sequence	
Description 

Sequence for primary key Response.seqresp_id	
SQL 

CREATE SEQUENCE NCEDCDBA.RESPSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.sensorseq

Name	sensorseq	
ObjectType	Sequence	
Description 

Sequence for primary key Sensor.sensor_id	
SQL 

CREATE SEQUENCE NCEDCDBA.SENSORSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER

ncedcdba.seqfilseq

Name	seqfilseq	
ObjectType	Sequence	
Description 

Sequence for primary key Filter_Sequence.seqfil_id	
SQL 

CREATE SEQUENCE NCEDCDBA.SEQFILSEQ 
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    NOMAXVALUE
    NOCYCLE
    CACHE 20
    ORDER