Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| datasetid | int4 | 10 | √ | null |
|
|
||
| doi | varchar | 50 | √ | null |
|
|
||
| datasetname | varchar | 80 | √ | null |
|
|
||
| collectionunitid | int4 | 10 | √ | null |
|
|
||
| collunithandle | varchar | 10 | √ | null |
|
|
||
| collunitname | varchar | 255 | √ | null |
|
|
||
| datasettype | varchar | 64 | √ | null |
|
|
||
| colltype | varchar | 64 | √ | null |
|
|
||
| siteid | int4 | 10 | √ | null |
|
|
||
| altitude | float8 | 17,17 | √ | null |
|
|
||
| latitudesouth | float8 | 17,17 | √ | null |
|
|
||
| longitudewest | float8 | 17,17 | √ | null |
|
|
||
| latitudenorth | float8 | 17,17 | √ | null |
|
|
||
| longitudeeast | float8 | 17,17 | √ | null |
|
|
||
| contactid | int4 | 10 | √ | null |
|
|
||
| minage | float8 | 17,17 | √ | null |
|
|
||
| maxage | float8 | 17,17 | √ | null |
|
|
||
| ageyoungest | float8 | 17,17 | √ | null |
|
|
||
| ageoldest | float8 | 17,17 | √ | null |
|
|
||
| databasename | varchar | 80 | √ | null |
|
|
||
| geog | geography | 2147483647 | √ | null |
|
|