tbl_sites

3462 rows


Description

The ‘tbl_sites’ table records detailed information about each excavation or sampling location, referred to as a Site, in the SEAD database. Sites are organized into Sample Sets to construct environmental pre- and historical data records.

Columns

Column Type Size Nulls Auto Children Parents Comments
site_id int4 10 √
tbl_sample_groups.site_id fk_sample_groups_site_id R
tbl_site_images.site_id fk_site_images_site_id R
tbl_site_locations.site_id fk_locations_site_id R
tbl_site_natgridrefs.site_id fk_site_natgridrefs_sites_id R
tbl_site_other_records.site_id fk_site_other_records_site_id R
tbl_site_preservation_status.site_id fk_site_preservation_status_site_id R
tbl_site_references.site_id fk_site_references_site_id R

Primary key (automatically incremented).
altitude numeric(18,10) 18,10 √

The altitude of the site in meters above sea level.
latitude_dd numeric(18,10) 18,10 √

The latitude of the site in decimal degrees.
longitude_dd numeric(18,10) 18,10 √

The longitude of the site in decimal degrees.
national_site_identifier varchar(255) 255 √

A unique identifier assigned to the site by the national authority.
site_description text 2147483647 √

A detailed description of the site’s characteristics and significance.
site_name varchar(60) 60 √

The official or commonly used name of the site.
site_preservation_status_id int4 10 √
tbl_site_preservation_status.site_preservation_status_id fk_site_preservation_status_site_preservation_status_id R

Specifies the preservation status of the site, indicating its current condition.
date_updated timestamptz 35,6 √
site_location_accuracy varchar 2147483647 √

Describes the accuracy of the site’s location resolution, such as ‘Nearest settlement’, ‘Lake’, ‘Bog’, ‘Ancient monument’, or ‘Approximate’.
site_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_sites_pkey Primary key Asc site_id
pk_tbl_sites Must be unique Asc site_uuid

Relationships

Close relationships within degrees of separation