tbl_site_site_types

0 rows


Description

Associates sites with their site types and records the primary type, confidence, and notes for each assignment.

Columns

Column Type Size Nulls Auto Children Parents Comments
site_site_type_id int4 10 √

Primary key (automatically incremented).
site_id int4 10
tbl_sites.site_id tbl_site_site_types_site_id_fkey C

Identifies the site associated with this site type.
site_type_id int4 10
tbl_site_types.site_type_id tbl_site_site_types_site_type_id_fkey R

Identifies the site type assigned to this site.
is_primary_type bool 1

Indicates whether this is the primary site type assigned to the site.
confidence_code int2 5 √

Optional confidence rating for the site type assignment: 1=high, 2=medium, 3=low.
notes text 2147483647 √

Additional notes about assigning this site type to the site.

Indexes

Constraint Name Type Sort Column(s)
tbl_site_site_types_pkey Primary key Asc site_site_type_id
uq_site_type_per_site Must be unique Asc/Asc site_id + site_type_id

Relationships

Close relationships within degrees of separation