stamapping

Logical Entity Name | stamapping
Default Table Name | stamapping
Definition |
    Provides geographic station location descriptions and maps station names to station numbers for the Strong-Motion

    Community

stamapping Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
net |  | VARCHAR(8) | NO |
    Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR(6) | NO |
    Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
stanumber |  | NUMERIC(8, 0) | NO |
    Station Number
lddate |  | DATE | YES |
    Load date. Date and time that the record was created or last modified, in Oracle date datat
locdescr |  | VARCHAR(40) | YES |
    Geographic description of station location

stamapping Keys

Key Name | Key Type | Keys
stamapkey01 | PrimaryKey | net, sta

stamapping Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

stamapping Check Constraints

Check Constraint Name | CheckConstraint
stamap01 | stanumber > 0