data_id

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | data_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_type

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents a datalogger type

Logical Attribute Properties

Logical Attribute Name | data_type
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a datalogger

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

firmware_nb

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute describes the firmware number of a datalogger

Logical Attribute Properties

Logical Attribute Name | firmware_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

software

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | Datalogger’s software (mshear, ushear, ...)

Logical Attribute Properties

Logical Attribute Name | software
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

software_nb

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | Datalogger’s software version number

Logical Attribute Properties

Logical Attribute Name | software_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_board

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of boards of a datalogger

Logical Attribute Properties

Logical Attribute Name | nb_board
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

word_32

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | The swap order in which 32-bit quantities are specified in the data headers

Logical Attribute Properties

Logical Attribute Name | word_32
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

word_16

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | 16-bit quantity byte swapping order, for the data headers only

Logical Attribute Properties

Logical Attribute Name | word_16
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_id

Base Entity | Datalogger_Board
Logical Rolename | data_id
RoleName | data_id
Domain |
Definition | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | data_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

board_nb

Base Entity | Datalogger_Board
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of boards of a datalogger

Logical Attribute Properties

Logical Attribute Name | board_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Datalogger_Board
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a datalogger board

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_module

Base Entity | Datalogger_Board
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of modules of a datalogger’s board

Logical Attribute Properties

Logical Attribute Name | nb_module
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

firmware_nb

Base Entity | Datalogger_Board
Logical Rolename |
RoleName |
Domain |
Definition | This attribute describes the firmware number of a datalogger

Logical Attribute Properties

Logical Attribute Name | firmware_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Datalogger_Board
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_id

Base Entity | Datalogger_Module
Logical Rolename | data_id
RoleName | data_id
Domain |
Definition | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | data_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

board_nb

Base Entity | Datalogger_Module
Logical Rolename | board_nb
RoleName | board_nb
Domain |
Definition | This attribute denotes the number of boards of a datalogger

Logical Attribute Properties

Logical Attribute Name | board_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

module_nb

Base Entity | Datalogger_Module
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the module number of a datalogger’s board

Logical Attribute Properties

Logical Attribute Name | module_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Datalogger_Module
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a datalogger module

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

firmware_nb

Base Entity | Datalogger_Module
Logical Rolename |
RoleName |
Domain |
Definition | This attribute describes the firmware number of a datalogger

Logical Attribute Properties

Logical Attribute Name | firmware_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensitivity

Base Entity | Datalogger_Module
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer

Logical Attribute Properties

Logical Attribute Name | sensitivity
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Datalogger_Module
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filamp_id

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | filamp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

name

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a descriptive name for a filter-amplifier

Logical Attribute Properties

Logical Attribute Name | name
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a filter-amplifier

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pchannel

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of physical channels of a datalogger

Logical Attribute Properties

Logical Attribute Name | nb_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Filamp
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filamp_id

Base Entity | Filamp_PChannel
Logical Rolename | filamp_id
RoleName | filamp_id
Domain |
Definition | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | filamp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pchannel_nb

Base Entity | Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a physical channel

Logical Attribute Properties

Logical Attribute Name | pchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

gain

Base Entity | Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the gain

Logical Attribute Properties

Logical Attribute Name | gain
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

frequency

Base Entity | Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | The frequency (fs) at which the value in sensitivity/gain is correct

Logical Attribute Properties

Logical Attribute Name | frequency
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqresp_id

Base Entity | Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqresp_id
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filter_id

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | filter_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

gain

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the gain

Logical Attribute Properties

Logical Attribute Name | gain
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

frequency

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | The frequency (fs) at which the value in sensitivity/gain is correct

Logical Attribute Properties

Logical Attribute Name | frequency
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

in_sp_rate

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | Sampling rate. This attribute is the input sample rate in samples/second

Logical Attribute Properties

Logical Attribute Name | in_sp_rate
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

out_sp_rate

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | Sampling rate. This attribute is the output sample rate in samples/second

Logical Attribute Properties

Logical Attribute Name | out_sp_rate
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offset

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor

Logical Attribute Properties

Logical Attribute Name | offset
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

delay

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | The estimated pure delay for the filter

Logical Attribute Properties

Logical Attribute Name | delay
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

correction

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done

Logical Attribute Properties

Logical Attribute Name | correction
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqresp_id

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqresp_id
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Filter
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

fir_id

Base Entity | Filter_FIR
Logical Rolename |
RoleName |
Domain |
Definition | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | fir_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

name

Base Entity | Filter_FIR
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a descriptive name for a FIR filter

Logical Attribute Properties

Logical Attribute Name | name
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

symmetry

