v_export_mega

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mega_megastructureid int4 10 √ null
tbl_megastructuredata.megastructureid Implied Constraint R
mega_projectid int4 10 √ null
tbl_projectdata.projectid Implied Constraint R
mega_citationgroupid int4 10 √ null
tbl_citationgroup.citationgroupid Implied Constraint R
mega_megasampleid_local varchar 255 √ null
mega_megasampleid_sesar varchar 255 √ null
mega_datesamplecollected date 13 √ null
mega_fieldbook varchar 255 √ null
mega_fieldbookpage varchar 50 √ null
mega_fieldwaypointname varchar 255 √ null
mega_latitude numeric 13,10 √ null
mega_longitude numeric 13,10 √ null
mega_elevation numeric 8,3 √ null
mega_supergroup varchar 255 √ null
mega_group varchar 255 √ null
mega_formation varchar 255 √ null
mega_member varchar 255 √ null
mega_timescaleage varchar 255 √ null
mega_geochronage varchar 255 √ null
mega_geochronageerror varchar 255 √ null
mega_geochronagebasis varchar 255 √ null
mega_megacomplete bool 1 √ null
mega_megaismacro bool 1 √ null
mega_linnaeanname varchar 255 √ null
mega_notes text 2147483647 √ null
mega_section_name varchar 255 √ null
mega_total_sect_thickness_m int4 10 √ null
mega_sample_height_in_section_m numeric 8,3 √ null
mega_megabuildupinterface varchar 255 √ null
mega_megabuilduptype varchar 255 √ null
mega_megadepositionalsetting varchar 255 √ null
mega_megahorizontalscale varchar 255 √ null
mega_megainitiation varchar 255 √ null
mega_megasedinterface varchar 255 √ null
mega_megasubstrate varchar 255 √ null
mega_megaverticalscale varchar 255 √ null
mega_lat_long geography 2147483647 √ null
mega_location_desc text 2147483647 √ null
mega_megalat_long_quality text 2147483647 √ null
mega_collectionid int4 10 √ null
tbl_collections.collectionid Implied Constraint R
mega_lithology text 2147483647 √ null
mega_megastructureshape text 2147483647 √ null
mega_microbialitetypes text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views