Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| siteid | int4 | 10 | null |
|
|
|||
| sitename | varchar | 128 | √ | null |
|
|
||
| longitudeeast | float8 | 17,17 | √ | null |
|
|
||
| latitudenorth | float8 | 17,17 | √ | null |
|
|
||
| longitudewest | float8 | 17,17 | √ | null |
|
|
||
| latitudesouth | float8 | 17,17 | √ | null |
|
|
||
| altitude | float8 | 17,17 | √ | null |
|
|
||
| area | float8 | 17,17 | √ | null |
|
|
||
| sitedescription | text | 2147483647 | √ | null |
|
|
||
| notes | text | 2147483647 | √ | null |
|
|
||
| recdatecreated | timestamp | 22 | timezone('UTC'::text, now()) |
|
|
|||
| recdatemodified | timestamp | 22 | null |
|
|
|||
| geog | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| sitestemp_pkey | Primary key | Asc | siteid |