dic_native_land

601 rows


Description

Territories from Native Land Digital for SGP sites, from API by position. See https://api-docs.native-land.ca/ Now handled live on SGP search website.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
native_land_id int4 10 null
site_native_land.native_land_id native_land_site_native_land_fk C
native_land_name varchar 4000 null

Name of territory
native_land_type varchar 500 √ null

Type (all = Feature)
native_land_slug varchar 4000 √ null

URL slug
native_land_description varchar 4000 √ null

Native land URL
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
native_land_id Primary key Asc native_land_id

Relationships

Close relationships within degrees of separation