Waveroots 
Logical Entity Name  Waveroots 
Default Table Name  Waveroots 
Definition  Summary information on possible locations of waveforms based on common columns it shares with the WAVEFORM table 

Waveroots Columns 
ColumnName  Domain  Datatype  NULL  Definition 
archive(PK)    VARCHAR2(8)  NO  This field specifies the place where the seismogram is archived - such as NCEDC/SCEDC 
wavetype(PK)    VARCHAR2(2)  NO  This attribute denotes the type of waveform: (T)riggered or (C)ontinuous 
status(PK)    VARCHAR2(2)  NO  This attribute denotes the status of the waveform in the file: (A)rchived or (T)emporary 
net(PK)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network. A null value means waveforms from
any network could reside in this location 
wave_fmt(PK)    NUMBER(2, 0)  NO  Waveform type - (numeric code for format mSEED, SAC, SEGY, ...) 
datetime_on(PK)    NUMBER(25, 10)  NO  The datetime_on of the waveform row must be >= to this value 
datetime_off(PK)    NUMBER(25, 10)  NO  The datetime_off of the waveform row must be < to this value 
wcopy(PK)    NUMBER(10, 0)  NO  Copy number of the waveform file location. Used to distinguish between locations that contain a copy of the waveform file. The copy number should start from 1. The copy number does not indicate quality or any preference of one copy over another; it is used to just distinguish one copy from another 
fileroot    VARCHAR2(255)  NO  The top file directory of the waveform file. Subdirectories are allowed (i.e. /top_directory/subdirectory1/subdirectory2) but the top level must be included and it must be consistent with entries in SUBDIR 

Waveroots Primary and Unique Keys 
Key Name  Key Type  Keys 
PK5  PrimaryKey  archive, wavetype, status, net, wave_fmt, datetime_on, datetime_off, wcopy 

Waveroots Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 

Waveroots Check Constraints 
Check Constraint Name  CheckConstraint 
wfroot02  (wavetype in ('T','C')) 
wfroot03  (status in ('T','A')) 
wfroot04  (wave_fmt in (1,2,3,4)) 
wfroot01  (wcopy > 0)