Base Entity | Filter_FIR
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the eventual symmetry of a response

Logical Attribute Properties

Logical Attribute Name | symmetry
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

gain

Base Entity | Filter_FIR
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the gain

Logical Attribute Properties

Logical Attribute Name | gain
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Filter_FIR
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

fir_id

Base Entity | Filter_FIR_Data
Logical Rolename | fir_id
RoleName | fir_id
Domain |
Definition | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | fir_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

coeff_nb

Base Entity | Filter_FIR_Data
Logical Rolename |
RoleName |
Domain |
Definition | The numerator/denominator number

Logical Attribute Properties

Logical Attribute Name | coeff_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

type

Base Entity | Filter_FIR_Data
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes whether a value is associated with a numerator/denominator

Logical Attribute Properties

Logical Attribute Name | type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

coefficient

Base Entity | Filter_FIR_Data
Logical Rolename |
RoleName |
Domain |
Definition | The numerator/denominator coefficient value

Logical Attribute Properties

Logical Attribute Name | coefficient
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

error

Base Entity | Filter_FIR_Data
Logical Rolename |
RoleName |
Domain |
Definition | This attributes denotes the numerator/denominator error

Logical Attribute Properties

Logical Attribute Name | error
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqfil_id

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqfil_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

name

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a descriptive name for a chain of filters

Logical Attribute Properties

Logical Attribute Name | name
Datatype | VARCHAR(32)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_filter

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of filters of a sequence

Logical Attribute Properties

Logical Attribute Name | nb_filter
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

gain

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the gain

Logical Attribute Properties

Logical Attribute Name | gain
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

frequency

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | The frequency (fs) at which the value in sensitivity/gain is correct

Logical Attribute Properties

Logical Attribute Name | frequency
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Filter_Sequence
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqfil_id

Base Entity | Filter_Sequence_Data
Logical Rolename | seqfil_id
RoleName | seqfil_id
Domain |
Definition | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqfil_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filter_nb

Base Entity | Filter_Sequence_Data
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the filter number in a sequence

Logical Attribute Properties

Logical Attribute Name | filter_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filter_id

Base Entity | Filter_Sequence_Data
Logical Rolename | filter_id
RoleName | filter_id
Domain |
Definition | Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | filter_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqresp_id

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqresp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

resp_nb

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the response number of a sequence

Logical Attribute Properties

Logical Attribute Name | resp_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

resp_type

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the response type

Logical Attribute Properties

Logical Attribute Name | resp_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

resp_id

Base Entity | Response
Logical Rolename | resp_id
RoleName | resp_id
Domain |
Definition | Response identifier. Each response is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | hp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

unit_in

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system

Logical Attribute Properties

Logical Attribute Name | unit_in
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

unit_out

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts

Logical Attribute Properties

Logical Attribute Name | unit_out
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

r_type

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | A single character describing the type of response

Logical Attribute Properties

Logical Attribute Name | r_type
Datatype | VARCHAR(1)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Response
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

hp_id

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | hp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filter_type

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the type of a high-pass filter

Logical Attribute Properties

Logical Attribute Name | filter_type
Datatype | VARCHAR(2)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pole

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of poles of a high-pass filter

Logical Attribute Properties

Logical Attribute Name | nb_pole
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

corner_freq

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the corner frequency of a high-pass filter

Logical Attribute Properties

Logical Attribute Name | corner_freq
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

damping_value

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the fraction of critical damping of a high-pass filter

Logical Attribute Properties

Logical Attribute Name | damping_value
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Response_HP
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lp_id

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | lp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filter_type

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the type of a low-pass filter

Logical Attribute Properties

Logical Attribute Name | filter_type
Datatype | VARCHAR(2)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pole

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of poles of a low-pass filter

Logical Attribute Properties

Logical Attribute Name | nb_pole
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

corner_freq

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the corner frequency of a low-pass filter

Logical Attribute Properties

Logical Attribute Name | corner_freq
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

damping_value

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the fraction of critical damping of a low-pass filter

Logical Attribute Properties

Logical Attribute Name | damping_value
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Response_LP
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pn_id

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | pn_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

name

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a descriptive name for a polynomial

Logical Attribute Properties

Logical Attribute Name | name
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

poly_type

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the type of polynomial approximation

Logical Attribute Properties

Logical Attribute Name | poly_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lower_bound

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the polynomial lower bound

Logical Attribute Properties

Logical Attribute Name | lower_bound
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

upper_bound

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the polynomial upper bound

Logical Attribute Properties

Logical Attribute Name | upper_bound
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

max_error

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the maximum error of polynomial approximation

Logical Attribute Properties

