AssocWaE
EntityType Dependent
Logical Table Name AssocWaE
Owner
Definition Data associating waveforms with events
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
wfid(PK)(FK) NUMERIC(15, 0) NO Waveform identifier. The key field is a unique identifier for a segment of digital waveform data
evid(PK) NUMERIC(15, 0) NO Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network's event identifier, which is stored in the Origin table. This allows to merge data for a single event from multiple sources without insisting that database evid is identical to the source's local event identifier
datetime_on NUMERIC(25, 10) NO Time of first datum
datetime_off NUMERIC(25, 10) NO Time of last datum
lddate DATE NO Load date. Date and time that the record was created or last modified

Keys
Key Name Key Type Keys
AWE00 PrimaryKey wfid,evid

Relationships
Parent Entity Child Entity Type Foreign Keys
Waveform AssocWaE Identifying wfid

Attachments
Name Datatype Value Override Default Value Description


Filename
EntityType Independent
Logical Table Name Filename
Owner
Definition Summary information on a waveform filenames
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
fileid(PK) NUMERIC(15, 0) NO Filename identifier. The key field is a unique identifier for a physical file on a disk
dfile VARCHAR(32) NO Data file. This is the file name of a disk-based waveform file
datetime_on NUMERIC(25, 10) NO Time of first sample in the waveform file
datetime_off NUMERIC(25, 10) NO Time of last sample in the waveform file
nbytes NUMERIC(10, 0) YES Number of bytes. This quantity is the number of bytes in a waveform segment or a file
subdirid(FK) NUMERIC(15, 0) NO Directory identifier. The key field is a unique identifier for a directory name on a disk
lddate DATE NO Load date. Date and time that the record was created or last modified

Keys
Key Name Key Type Keys
Fil00 PrimaryKey fileid
wffileind Inversion Entry dfile

Relationships
Parent Entity Child Entity Type Foreign Keys
Subdir Filename Non-Identifying subdirid
Filename Waveform Non-Identifying fileid

Attachments
Name Datatype Value Override Default Value Description


Pathname
EntityType Independent
Logical Table Name Pathname
Owner
Definition Summary information on possible path options of waveforms for a given network
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
pathname(PK) VARCHAR(255) NO Path name
net(PK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
wave_fmt(PK) NUMERIC(2, 0) NO Waveform type

Keys
Key Name Key Type Keys
PK5 PrimaryKey pathname,net,wave_fmt

Relationships
Parent Entity Child Entity Type Foreign Keys

Attachments
Name Datatype Value Override Default Value Description


Subdir
EntityType Independent
Logical Table Name Subdir
Owner
Definition Summary information on a directory name
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
subdirid(PK) NUMERIC(15, 0) NO Directory identifier. The key field is a unique identifier for a directory name on a disk
subdirname VARCHAR(64) NO Path name. This is the name of a disk-based directory
lddate DATE NO Load date. Date and time that the record was created or last modified

Keys
Key Name Key Type Keys
Sub00 PrimaryKey subdirid

Relationships
Parent Entity Child Entity Type Foreign Keys
Subdir Filename Non-Identifying subdirid

Attachments
Name Datatype Value Override Default Value Description


Waveform
EntityType Independent
Logical Table Name Waveform
Owner
Definition Summary information on a waveform
Note

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(3) 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 NUMERIC(12, 8) 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
nbytes NUMERIC(10, 0) YES Number of bytes. This quantity is the number of bytes in a waveform segment or a file
traceoff NUMERIC(10, 0) YES File 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
lddate DATE NO Load date. Date and time that the record was created or last modified

Keys
Key Name Key Type Keys
WF00 PrimaryKey wfid
wfdonind Inversion Entry datetime_on
wfdoffind Inversion Entry datetime_off

Relationships
Parent Entity Child Entity Type Foreign Keys
Filename Waveform Non-Identifying fileid
Waveform AssocWaE Identifying wfid

Attachments
Name Datatype Value Override Default Value Description