Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| FLDD_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the FLDD table |
|||
| FLDO_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||
| FLDD_LAT | DOUBLE | 22 | √ | null |
|
|
Latitude of displacement vector in WGS84 (deg) |
|||
| FLDD_LON | DOUBLE | 22 | √ | null |
|
|
Longitude of displacement vector in WGS84 (deg) |
|||
| FLDD_AZIM | FLOAT | 12 | √ | null |
|
|
Azimuth of displacement vector (i.e., clockwise vector angle from North) |
|||
| FLDD_HDIS | FLOAT | 12 | √ | null |
|
|
Horizontal displacement in m |
|||
| FLDD_VDIS | FLOAT | 12 | √ | null |
|
|
Vertical displacement in m (positive downward: settlement is positive) |
|||
| FLDD_METH | VARCHAR | 1000 | √ | null |
|
|
Method used to derive displacement vectors |
|||
| FLDD_REM | VARCHAR | 1000 | √ | null |
|
|
Remarks |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | FLDD_ID |
| FLDO_ID | Performance | Asc | FLDO_ID |
Relationships
Close relationships within degrees of separation
