phase1_v2.1 Database

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Auto	Default	Comments
analyte_determination	Table	abundance	numeric	17	√		null	Measured result
affiliation	Table	address	varchar	255	√		null	Street address of the person
affiliation	Table	affiliation_id	serial	10		√	nextval('affiliation_affiliation_id_seq'::regclass)	PK. Unique ID for each affiliation. Generated by database.
geol_age	Table	age_id	serial	10		√	nextval('geol_age_age_id_seq'::regclass)	PK. Unique identifier for the reported age. Generated by database
geol_context	Table	age_id	int4	10	√		null	FK. ID for the geological age. Links to the geol_age table.
geol_age	Table	age_modifier	varchar	10	√		null	Upper, middle,lower - where not part of the official ICS name.
geol_age	Table	age_notes	varchar	4000	√		null	Notes about how the age was determined.
alternate_num	Table	alternate_num	varchar	50			null	PK/FK. Alternate sample number/name. Part of a composite primary key in this table along with sample_id. Note that alternate_num is not always unique
dic_ana_method	Table	ana_method_code	varchar	20			null	Code for analytical method e.g. XRF, ICP:MS etc. Based in part on the list used by EarthChem
dic_ana_method	Table	ana_method_desc	varchar	255	√		null	Detailed description of the method
dic_ana_method	Table	ana_method_id	serial	10		√	nextval('dic_analysis_method_method_id_seq'::regclass)	PK. Unique ID. Generated by the database.
analysis	Table	ana_method_id	int4	10	√		null	FK. ID for each analytical method used e.g. ICP:MS. Links to the dic_ana_method table.
dic_ana_method	Table	ana_method_translation	varchar	100			null	General description of the method
analyte_determination_limits	Table	analysis_id	int4	10			null	FK. ID for each analysis record. Links to analysis table.
analysis	Table	analysis_id	serial	10		√	nextval('analysis_analysis_id_seq'::regclass)	PK. Unique ID for each analysis record for each batch. Generated by database.
analysis	Table	analysis_notes	varchar	4000	√		null	Detailed description of the analysis. Often cut-and-paste from the methods section for published data.
analyte_determination_limits	Table	analyte_code	varchar	200			null
dic_analyte	Table	analyte_code	varchar	100			null	PK. Unique identifier for each geochemical analyte. Chemical symbol or accepted code e.g. FeT, Fe-carb, 34S-CAS etc.
dic_analyte	Table	analyte_desc	varchar	255	√		null	Longer description of the analyte e.g. Carbonate-associated iron (e.g. iron in siderite, iron in ankerite), extracted as the first step in a sequential extraction (method SeqA)
analyte_determination	Table	analyte_det_id	serial	10		√	nextval('analyte_determination_analyte_det_id_seq'::regclass)	PK. Unique ID for each analytical result. Generated by database.
dic_analyte	Table	analyte_translation	varchar	100	√		null	Short description of the analyte e.g. Iron, Carbonate-associated iron etc.
reference_work	Table	article_num	varchar	100	√		null
dic_lithostrat	Table	asud_stratno	int4	10	√		null	Identifier from the Australian Stratigraphic Units Database (ASUD, https://asud.ga.gov.au/)
dic_analyte	Table	atomic_num	int4	10	√		null	Atomic number for those analytes that are chemical elements
author	Table	author_id	serial	10		√	nextval('author_author_id_seq'::regclass)	PK. Unique ID for each author. Generated by the database
author	Table	author_position	int4	10	√		null	The position of the author in the author list
dic_lithostrat	Table	b_age	numeric	12	√		null	From Macrostrat: number, continuous time age model estimated for initiation, in Myr before present
site	Table	basin_id	int4	10	√		null	FK. ID for the sedimentary basin. Links to the basin table.
basin	Table	basin_id	serial	10		√	nextval('basin_basin_id_seq'::regclass)	PK. Unique ID for a basin. Generated by the database.
basin	Table	basin_name	varchar	100	√		null	Name for the basin eg. McArthur Basin
basin	Table	basin_notes	varchar	4000	√		null	Notes about the basin
dic_basin_type	Table	basin_type	varchar	100			null	Basin type, e.g. rift, peripheral foreland etc.
dic_basin_type	Table	basin_type_id	serial	10		√	nextval('dic_basin_type_basin_type_id_seq'::regclass)	PK. Unique identifier. Generated by the database
basin	Table	basin_type_id	int4	10	√		null	FK. ID for the basin type. Links to dic_basin_type table.
batch	Table	batch_id	serial	10		√	nextval('batch_batch_id_seq'::regclass)	PK. Unique ID for a batch. Generated by the database.
analysis	Table	batch_id	int4	10			null	FK. Identifier for the batch. Links to the batch table
analyte_determination	Table	batch_id	int4	10			null	FK. ID for a batch. Links to the batch_sample table.
batch_sample	Table	batch_id	int4	10			null	PK/FK. ID for a batch. Links to the batch table. Part of composite primary key.
data_source_batch	Table	batch_id	int4	10			null	PK/FK. ID for the batch. Links to the batch table. Part of composite primary key.
batch	Table	batch_notes	varchar	4000			null	Brief description of the batch
dic_lithostrat	Table	bed	varchar	100	√		null	From Macrostrat: string, the strat_name of the bed
dic_lithostrat	Table	bed_id	int4	10	√		null	From Macrostrat: integer, the strat_name_id of the bed
dic_lithostrat	Table	bgs_code	varchar	10	√		null	Identifier from the BGS Lexicon of Named Rock Units (https://www.bgs.ac.uk/Lexicon/). Older BGS codes are numerical
dic_meta	Table	biomarkers	varchar	2147483647	√		null	Whether biomarkers are preserved
geol_context	Table	biostrat_id	int4	10	√		null	FK. ID for the biostratigraphy. Links to the biostrat table.
biostrat	Table	biostrat_id	serial	10		√	nextval('biostrat_biostrat_id_seq'::regclass)	PK. Unique ID for a biostratigraphic designation. Generated by the database.
biostrat	Table	biostrat_notes	varchar	4000	√		null
dic_biostrat	Table	biozone_fossil_type	varchar	100	√		null	Type of organism used to define the zone - graptolite, trilobite etc.
dic_biostrat	Table	biozone_name	varchar	255	√		null	Name of the biozone
reference_work	Table	book_title	varchar	1000	√		null	Title of book.

Showing 1 to 50 of 458 entries