cabah_datasourceID

11 rows


Description

Is lookup table for Sahul-related compilations. The cabah_datasourceID table stores the way that data / information have been gathered for database integration.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
DATASRCID serial 10 √ nextval('"cabah_datasourceID_DATASRCID_seq"'::regclass)
cabah_ecolgroupID.ECOGRPSRC <--DATASRCID_from_cabah_datasourceID_fkey R
cabah_taxagroupID.TXAGRPSRC <--DATASRCID_from_cabah_datasourceID_fkey R
char_DataCore.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R
global_DataSetMaster.DSETSOURCE <--DATASRCID_from_cabah_datasourceID_fkey R
global_MetaSite.FEATURESRC <--DATASRCID_from_cabah_datasourceID_fkey R
neo_elementtypes.DATASRCID <--DATASRCID_from_cabah_datasourceID_fkey R
DATASOURCE text 2147483647 null
DATASRCDSC text 2147483647 √ null
DATASRCREF 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

Indexes

Constraint Name Type Sort Column(s)
cabah_datasourceID_pkey Primary key Asc DATASRCID
cabah_datasourceID_DATASOURCE_key Must be unique Asc DATASOURCE

Relationships

Close relationships within degrees of separation