Simple_Response 
Logical Entity Name  Simple_Response 
Default Table Name  Simple_Response 
Definition  Summary information on a simplified response 

Simple_Response Columns 
ColumnName  Domain  Datatype  NULL  Definition 
net(PK)(FK)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)(FK)    VARCHAR2(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
seedchan(PK)(FK)    VARCHAR2(3)  NO  SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 
location(PK)(FK)    VARCHAR2(2)  NO  Describes the individual sites on an array station, operated by the same network operator 
ondate(PK)(FK)    DATE  NO  This attribute denotes the start date 
channel    VARCHAR2(8)  YES  Channel name 
channelsrc    VARCHAR2(8)  YES  Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 
natural_frequency    BINARY_FLOAT  YES  Natural frequency 
damping_constant    BINARY_FLOAT  YES  This attribute denotes the damping constant of the system 
gain    BINARY_FLOAT  YES  This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute 
gain_units    VARCHAR2(20)  NO  This attribute denotes the units of the gain of the system, as given by the gain attribute 
low_freq_corner    BINARY_FLOAT  YES  Low frequency corner 
high_freq_corner    BINARY_FLOAT  YES  High frequency corner 
offdate    DATE  YES  This attribute denotes the end date 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 
dlogsens    NUMBER(8, 0)  YES  Digitizer sensitivity 

Simple_Response Primary and Unique Keys 
Key Name  Key Type  Keys 
SiRe00  PrimaryKey  net, sta, seedchan, location, ondate 

Simple_Response Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Channel_Data  Identifying  One To Zero or More  Sim_Res_Cha_Dat      net, sta, seedchan, location, ondate  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

Simple_Response Check Constraints 
Check Constraint Name  CheckConstraint 
SiRe02  gain_units IN ('DU/M/S','DU/M/S**2','counts/(cm/sec)','counts/(cm/sec2)') 
SiRe01  natural_frequency >= 0.0