| 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 Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| stanumber | NUMBER(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 | VARCHAR2(40) | YES | Geographic description of station location |
| stamapping Primary and Unique Keys |
| Key Name | Key Type | Keys |
| stamapkey01 | PrimaryKey | net, sta |
| stamapping Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
| stamapping Check Constraints |
| Check Constraint Name | CheckConstraint |
| stamap01 | stanumber > 0 |