global_ibraID

90 rows


Description

Is parent table for global_SiteMaster table. The latter stores site related information for collection-dependent sample tables. global_ibraID stores information about the location of the site within the relevant bioregion as defined by the Interim Bio-Regionalisation of Australia (IBRA7) framework (= IBRACODE, IBRAREGION).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
IBRAID int2 5 null
global_SiteMaster.IBRAID <--IBRAID_from_global_ibraID_fkey R
IBRACODE varchar 3 null
IBRAREGION 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_ibraID_pkey Primary key Asc IBRAID
global_ibraid_IBRACODE_ukey Must be unique Asc IBRACODE
global_ibraid_IBRAREGION_ukey Must be unique Asc IBRAREGION

Relationships