site_native_land

48592 rows


Description

Linking SGP sites to dic_native_land. Last updated Aug 2024. Link to Native Land Digital now handled through SGP search website.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
site_id int4 10 null
site.site_id site_site_native_land_fk R

PK/FK. ID for site. Link to site table.
native_land_id int4 10 null
dic_native_land.native_land_id native_land_site_native_land_fk C

PK/FK. ID for territory. Link to dic_native_land.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
site_native_land_pkey Primary key Asc/Asc site_id + native_land_id

Relationships

Close relationships within degrees of separation