Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SITE_ID | INT UNSIGNED | 10 | √ | null |
|
|
Unique ID (primary key) for entries in the SITE table |
|||||||||||||
| SITE_NAME | VARCHAR | 1000 | √ | null |
|
|
Site name |
|||||||||||||
| SITE_LAT | DOUBLE | 22 | √ | null |
|
|
Latitude of the site (e.g., center of the site) in decimal degree following WGS84 system |
|||||||||||||
| SITE_LON | DOUBLE | 22 | √ | null |
|
|
Longitude of the site (e.g., center of the site) in decimal degree following WGS84 system |
|||||||||||||
| SITE_GEOL | VARCHAR | 1000 | √ | null |
|
|
Description of surface geology. If available, indicate geology unit(s). |
|||||||||||||
| SITE_REM | VARCHAR | 1000 | √ | null |
|
|
Remarks |
|||||||||||||
| SITE_STAT | TINYINT | 3 | √ | null |
|
|
Upload status (1 = submitted / 0 = not submitted) |
|||||||||||||
| SITE_REVW | TINYINT | 3 | √ | null |
|
|
Review status (1 = reviewed / 0 = not reviewed) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | SITE_ID |
Relationships
Close relationships within degrees of separation