Logical Attribute Name | max_error
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_coeff

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of polynomial coefficients

Logical Attribute Properties

Logical Attribute Name | nb_coeff
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Response_PN
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pn_id

Base Entity | Response_PN_Data
Logical Rolename | pn_id
RoleName | pn_id
Domain |
Definition | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | pn_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pn_nb

Base Entity | Response_PN_Data
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the coefficient number of a polynomial

Logical Attribute Properties

Logical Attribute Name | pn_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pn_value

Base Entity | Response_PN_Data
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the coefficient value of a polynomial

Logical Attribute Properties

Logical Attribute Name | pn_value
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pz_id

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | pz_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pz_nb

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the pole/zero number of a response

Logical Attribute Properties

Logical Attribute Name | pz_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

type

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes whether a value is associated with a pole/zero

Logical Attribute Properties

Logical Attribute Name | type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

r_value

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | The real portion of a complex pole/zero

Logical Attribute Properties

Logical Attribute Name | r_value
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

r_error

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | The error value for the real portion of a complex pole/zero

Logical Attribute Properties

Logical Attribute Name | r_error
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

i_value

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | The imaginary portion of a complex pole/zero

Logical Attribute Properties

Logical Attribute Name | i_value
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

i_error

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | The error value for the imaginary portion of a complex pole/zero

Logical Attribute Properties

Logical Attribute Name | i_error
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Response_PZ
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensor_id

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | sensor_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

name

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a descriptive name for a sensor

Logical Attribute Properties

Logical Attribute Name | name
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a sensor

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_component

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of components of a sensor

Logical Attribute Properties

Logical Attribute Name | nb_component
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensor_id

Base Entity | Sensor_Component
Logical Rolename | sensor_id
RoleName | sensor_id
Domain |
Definition | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | sensor_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

component_nb

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the component number

Logical Attribute Properties

Logical Attribute Name | component_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

channel_comp

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | Component channel

Logical Attribute Properties

Logical Attribute Name | channel_comp
Datatype | VARCHAR(2)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

component_type

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the component type

Logical Attribute Properties

Logical Attribute Name | component_type
Datatype | VARCHAR(1)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensitivity

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer

Logical Attribute Properties

Logical Attribute Name | sensitivity
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

frequency

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | The frequency (fs) at which the value in sensitivity/gain is correct

Logical Attribute Properties

Logical Attribute Name | frequency
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqresp_id

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqresp_id
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lat

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Logical Attribute Properties

Logical Attribute Name | lat
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lon

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Logical Attribute Properties

Logical Attribute Name | lon
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

elev

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Logical Attribute Properties

Logical Attribute Name | elev
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

staname

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Station name/description. This is the full name of the station whose code-name is in sta

Logical Attribute Properties

Logical Attribute Name | staname
Datatype | VARCHAR(50)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_sensor

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of sensors of a station

Logical Attribute Properties

Logical Attribute Name | nb_sensor
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_filamp

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of filter-amplifiers of a station

Logical Attribute Properties

Logical Attribute Name | nb_filamp
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_digi

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of digitizers of a station

Logical Attribute Properties

Logical Attribute Name | nb_digi
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_data

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of dataloggers of a station

Logical Attribute Properties

Logical Attribute Name | nb_data
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

datumhor

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Datum type for horizontal (latitude and longitude) coordinates

Logical Attribute Properties

Logical Attribute Name | datumhor
Datatype | VARCHAR(8)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

datumver

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Datum type for depth or elevation

Logical Attribute Properties

Logical Attribute Name | datumver
Datatype | VARCHAR(8)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Datalogger
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Datalogger
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_nb

Base Entity | Station_Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the datalogger number

Logical Attribute Properties

Logical Attribute Name | data_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Datalogger
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_id

Base Entity | Station_Datalogger
Logical Rolename | data_id
RoleName | data_id
Domain |
Definition | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | data_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pchannel

Base Entity | Station_Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of physical channels of a datalogger

Logical Attribute Properties

Logical Attribute Name | nb_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Datalogger
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Datalogger_LChannel
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Datalogger_LChannel
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_nb

Base Entity | Station_Datalogger_LChannel
Logical Rolename | data_nb
RoleName | data_nb
Domain |
Definition | This attribute represents the datalogger number

Logical Attribute Properties

Logical Attribute Name | data_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pchannel_nb

Base Entity | Station_Datalogger_LChannel
Logical Rolename | pchannel_nb
RoleName | pchannel_nb
Domain |
Definition | This attribute denotes a physical channel

Logical Attribute Properties

Logical Attribute Name | pchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lchannel_nb

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a logical channel of a datalogger

