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

Waveform Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
wfid(PK)    NUMERIC(15, 0)  NO  Waveform identifier. The key field is a unique identifier for a segment of digital waveform data 
net    VARCHAR(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta    VARCHAR(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
auth    VARCHAR(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    VARCHAR(8)  YES  A second identifier to specify a unique source within the domain specified by auth 
channel    VARCHAR(8)  YES  Channel name 
channelsrc    VARCHAR(8)  YES  Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 
seedchan    VARCHAR(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    VARCHAR(2)  YES  Describes the individual sites on an array station, operated by the same network operator 
archive    VARCHAR(8)  NO  This field specifies the place where the seismogram is archived 
datetime_on    NUMERIC(25, 10)  NO  Time of first datum 
datetime_off    NUMERIC(25, 10)  NO  Time of last datum 
samprate    FLOAT  NO  Sampling rate. This attribute is the sample rate in samples/second 
wavetype    VARCHAR(1)  YES  This attribute denotes the type of waveform 
fileid(FK)    NUMERIC(15, 0)  NO  Filename identifier. The key field is a unique identifier for a physical file on a disk 
foff    NUMERIC(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    NUMERIC(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    NUMERIC(10, 0)  YES  Trace offset. This is the byte offset of the entire trace 
tracelen    NUMERIC(10, 0)  YES  Number of bytes. This quantity represents the length of the entire trace 
status    VARCHAR(1)  NO  This attribute denotes the status of the waveform in the file 
wave_fmt    NUMERIC(2, 0)  YES  Waveform type 
format_id    NUMERIC(2, 0)  YES  This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group 
wordorder    NUMERIC(1, 0)  YES  Word order 
recordsize    NUMERIC(5, 0)  YES  Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc 
locevid    VARCHAR(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 Keys 
Key Name  Key Type  Keys 
WF00  PrimaryKey  wfid 

Waveform Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Filename  Non-Identifying  One To Zero or More        fileid  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
AssocWaE  Identifying  One To Zero or More          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'))