global_SiteCode

87 rows


Description

Is lookup table for global_SiteMaster table. global_SiteCode stores information about the site type characterising the dominant attribute of the sites, an information category that is related to SahulArch compilations only (= SITECODE).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SITECODEID smallserial 5 √ nextval('global_sitecode_seq'::regclass)
global_MetaSite.FEATURETYP <--SITECODEID_from_global_SiteCode_fkey R
global_SiteCode.PARENTID global_sitecode_fk R
global_SiteMaster.SITECODEID <--SITECODEID_from_global_SiteCode_fkey R
SITECODE text 2147483647 null
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC
UPDATED_AT timestamptz 35,6 √ timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC
PARENTID int2 5 √ null
global_SiteCode.SITECODEID global_sitecode_fk R
SITEDESCR text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
GLOBAL_SiteCode_pkey Primary key Asc SITECODEID

Relationships

Close relationships within degrees of separation