Logical Attribute Properties

Logical Attribute Name | lchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Datalogger_LChannel
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seqfil_id

Base Entity | Station_Datalogger_LChannel
Logical Rolename | seqfil_id
RoleName | seqfil_id
Domain |
Definition | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | seqfil_id
Datatype | NUMERIC(8, 0)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seedchan

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties

Logical Attribute Name | seedchan
Datatype | VARCHAR(3)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

channel

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Channel name

Logical Attribute Properties

Logical Attribute Name | channel
Datatype | VARCHAR(3)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

channelsrc

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)

Logical Attribute Properties

Logical Attribute Name | channelsrc
Datatype | VARCHAR(8)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

location

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties

Logical Attribute Name | location
Datatype | VARCHAR(2)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

rgain

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the gain at the response frequency

Logical Attribute Properties

Logical Attribute Name | rgain
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

rfrequency

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | The frequency (fs) at which the value in rgain is correct

Logical Attribute Properties

Logical Attribute Name | rfrequency
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

samprate

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Sampling rate. This attribute is the sample rate in samples/second

Logical Attribute Properties

Logical Attribute Name | samprate
Datatype | FLOAT
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

clock_drift

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series

Logical Attribute Properties

Logical Attribute Name | clock_drift
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

flags

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Channel flags

Logical Attribute Properties

Logical Attribute Name | flags
Datatype | VARCHAR(27)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_format

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the data format

Logical Attribute Properties

Logical Attribute Name | data_format
Datatype | VARCHAR(80)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

comp_type

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Compression type. A lookup key that refers to the Format Dictionary

Logical Attribute Properties

Logical Attribute Name | comp_type
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

unit_signal

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices

Logical Attribute Properties

Logical Attribute Name | unit_signal
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

unit_calib

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps

Logical Attribute Properties

Logical Attribute Name | unit_calib
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

block_size

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | The record length of the data

Logical Attribute Properties

Logical Attribute Name | block_size
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

remark

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications

Logical Attribute Properties

Logical Attribute Name | remark
Datatype | VARCHAR(30)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Datalogger_LChannel
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Datalogger_PChannel
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Datalogger_PChannel
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_nb

Base Entity | Station_Datalogger_PChannel
Logical Rolename | data_nb
RoleName | data_nb
Domain |
Definition | This attribute represents the datalogger number

Logical Attribute Properties

Logical Attribute Name | data_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pchannel_nb

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a physical channel

Logical Attribute Properties

Logical Attribute Name | pchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Datalogger_PChannel
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

board_type

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)

Logical Attribute Properties

Logical Attribute Name | board_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

channel_type

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)

Logical Attribute Properties

Logical Attribute Name | channel_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

seed_io

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the SEED instrument and orientation

Logical Attribute Properties

Logical Attribute Name | seed_io
Datatype | VARCHAR(2)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_lchannel

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of logical channels of a datalogger

Logical Attribute Properties

Logical Attribute Name | nb_lchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Datalogger_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Digitizer
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Digitizer
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

digi_nb

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the digitizer number

Logical Attribute Properties

Logical Attribute Name | digi_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Digitizer
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

serial_nb

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a serial number of a datalogger board

Logical Attribute Properties

Logical Attribute Name | serial_nb
Datatype | VARCHAR(80)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pri_pchannel

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of primary physical channels of a digitizer

Logical Attribute Properties

Logical Attribute Name | nb_pri_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_aux_pchannel

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of auxiliary physical channels of a digitizer

Logical Attribute Properties

Logical Attribute Name | nb_aux_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Digitizer
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Digitizer_PChannel
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Digitizer_PChannel
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

digi_nb

Base Entity | Station_Digitizer_PChannel
Logical Rolename | digi_nb
RoleName | digi_nb
Domain |
Definition | This attribute represents the digitizer number

Logical Attribute Properties

Logical Attribute Name | digi_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pchannel_nb

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a physical channel

Logical Attribute Properties

Logical Attribute Name | pchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Digitizer_PChannel
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_nb

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the datalogger number

Logical Attribute Properties

Logical Attribute Name | data_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

data_pchannel

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents a datalogger physical channel

Logical Attribute Properties

Logical Attribute Name | data_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

digi_type

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the digitizer type

Logical Attribute Properties

Logical Attribute Name | digi_type
Datatype | VARCHAR(3)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

digi_polarity

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the digitizer polarity

Logical Attribute Properties

Logical Attribute Name | digi_polarity
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

digi_channel

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents a digitizer module on a board

Logical Attribute Properties

