tbl_megastructuredata

160 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
megastructureid serial 10 √ nextval('"tbl_MegastructureData_megastructureID_seq"'::regclass)
ann_megatrait_observation_quality.megastructureid fk_megatrait_quality_parent C
jtbl_megastructure_geologicage.megastructureid Implied Constraint R
jtbl_tlkpmegalithology.megastructureid fk_junct_megastructure R
jtbl_tlkpmegamegastructureshape.megastructureid fk_junct_megastructure R
jtbl_tlkpmegamicrobialitetypes.megastructureid fk_junct_megastructure R
tbl_macrostructuredata.megastructureid fk_megastructure_macrostructure N
tbl_photolinksdata.megastructureid fk_photolinks_megastructure N
v_export_macro.macro_megastructureid Implied Constraint R
v_export_master.macro_megastructureid Implied Constraint R
v_export_master.mega_megastructureid Implied Constraint R
v_export_mega.mega_megastructureid Implied Constraint R
projectid int4 10 √ null
tbl_projectdata.projectid fk_megastructure_projectID N
citationgroupid int4 10 √ null
tbl_citationgroup.citationgroupid Implied Constraint R
megasampleid_local varchar 255 √ null
megasampleid_sesar varchar 255 √ null
datesamplecollected date 13 √ null
fieldbook varchar 255 √ null
fieldbookpage varchar 50 √ null
fieldwaypointname varchar 255 √ null
latitude numeric 13,10 √ null
longitude numeric 13,10 √ null
elevation numeric 8,3 √ null
supergroup varchar 255 √ null
group varchar 255 √ null
formation varchar 255 √ null
member varchar 255 √ null
timescaleage varchar 255 √ null
geochronage varchar 255 √ null
geochronageerror varchar 255 √ null
geochronagebasis varchar 255 √ null
megacomplete bool 1 √ null
megaismacro bool 1 √ null
linnaeanname varchar 255 √ null
notes text 2147483647 √ null
section_name varchar 255 √ null
total_sect_thickness_m int4 10 √ null
sample_height_in_section_m numeric 8,3 √ null
megabuildupinterfaceid int4 10 √ null
tlkpmegabuildupinterface.valueid fk_buildupInterface_Lookup R
megabuilduptypeid int4 10 √ null
tlkpmegabuilduptype.valueid fk_buildupType_Lookup R
megadepositionalsettingid int4 10 √ null
tlkpmegadepositionalsetting.valueid fk_depSetting_Lookup R
megahorizontalscaleid int4 10 √ null
tlkpmegahorizontalscale.valueid fk_horScale_Lookup R
megainitiationid int4 10 √ null
tlkpmegainitiation.valueid fk_initiation_Lookup R
megasedinterfaceid int4 10 √ null
tlkpmegasedinterface.valueid fk_sedInterface_Lookup R
megasubstrateid int4 10 √ null
tlkpmegasubstrate.valueid fk_substrate_Lookup R
megaverticalscaleid int4 10 √ null
tlkpmegaverticalscale.valueid fk_vertScale_Lookup R
lat_long geography 2147483647 √ null
location_desc text 2147483647 √ null
megalat_long_qualityid int4 10 √ null
collectionid int4 10 √ null
tbl_collections.collectionid Implied Constraint R
megainterpretedage numeric 0 √ null
megainterpretedageunitid int4 10 √ null
tlkpmegaageunit.valueid fk_megastructure_age_unit R
megainterpretedagequalifierid int4 10 √ null
tlkpmegaagequalifier.valueid fk_megastructure_age_qualifier R
megaageinterpretationbasisid int4 10 √ null
tlkpmegaageinterpretationbasis.valueid fk_megastructure_age_basis R
megaageconfidenceid int4 10 √ null
tlkpmegaageconfidence.valueid fk_megastructure_age_confidence R
megaageinterpretationnotes text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_MegastructureData_pkey Primary key Asc megastructureid

Check Constraints

Constraint Name Constraint
chk_megastructure_interpreted_age_pair (((megainterpretedage IS NULL) AND (megainterpretedageunitid IS NULL)) OR ((megainterpretedage IS NOT NULL) AND (megainterpretedageunitid IS NOT NULL)))

Relationships

Close relationships within degrees of separation