Channel_Data 
Logical Entity Name  Channel_Data 
Default Table Name  Channel_Data 
Definition  Summary information on a channel 

Channel_Data 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)    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)    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.) 
inid(FK)    NUMBER(8, 0)  YES  Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument 
remark    VARCHAR2(30)  YES  An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications 
unit_signal(FK)    NUMBER(8, 0)  NO  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(FK)    NUMBER(8, 0)  NO  A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps 
lat    BINARY_FLOAT  YES  Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes 
lon    BINARY_FLOAT  YES  Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian 
elev    BINARY_FLOAT  YES  Elevation. This attribute is the elevation of a seismic station relative to mean sea level 
edepth    BINARY_FLOAT  YES  Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev 
azimuth    BINARY_FLOAT  YES  The azimuth of the instrument from north, clockwise 
dip    BINARY_FLOAT  YES  The dip of the instrument, down from horizontal 
format_id(FK)    NUMBER(8, 0)  NO  A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel 
record_length    NUMBER(8, 0)  YES  The exponent (as a power of two) of the record length for these data 
samprate    BINARY_FLOAT  NO  Sampling rate. This attribute is the sample rate in samples/second 
clock_drift    BINARY_FLOAT  YES  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)  YES  Channel flags 
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 

Channel_Data Primary and Unique Keys 
Key Name  Key Type  Keys 
ChD00  PrimaryKey  net, sta, seedchan, location, ondate 

Channel_Data Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
D_Abbreviation  Non-Identifying  Zero or One to Zero or More  Cha_Dat_D_Abb      inid  NO  NO  NO 
D_Format  Non-Identifying  One To Zero or More  Cha_Dat_D_For      format_id  NO  NO  NO 
D_Unit  Non-Identifying  One To Zero or More  Cha_Dat_D_Uni      unit_signal  NO  NO  NO 
D_Unit  Non-Identifying  One To Zero or More  Cha_Dat_D_Uni2      unit_calib  NO  NO  NO 
Station_Data  Identifying  One To Zero or More  Cha_Dat_Sta_Dat      net, sta, ondate  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
Channel_Comment  Identifying  One To Zero or More  Cha_Com_Cha_Dat        NO  NO  NO 
Coefficients  Identifying  One To Zero or More  Coe_Cha_Dat        NO  NO  NO 
Decimation  Identifying  One To Zero or More  Dec_Cha_Dat        NO  NO  NO 
Polynomial  Identifying  One To Zero or More  Pol_Cha_Dat        NO  NO  NO 
Poles_Zeros  Identifying  One To Zero or More  Pol_Zer_Cha_Dat        NO  NO  NO 
Sensitivity  Identifying  One To Zero or More  Sen_Cha_Dat        NO  NO  NO 
Simple_Response  Identifying  One To Zero or More  Sim_Res_Cha_Dat        NO  NO  NO 

Channel_Data Check Constraints 
Check Constraint Name  CheckConstraint 
ChD01  azimuth >= 0.0 AND azimuth <= 360.0 
ChD02  clock_drift >= 0.0 
ChD03  dip >= -90.0 AND dip <= 90.0 
ChD04  edepth >= 0.0 
ChD06  lat >= -90.0 AND lat <= 90.0 
ChD07  lon >= -180.0 AND lon <= 180.0 
ChD08  record_length >= 8 AND record_length <= 12 
ChD09  samprate >= 0.0