Logical Attribute Name | digi_channel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Digitizer_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Filamp
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Filamp
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filamp_nb

Base Entity | Station_Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the filter-amplifier number

Logical Attribute Properties

Logical Attribute Name | filamp_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Filamp
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filamp_id

Base Entity | Station_Filamp
Logical Rolename | filamp_id
RoleName | filamp_id
Domain |
Definition | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | filamp_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_pchannel

Base Entity | Station_Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of physical channels of a datalogger

Logical Attribute Properties

Logical Attribute Name | nb_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Filamp
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Filamp
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Filamp_PChannel
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Filamp_PChannel
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

filamp_nb

Base Entity | Station_Filamp_PChannel
Logical Rolename | filamp_nb
RoleName | filamp_nb
Domain |
Definition | This attribute represents the filter-amplifier number

Logical Attribute Properties

Logical Attribute Name | filamp_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

pchannel_nb

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes a physical channel

Logical Attribute Properties

Logical Attribute Name | pchannel_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Filamp_PChannel
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_type

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware type

Logical Attribute Properties

Logical Attribute Name | next_hard_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_nb

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware number

Logical Attribute Properties

Logical Attribute Name | next_hard_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_pchannel

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware physical channel

Logical Attribute Properties

Logical Attribute Name | next_hard_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Filamp_PChannel
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Sensor
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Sensor
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensor_nb

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the sensor number

Logical Attribute Properties

Logical Attribute Name | sensor_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Sensor
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensor_id

Base Entity | Station_Sensor
Logical Rolename | sensor_id
RoleName | sensor_id
Domain |
Definition | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Logical Attribute Properties

Logical Attribute Name | sensor_id
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lat

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Logical Attribute Properties

Logical Attribute Name | lat
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lon

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Logical Attribute Properties

Logical Attribute Name | lon
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

elev

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Logical Attribute Properties

Logical Attribute Name | elev
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

edepth

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev

Logical Attribute Properties

Logical Attribute Name | edepth
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

nb_component

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the number of components of a sensor

Logical Attribute Properties

Logical Attribute Name | nb_component
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

datumhor

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Datum type for horizontal (latitude and longitude) coordinates

Logical Attribute Properties

Logical Attribute Name | datumhor
Datatype | VARCHAR(8)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

datumver

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Datum type for depth or elevation

Logical Attribute Properties

Logical Attribute Name | datumver
Datatype | VARCHAR(8)
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Sensor
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sta

Base Entity | Station_Sensor_Component
Logical Rolename | sta
RoleName | sta
Domain |
Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties

Logical Attribute Name | sta
Datatype | VARCHAR(6)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

net

Base Entity | Station_Sensor_Component
Logical Rolename | net
RoleName | net
Domain |
Definition | Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties

Logical Attribute Name | net
Datatype | VARCHAR(8)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

sensor_nb

Base Entity | Station_Sensor_Component
Logical Rolename | sensor_nb
RoleName | sensor_nb
Domain |
Definition | This attribute represents the sensor number

Logical Attribute Properties

Logical Attribute Name | sensor_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

component_nb

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute represents the component number

Logical Attribute Properties

Logical Attribute Name | component_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

ondate

Base Entity | Station_Sensor_Component
Logical Rolename | ondate
RoleName | ondate
Domain |
Definition | This attribute denotes the start date

Logical Attribute Properties

Logical Attribute Name | ondate
Datatype | DATE
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_type

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware type

Logical Attribute Properties

Logical Attribute Name | next_hard_type
Datatype | VARCHAR(1)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_nb

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware number

Logical Attribute Properties

Logical Attribute Name | next_hard_nb
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

next_hard_pchannel

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the next hardware physical channel

Logical Attribute Properties

Logical Attribute Name | next_hard_pchannel
Datatype | NUMERIC(8, 0)
Nullable | NO

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

azimuth

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | The azimuth of the instrument from north, clockwise

Logical Attribute Properties

Logical Attribute Name | azimuth
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

dip

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | The dip of the instrument, down from horizontal

Logical Attribute Properties

Logical Attribute Name | dip
Datatype | FLOAT
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

offdate

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | This attribute denotes the end date

Logical Attribute Properties

Logical Attribute Name | offdate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default |
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description

lddate

Base Entity | Station_Sensor_Component
Logical Rolename |
RoleName |
Domain |
Definition | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties

Logical Attribute Name | lddate
Datatype | DATE
Nullable | YES

Domain Restrictions

CheckConstraint |
Check Constraint Name |
Bound Rule |
Declared Default | (SYSDATE)
Bound Default |

Attachments

Name | Datatype | Value Override | Default Value | Description