analysisunits

356871 rows


Description

This table stores the data for Analysis Units.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
analysisunitid serial 10 nextval('ndb.seq_analysisunits_analysisunitid'::regclass)
accumulationrates.analysisunitid fk_accumulationrates_analysisunitsC
analysisunitaltdepths.analysisunitid fk_analysisunitaltdepths_analysisunitsC
analysisunitlithostrat.analysisunitid fk_analysisunitlithostrat_analysisunitsC
chroncontrols.analysisunitid fk_chroncontrols_analysisunitsR
depagents.analysisunitid fk_depagents_analysisunitsC
eventchronology.analysisunitid evc_aluR
relativechronology.analysisunitid fk_relativechronology_analysisunitsC
samples.analysisunitid fk_samples_analysisunitsR
tephras.analysisunitid fk_tephras_analysisunitsC
collectionunitid int4 10 null
collectionunits.collectionunitid fk_analysisunits_collectionunitsC
analysisunitname varchar 80 null
depth float8 17,17 null
thickness float8 17,17 null
faciesid int4 10 null
faciestypes.faciesid fk_analysisunits_faciestypesC
mixed bool 1 null
igsn varchar 40 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
analysisunits_pkey Primary key Asc analysisunitid
analysisunits_collunit_idx Performance Asc collectionunitid
analysisunits_facies_idx Performance Asc faciesid

Relationships