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 Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
archive(PK)    VARCHAR(8)  NO  This field specifies the place where the seismogram is archived - such as NCEDC/SCEDC 
wavetype(PK)    VARCHAR(2)  NO  This attribute denotes the type of waveform: (T)riggered or (C)ontinuous 
status(PK)    VARCHAR(2)  NO  This attribute denotes the status of the waveform in the file: (A)rchived or (T)emporary 
net(PK)    VARCHAR(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)    NUMERIC(2, 0)  NO  Waveform type - (numeric code for format mSEED, SAC, SEGY, ...) 
datetime_on(PK)    NUMERIC(25, 10)  NO  The datetime_on of the waveform row must be >= to this value 
datetime_off(PK)    NUMERIC(25, 10)  NO  The datetime_off of the waveform row must be < to this value 
wcopy(PK)    NUMERIC(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    VARCHAR(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 Keys 
Key Name  Key Type  Keys 
PK5  PrimaryKey  archive, wavetype, status, net, wave_fmt, datetime_on, datetime_off, wcopy 

Waveroots Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

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