Waveform 
Logical Entity Name  Waveform 
Default Table Name  Waveform 
Definition  Summary information on a waveform 

Waveform Columns 
ColumnName  Domain  Datatype  NULL  Definition 
wfid(PK)    NUMBER(15, 0)  NO  Waveform identifier. The key field is a unique identifier for a segment of digital waveform data 
net    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta    VARCHAR2(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
auth    VARCHAR2(15)  NO  The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record
 
subsource    VARCHAR2(8)  YES  A second identifier to specify a unique source within the domain specified by auth 
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.) 
seedchan    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    VARCHAR2(2)  YES  Describes the individual sites on an array station, operated by the same network operator 
archive    VARCHAR2(8)  NO  This field specifies the place where the seismogram is archived 
datetime_on    NUMBER(25, 10)  NO  Time of first datum 
datetime_off    NUMBER(25, 10)  NO  Time of last datum 
samprate    FLOAT(126)  NO  Sampling rate. This attribute is the sample rate in samples/second 
wavetype    VARCHAR2(1)  YES  This attribute denotes the type of waveform 
fileid(FK)    NUMBER(15, 0)  NO  Filename identifier. The key field is a unique identifier for a physical file on a disk 
foff    NUMBER(12, 0)  YES  File offset. This is the byte offset of a waveform segment within a data file. If the segment does not contain header information, this value is equal to traceoff 
nbytes    NUMBER(10, 0)  YES  Number of bytes. This quantity is the number of bytes in a waveform segment or a file. If the segment does not contain header information, this value is equal to tracelen; otherwise nbytes = headerlen + tracelen 
traceoff    NUMBER(10, 0)  YES  Trace offset. This is the byte offset of the entire trace 
tracelen    NUMBER(10, 0)  YES  Number of bytes. This quantity represents the length of the entire trace 
status    VARCHAR2(1)  NO  This attribute denotes the status of the waveform in the file 
wave_fmt    NUMBER(2, 0)  YES  Waveform type 
format_id    NUMBER(2, 0)  YES  This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group 
wordorder    NUMBER(1, 0)  YES  Word order 
recordsize    NUMBER(5, 0)  YES  Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc 
locevid    VARCHAR2(12)  YES  Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier 
qc_level    CHAR(1)  NO  This flag specifies the Data Header/Quality indicator flag for the specified waveform.

Reference: SEED manual in Fixed Section of Data Header.

For non-MiniSEED data, this would be the MiniSEED flag to be used
if the data would be converted to MiniSEED. 
lddate    DATE  NO  Load date. Date and time that the record was created or last modified
 

Waveform Primary and Unique Keys 
Key Name  Key Type  Keys 
WF00  PrimaryKey  wfid 

Waveform Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Filename  Non-Identifying  One To Zero or More  Waveform_Filename      fileid  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
AssocWaE  Identifying  One To Zero or More  Waveform_Event        NO  NO  NO 

Waveform Check Constraints 
Check Constraint Name  CheckConstraint 
WFRM05  (samprate > 0.0) 
WFRM01  (fileid > 0) 
WFRM02  (foff >=0) 
WFRM03  (format_id >=1) 
WFRM04  (recordsize >=0) 
WFRM06  (tracelen >=0) 
WFRM07  (traceoff >=0) 
WFRM09  (wave_fmt >=1) 
WFRM10  (wfid > 0) 
WFRM11  (wordorder >=0) 
WFRM12  (nbytes >=0) 
WFRM13  (qc_level in ('R','D','Q','M')) 
WFRM14  (status in ('E','T','A')) 
WFRM08  (wavetype in ('C','T'))