fos_DataCore

11858 rows


Description

Is FosSahul data table. This table stores observations (= smallest datamodel intity) for the FosSahul compilation and is subordinate to the fos_Sample table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBSID1 text 2147483647 null
fos_polygons_EPSG3857.OBSID1 <--OBSID1_from_fos_DataCore_fkey R
SMPID text 2147483647 null
fos_Sample.SMPID <--SMPID_from_fos_Sample_fkey R
OBSID2 text 2147483647 √ null
LABID text 2147483647 √ null
IGSNID text 2147483647 √ null
LAB_ORIGID int2 5 √ null
cabah_LabCodes.LAB_ORIGID <--LAB_ORIGID_from_cabah_LabCodes_fkey R
FOS_MTDID int2 5 √ null
cabah_methodID.METHODID <--METHODID_from_CABAH_methodID_fkey R
FOS_MTDSID int2 5 √ null
fos_mtdsID.FOS_MTDSID <--MTDSID_from_fos_mtdsID_fkey R
VERID int2 5 √ null
global_dbDOI.VERID VERID_from_global_dbDOI_fkey R
REFDBID1 text 2147483647 null
global_RefCore.REFDBID <--REFDBID(1)_from_global_RefCore_fkey R
REFDBID2 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(2)_from_global_RefCore_fkey R
REFDBID3 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(3)_from_global_RefCore_fkey R
REFDBID4 text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID(4)_from_global_RefCore_fkey R
FOSMAT1ID int2 5 √ null
fos_fosmat1ID.FOSMAT1ID <--FOSMAT1ID_from_fos_fosmat1ID_fkey R
FOSMAT2ID int2 5 √ null
fos_fosmat2ID.FOSMAT2ID <--FOSMAT2ID_from_fos_fosmat2ID_fkey R
SPECIESID int2 5 √ null
fos_TaxRank6_speciesID.SPECIESID <--SPECIESID_from_fos_TaxRank6_fkey R
GENUSID int2 5 √ null
fos_TaxRank5_genusID.GENUSID <--GENUSID_from_fos_TaxRank5_fkey R
FAMILYID int2 5 √ null
fos_TaxRank4_familyID.FAMILYID <--FAMILYID_from_fos_TaxRank4_fkey R
ORDRID int2 5 √ null
fos_TaxRank3_ordrID.ORDRID <--ORDRID_from_fos_TaxRank3_fkey R
INFRACLAID int2 5 √ null
fos_TaxRank2_infraclaID.INFRACLAID <--INFRACLAID_from_fos_TaxRank2_fkey R
CLASSID int2 5 √ null
fos_TaxRank1_classID.CLASSID <--CLASSID_from_fos_TaxRank1_fkey R
STATUS varchar 7 √ null
MEGAFAUNA varchar 3 √ null
C14_CALIB varchar 3 √ null
PHYSCLEAN varchar 3 √ null
CONTAM varchar 8 √ null
CHEMTYPEID int2 5 √ null
fos_chemtypeID.CHEMTYPEID <--CHEMTYPEID_from_fos_chemtypeID_fkey R
CHEMPREPID int2 5 √ null
cabah_chemprepID.CHEMPREPID <--CHEMPREPID_from_cabah_chemprepID_fkey R
XTR_PROBLEM varchar 3 √ null
CN_RATIO numeric 0 √ null
PCT_N numeric 0 √ null
C14_XRDIFF varchar 3 √ null
AAR_T_HIST varchar 4 √ null
AAR_CLOSD varchar 3 √ null
AAR_UNCERT varchar 3 √ null
AAR_INCAL varchar 3 √ null
U_TH_PRE text 2147483647 √ null
U_TH_CLOSD varchar 3 √ null
U_TH_DCORR varchar 3 √ null
ESR_I_DR10 text 2147483647 √ null
ESR_GAMMA text 2147483647 √ null
ALIQ_TYPE varchar 2 √ null
BLEACH_STS text 2147483647 √ null
AGEMD_TRUE varchar 3 √ null
AGE numeric 0 √ null
AGE_ERR numeric 0 √ null
AGE_TYPE varchar 5 √ null
AGE_CI varchar 3 √ null
AGE_PREQ varchar 3 √ null
AGE_Q varchar 3 √ null
AGE_SUBQ varchar 6 √ null
AGE_ASSOC1 varchar 8 √ null
AGE_ASSOC2 text 2147483647 √ null
AGE_PREQ_R text 2147483647 √ null
AGE_Q_R text 2147483647 √ null
AGE_COMMT 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)
fos_DataCore_pkey Primary key Asc OBSID1

Relationships

Close relationships within degrees of separation