sitegeopolitical

49046 rows


Description

This table lists the GeoPolitical units in which sites occur.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sitegeopoliticalid serial 10 nextval('ndb.seq_sitegeopolitical_sitegeopoliticalid'::regclass)

An arbitrary Site GeoPolitical identification number.

siteid int4 10 null
sites.siteid fk_sitegeopolitical_sitesC

Site identification number. Field links to the Sites table.

geopoliticalid int4 10 null
geopoliticalunits.geopoliticalid fk_sitegeopolitical_geopoliticalunitsR

GeoPolitical identification number. Field links to the GeoPoliticalUnits lookup table.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
sitegeopolitical_pkey Primary key Asc sitegeopoliticalid
ix_geopoliticalid_sitegeopolitical Performance Asc geopoliticalid
ix_siteid_sitegeopolitical Performance Asc siteid

Relationships