Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLDO_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the FLDO table |
|||||||||||||||||
| EVNT_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||||||||||
| SITE_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||||||||||
| FLDO_DESC | VARCHAR | 5000 | √ | null |
|
|
Liquefaction manifestation (or lack thereof) description |
|||||||||||||||||
| FLDO_STAT | TINYINT | 3 | √ | null |
|
|
FLDO upload status (1 = submitted / 0 = not submitted) |
|||||||||||||||||
| FLDO_REVW | TINYINT | 3 | √ | null |
|
|
FLDO review status (1 = reviewed / 0 = not reviewed) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | FLDO_ID |
| EVNT_ID | Performance | Asc | EVNT_ID |
| SITE_ID | Performance | Asc | SITE_ID |
Relationships
Close relationships within degrees of separation
