Database Properties
Database Type: PostgreSQL - 11.22
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| arch_c14_DataCore | 1 | 24 | 67 | 9501 | Table | Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model entity) for the SahulArch/ Radiocarbon collection and is subordinate to the |
| arch_c14_polygons_EPSG3857 | 0 | 1 | 6 | 9501 | Table | Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ Radiocarbon collection, EPSG:900913) |
| arch_featdatedID | 1 | 0 | 4 | 8 | Table | Is Sahul Archaeology (SahulArch) lookup table for specific features dated, where applicable (= FEATDATED) |
| arch_osl_DataCore | 1 | 20 | 90 | 973 | Table | Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model intity) for the SahulArch/ OSL collection and is subordinate to the |
| arch_osl_polygons_EPSG3857 | 0 | 1 | 6 | 973 | Table | Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ OSL collection , EPSG:900913) |
| arch_Sample | 3 | 2 | 13 | 10412 | Table | Is Sahul Archaeology (SahulArch) sample table. This table stores SahulArch samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the |
| arch_tl_DataCore | 1 | 20 | 88 | 240 | Table | Is Sahul Archaeology (SahulArch) data table. This table stores observations (= smallest data model intity) for the SahulArch/ TL collection and is subordinate to the |
| arch_tl_polygons_EPSG3857 | 0 | 1 | 6 | 240 | Table | Is Sahul Archaeology (SahulArch) spatial features table (polygons of the SahulArch/ TL collection , EPSG:900913) |
| c13_valID | 1 | 0 | 4 | 4 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for info whether delta13C was measured or assumed (= C13_VAL) |
| c14_calcurve | 1 | 1 | 6 | 0 | Table | The c14_calcurve table stores calibration curves used for radiocarbon age calibration. |
| c14_calprogram | 2 | 2 | 9 | 195 | Table | The c14_calprogram table stores computer programmes – incl. their versions – that may be used for radiocarbon calibration. |
| c14_contamID | 1 | 0 | 4 | 7 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for specific contaminants that may have remained after sample pretreatment (= CONTAM) |
| c14_hum_modID | 1 | 0 | 4 | 12 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for indications of human modification (= HUM_MOD) |
| c14_materia1ID | 1 | 0 | 5 | 11 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for type of sample material used for 14C dating (= MATERIAL1) |
| c14_materia2ID | 3 | 1 | 6 | 60 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for sub-type of sample material used for 14C dating (= MATERIAL2) |
| c14_solvent2ID | 1 | 0 | 5 | 10 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for solvent used (= SOLVENT2) |
| c_mtdID | 8 | 0 | 5 | 6 | Table | Is SahulArch/ Radiocarbon collection, i.e., SahulArch/ 14C lookup table for method used to determine element abundance/ ratio (= C_MTD, = PCT_C_MTD, = PCT_N_MTD, = CN_MTD, = C13_MTD, = O18_MTD, = N15_MTD, = S34_MTD) |
| cabah_agetypeID | 2 | 0 | 6 | 11 | Table | Is lookup table for radiocarbon-related compilations. The cabah_agetypeID table stores the type of time unit used for sample age specification. |
| cabah_AnalysisUnit | 1 | 3 | 12 | 15022 | Table | Is Neotoma-derived table for compilations dealing with analysis units, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_samples.html#analysisunits), stores analysis units, i.e., depth increments / bins that are considered analytical entities. Prior to db intake, this table has been filtered so it stores OCTOPUS relevant analysis units only. IMPORTANT NOTE: The primary key values have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these ID stays untouched. |
| cabah_basinsizeID | 1 | 0 | 5 | 6 | Table | Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores arbitrary water body area classes (basin = water body itself). |
| cabah_catchmentsizeID | 1 | 0 | 5 | 4 | Table | Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores arbitrary catchment area classes (catchment = area contributing to a certain basin). |
| cabah_charmethodID | 1 | 0 | 6 | 12 | Table | Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table stores the method of charcoal quantification. |
| cabah_chemprepID | 2 | 0 | 5 | 37 | Table | Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of chemical pretreatment given to an observation. Methods capture the majority of methods applied in Australia (= CHEMPREP). |
| cabah_chroncontroltypeID | 1 | 2 | 6 | 99 | Table | Is Neotoma-derived table for compilations dealing with chronologies, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_chron.html#chroncontroltypes), stores chronology control types. |
| cabah_col_mtdID | 7 | 1 | 5 | 44 | Table | Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the sample collection method (= COL_MTD). |
| cabah_datasourceID | 6 | 0 | 6 | 12 | Table | Is lookup table for Sahul-related compilations. The cabah_datasourceID table stores the way that data / information have been gathered for database integration. |
| cabah_depositID | 3 | 1 | 6 | 119 | Table | Is lookup table for Sahul-related compilations. The cabah_depositID table stores the type of deposit sampled. |
| cabah_ecolgroupID | 0 | 1 | 6 | 194 | Table | Is Neotoma-derived lookup table for compilations dealing with taxa, e.g. IPPD. This table, according Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#ecolgroups), stores ecological groups that facilitate subsequent data handling … Taxa are assigned to Sets of Ecological Groups. A taxon may be assigned to more than one Set of Ecological Groups, representing different schemes for organizing taxa … |
| cabah_flowtypeID | 1 | 0 | 5 | 6 | Table | Is lookup table for charcoal-related compilations, i.e., SahulCHAR. This table, according to the Global Paleofire Database (https://www.paleofire.org/) template, stores flow type descriptors for water bodies. |
| cabah_LabCodes | 7 | 0 | 10 | 353 | Table | Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores information about the lab of origin for a certain observation. Labs have been identified automatically by their distinct labcode prefixes. |
| cabah_methodID | 9 | 1 | 7 | 103 | Table | Is lookup table for Sahul-related compilations, i.e., SahulArch, FosSahul, SahulSed. This table stores the type of method used in age determination (= METHOD, = FOS_MTD). |
| cabah_taxagroupID | 1 | 1 | 6 | 56 | Table | Is Neotoma-derived lookup table for compilations dealing with taxa, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa), stores taxa groups … The TaxaGroupID facilitates rapid extraction of taxa groups that are typically grouped together for analysis. Some of these groups contain taxa in different classes or phyla. |
| cabah_taxaID | 3 | 3 | 14 | 47144 | Table | Is Neotoma-derived taxa table for compilations dealing with taxa, e.g. IPPD. This table, according to Neotoma db (https://neotoma-manual.readthedocs.io/en/latest/tables_taxa.html#taxa), stores taxa … IMPORTANT NOTE: Primary key (and, with the exception of “TAXAGRPID”, the other IDs too) have been migrated unaltered from Neotoma. Therefore, database relations will only work (and be updatable from the Neotoma source) if these IDs stay untouched. |
| cabah_unittypeID | 1 | 0 | 5 | 16 | Table | Is lookup table for compilations that involve collection units, i.e., SahulCHAR. This table, according to Neotoma’s IPPD template, stores collection unit types. |
| char_DataCore | 1 | 15 | 30 | 48234 | Table | Is Sahul Charcoal / Black Carbon (SahulChar) data table. This table stores observations (= smallest data model entity) for the SahulChar collection and is subordinate to the |
| char_Sample | 2 | 1 | 7 | 41793 | Table | Is Sahul Charcoal / Black Carbon (SahulChar) sample table. This table stores SahulChar samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the |
| crn_al_DataCore | 2 | 5 | 34 | 6091 | Table | Is CRN denudation data table. This table stores 26Al observations (= smallest data model entity) for CRN denudation and is subordinate to the |
| crn_alstndID | 2 | 0 | 8 | 26 | Table | Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores Al standards, correction factors, ratios and related information. |
| crn_amsID | 2 | 0 | 6 | 37 | Table | Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores information about Acceleration Mass Spectrometer (AMS) facilities. |
| crn_aus_basins | 0 | 3 | 96 | 297 | Table | Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/5WBX-N779. Table creation date: 2025-03-14 15:36:39 UTC |
| crn_aus_outlets | 0 | 1 | 5 | 297 | Table | Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/5WBX-N779. Tble creation date: 2025-03-14 15:36:42 UTC |
| crn_be_DataCore | 2 | 5 | 37 | 6091 | Table | Is CRN denudation data table. This table stores 10Be observations (= smallest data model entity) for CRN denudation and is subordinate to the |
| crn_bestndID | 2 | 0 | 8 | 60 | Table | Is lookup table for CRN compilations, i.e., CRN denudation and ExpAge. This table stores Be standards, correction factors, ratios and related information. |
| crn_inprep_basins | 0 | 2 | 44 | 157 | Table | Is flat GeoServer input table. Refer to https://doi.org/10.5281/zenodo.13369367. Table creation date: 2025-03-14 15:36:51 UTC |
| crn_inprep_outlets | 0 | 1 | 5 | 157 | Table | Is flat GeoServer input table. Refer to https://doi.org/10.5281/zenodo.13369367. Table creation date: 2025-03-14 15:36:54 UTC |
| crn_int_basins | 0 | 3 | 95 | 5376 | Table | Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/057R-TM53. Table creation date: 2025-03-14 15:37:03 UTC |
| crn_int_outlets | 0 | 1 | 5 | 5376 | Table | Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/057R-TM53. Table creation date: 2025-03-14 15:37:06 UTC |
| crn_projepsgID | 5 | 0 | 4 | 121 | Table | Is CRN denudation lookup table. This table stores study-specific projection information (EPSG and human readable), i.e., the particular UTM projected coordinate system used for calculations. |
| crn_Sample | 2 | 3 | 18 | 6039 | Table | Is CRN denudation sample table. This table stores CRN denudation samples and is, therefore, situated between the collection-specific DataCore tables (subordinate) and the |
| crn_studies_boundingbox | 2 | 1 | 5 | 301 | Table | Is CRN denudation spatial features table (polygons, EPSG:3857). Bounding boxes delimit study extents |