Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TEST_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the TEST table |
|||||||||||||||||||||||||||||||
| SITE_ID | INT UNSIGNED | 10 | √ | null |
|
|
||||||||||||||||||||||||||||||||
| TEST_NAME | VARCHAR | 64 | √ | null |
|
|
Test name |
|||||||||||||||||||||||||||||||
| TEST_TYPE | VARCHAR | 4 | √ | null |
|
|
Test type (i.e., Boring: BORH; Cone penetration testing: SCPG; Test pit: TEPT; Geophysical testing using surface wave: GSWG; Invasive geophysical testing: GINV) |
|||||||||||||||||||||||||||||||
| TEST_LAT | DOUBLE | 22 | √ | null |
|
|
Latitude of activity in decimal degree following WGS84 system |
|||||||||||||||||||||||||||||||
| TEST_LON | DOUBLE | 22 | √ | null |
|
|
Longitude of activity in decimal degree following WGS84 system |
|||||||||||||||||||||||||||||||
| TEST_REM | VARCHAR | 1000 | √ | null |
|
|
Remarks |
|||||||||||||||||||||||||||||||
| TEST_STAT | TINYINT | 3 | √ | null |
|
|
Upload status (1 = submitted / 0 = not submitted) |
|||||||||||||||||||||||||||||||
| TEST_REVW | TINYINT | 3 | √ | null |
|
|
Review status (1 = reviewed / 0 = not reviewed) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | TEST_ID |
| SITE_ID | Performance | Asc | SITE_ID |
Relationships
Close relationships within degrees of separation
