| 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 |
| 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 |