Table: site

Comment: One row per site where a study was or is being conducted. One pair of geographic coordinates are designated to the entire site.

ColumnTypeComment
siteidinteger Auto Increment [nextval('site_siteid_seq')]Unique row identifier. The value of this column is automatically assigned by the system; the normal practice, which results in a system generated id, is to omit this column when inserting new rows or to supply a NULL value. The value of this column cannot be NULL.
namecharacter varying(64)The name of the site, which must be unique. This may be a short or a long name, depending on what the study uses.
latitudenumeric(7,3) NULLThe decimal latitude coordinate of the site, using positive and negative sign to indicate N and S, respectively.
longitudenumeric(7,3) NULLThe decimal longitude coordinate of the site, using positive and negative sign to indicate E and W, respectively.
geodetic_datumcharacter varying(12) NULL [WGS84]The geodetic system on which the geo-coordinates are based. For geo-coordinates measured between 1984 and 2010 this will typically be WGS84, which is the default value.

Indexes

PRIMARYsiteid
UNIQUEname

Foreign keys

Triggers

Language: