Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| SEGM_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the SEGM table |
|||
| EVNT_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| SEGM_NAME | VARCHAR | 100 | √ | null |
|
|
Name of the segment/fault |
|||
| SEGM_LENGTH | FLOAT | 12 | √ | null |
|
|
Segment Length (km) |
|||
| SEGM_WIDTH | FLOAT | 12 | √ | null |
|
|
Segment Width (km) |
|||
| SEGM_STRIKE | FLOAT | 12 | √ | null |
|
|
Segment Strike (deg) |
|||
| SEGM_DIP | FLOAT | 12 | √ | null |
|
|
Segment Dip (deg) |
|||
| SEGM_RAKE | FLOAT | 12 | √ | null |
|
|
Segment Rake (deg) |
|||
| ULC_LAT | DOUBLE | 22 | √ | null |
|
|
Latitude of the Upper Left Corner (ULC) (deg) |
|||
| ULC_LON | DOUBLE | 22 | √ | null |
|
|
Longitude of the Upper Left Corner (ULC) (deg) |
|||
| ULC_DEPTH | FLOAT | 12 | √ | null |
|
|
Depth of the Upper Left Corner (ULC) (km) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | SEGM_ID |
| EVNT_ID | Performance | Asc | EVNT_ID |
Relationships
Close relationships within degrees of separation
