v_export_master

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

project_projectid

int4

√

null

tbl_projectdata.projectid

Implied Constraint

project_projectname

varchar

255

√

null

project_principalinvestigator

varchar

255

√

null

project_siteorlocationname

varchar

255

√

null

project_startdate

date

√

null

project_enddate

date

√

null

project_instrumentsused

varchar

255

√

null

project_orcid

varchar

255

√

null

project_otherteammembers

varchar

255

√

null

project_areaofinterest

varchar

255

√

null

project_purposeofstudy

varchar

255

√

null

project_fundingsource

varchar

255

√

null

project_grantid

varchar

255

√

null

project_projecttectonicsetting

varchar

255

√

null

mega_megastructureid

int4

√

null

tbl_megastructuredata.megastructureid

Implied Constraint

mega_projectid

int4

√

null

tbl_projectdata.projectid

Implied Constraint

mega_citationgroupid

int4

√

null

tbl_citationgroup.citationgroupid

Implied Constraint

mega_megasampleid_local

varchar

255

√

null

mega_megasampleid_sesar

varchar

255

√

null

mega_datesamplecollected

date

√

null

mega_fieldbook

varchar

255

√

null

mega_fieldbookpage

varchar

√

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

√

null

mega_megaismacro

bool

√

null

mega_linnaeanname

varchar

255

√

null

mega_notes

text

2147483647

√

null

mega_section_name

varchar

255

√

null

mega_total_sect_thickness_m

int4

√

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

√

null

tbl_collections.collectionid

Implied Constraint

mega_lithology

text

2147483647

√

null

mega_megastructureshape

text

2147483647

√

null

mega_microbialitetypes

text

2147483647

√

null

macro_macrostructureid

int4

√

null

tbl_macrostructuredata.macrostructureid

Implied Constraint

macro_megastructureid

int4

√

null

tbl_megastructuredata.megastructureid

Implied Constraint

macro_sampleid

varchar

255

√

null

macro_macroismeso

bool

√

null

macro_sampleid_sesar

varchar

255

√

null

macro_macrocomplete

bool

√

null

macro_macroaspectratio

varchar

255

√

null

macro_macroattitude

varchar

255

√

null

macro_macrogrowthvariability

varchar

255

√

null

macro_macrolinkage

varchar

255

√

null

macro_macrospacing

varchar

255

√

null

macro_macrosampleid_local

text

2147483647

√

null

macro_branchingmode

text

2147483647

√

null

macro_branchingstyle

text

2147483647

√

null

macro_columnshape

text

2147483647

√

null

macro_conicalshapes

text

2147483647

√

null

macro_divergenceangle

text

2147483647

√

null

macro_domeshape

text

2147483647

√

null

macro_layershape

text

2147483647

√

null

macro_planview

text

2147483647

√

null

macro_shape

text

2147483647

√

null

meso_mesostructureid

int4

√

null

tbl_mesostructuredata.mesostructureid

Implied Constraint

meso_macrostructureid

int4

√

null

tbl_macrostructuredata.macrostructureid

Implied Constraint

meso_sampleid

varchar

√

null

meso_sampleid_sesar

varchar

√

null

meso_mesolamthickness

varchar

255

√

null

meso_mesowavelength

varchar

255

√

null

meso_notes

text

2147483647

√

null

meso_infru

bool

√

null

meso_researcheranalyst

varchar

255

√

null

meso_mesocomplete

bool

√

null

meso_mesoclothierarchy

varchar

255

√

null

meso_mesolaminainheritance

varchar

255

√

null

meso_mesolatcontinuity

varchar

255

√

null

meso_mesomodalityskewness

varchar

255

√

null

meso_mesosynopticrelief

varchar

255

√

null

meso_mesowalls

varchar

255

√

null

meso_mesosampleid_local

text

2147483647

√

null

meso_alternation

text

2147483647

√

null

meso_architecture

text

2147483647

√

null

meso_clotshape

text

2147483647

√

null

meso_graintypes

text

2147483647

√

null

meso_lampattern

text

2147483647

√

null

meso_lamprofile

text

2147483647

√

null

meso_lamwaviness

text

2147483647

√

null

meso_macrolaminae

text

2147483647

√

null

meso_oncoidflattening

text

2147483647

√

null

meso_oncoids

text

2147483647

√

null

meso_oncoidshape

text

2147483647

√

null

meso_stackingoverlap

text

2147483647

√

null

meso_types

text

2147483647

√

null

micro_microstructureid

int4

√

null

tbl_microstructuredata.microstructureid

Implied Constraint

micro_mesostructureid

int4

√

null

tbl_mesostructuredata.mesostructureid

Implied Constraint

micro_sampleid

varchar

255

√

null

micro_subsample

varchar

255

√

null

micro_porositypercentest

varchar

255

√

null

micro_cementfilledporosity

varchar

255

√

null

micro_micronotes

text

2147483647

√

null

micro_microsampleid_local

text

2147483647

√

null

micro_microsampleid_sesar

text

2147483647

√

null

micro_microreferenceimage

varchar

255

√

null

micro_microcomplete

bool

√

null

micro_txtmicronotes

text

2147483647

√

null

micro_microwentworth

text

2147483647

√

null

micro_micropercentclastics

text

2147483647

√

null

micro_carbonategrains

text

2147483647

√

null

micro_cementtypes

text

2147483647

√

null

micro_clasticgrains

text

2147483647

√

null

micro_microfacies

text

2147483647

√

null

micro_mineralogy

text

2147483647

√

null

micro_porositydirection

text

2147483647

√

null

micro_porosityprocess

text

2147483647

√

null

micro_porositysize

text

2147483647

√

null

micro_porositytypes

text

2147483647

√

null

micro_texturetypes

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH mega_lithology AS (
         SELECT j.megastructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS mega_lithology
           FROM (jtbl_tlkpmegalithology j
             JOIN tlkpmegalithology l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.megastructureid
        ), mega_megastructureshape AS (
         SELECT j.megastructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS mega_megastructureshape
           FROM (jtbl_tlkpmegamegastructureshape j
             JOIN tlkpmegamegastructureshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.megastructureid
        ), mega_microbialitetypes AS (
         SELECT j.megastructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS mega_microbialitetypes
           FROM (jtbl_tlkpmegamicrobialitetypes j
             JOIN tlkpmegamicrobialitetypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.megastructureid
        ), macro_branchingmode AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_branchingmode
           FROM (jtbl_tlkpmacrobranchingmode j
             JOIN tlkpmacrobranchingmode l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_branchingstyle AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_branchingstyle
           FROM (jtbl_tlkpmacrobranchingstyle j
             JOIN tlkpmacrobranchingstyle l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_columnshape AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_columnshape
           FROM (jtbl_tlkpmacrocolumnshape j
             JOIN tlkpmacrocolumnshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_conicalshapes AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_conicalshapes
           FROM (jtbl_tlkpmacroconicalshapes j
             JOIN tlkpmacroconicalshapes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_divergenceangle AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_divergenceangle
           FROM (jtbl_tlkpmacrodivergenceangle j
             JOIN tlkpmacrodivergenceangle l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_domeshape AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_domeshape
           FROM (jtbl_tlkpmacrodomeshape j
             JOIN tlkpmacrodomeshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_layershape AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_layershape
           FROM (jtbl_tlkpmacrolayershape j
             JOIN tlkpmacrolayershape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_planview AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_planview
           FROM (jtbl_tlkpmacroplanview j
             JOIN tlkpmacroplanview l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), macro_shape AS (
         SELECT j.macrostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS macro_shape
           FROM (jtbl_tlkpmacroshape j
             JOIN tlkpmacroshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.macrostructureid
        ), meso_alternation AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_alternation
           FROM (jtbl_tlkpmesoalternation j
             JOIN tlkpmesoalternation l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_architecture AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_architecture
           FROM (jtbl_tlkpmesoarchitecture j
             JOIN tlkpmesoarchitecture l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_clotshape AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_clotshape
           FROM (jtbl_tlkpmesoclotshape j
             JOIN tlkpmesoclotshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_graintypes AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_graintypes
           FROM (jtbl_tlkpmesograintypes j
             JOIN tlkpmesograintypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_lampattern AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_lampattern
           FROM (jtbl_tlkpmesolampattern j
             JOIN tlkpmesolampattern l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_lamprofile AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_lamprofile
           FROM (jtbl_tlkpmesolamprofile j
             JOIN tlkpmesolamprofile l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_lamwaviness AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_lamwaviness
           FROM (jtbl_tlkpmesolamwaviness j
             JOIN tlkpmesolamwaviness l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_macrolaminae AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_macrolaminae
           FROM (jtbl_tlkpmesomacrolaminae j
             JOIN tlkpmesomacrolaminae l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_oncoidflattening AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_oncoidflattening
           FROM (jtbl_tlkpmesooncoidflattening j
             JOIN tlkpmesooncoidflattening l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_oncoids AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_oncoids
           FROM (jtbl_tlkpmesooncoids j
             JOIN tlkpmesooncoids l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_oncoidshape AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_oncoidshape
           FROM (jtbl_tlkpmesooncoidshape j
             JOIN tlkpmesooncoidshape l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_stackingoverlap AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_stackingoverlap
           FROM (jtbl_tlkpmesostackingoverlap j
             JOIN tlkpmesostackingoverlap l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), meso_types AS (
         SELECT j.mesostructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS meso_types
           FROM (jtbl_tlkpmesotypes j
             JOIN tlkpmesotypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.mesostructureid
        ), micro_carbonategrains AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT l.textfield, ', '::text ORDER BY l.textfield) AS micro_carbonategrains
           FROM (jtbl_tlkpmicrocarbonategrains j
             JOIN tlkpmicrocarbonategrains l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_cementtypes AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_cementtypes
           FROM (jtbl_tlkpmicrocementtypes j
             JOIN tlkpmicrocementtypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_clasticgrains AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_clasticgrains
           FROM (jtbl_tlkpmicroclasticgrains j
             JOIN tlkpmicroclasticgrains l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_microfacies AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_microfacies
           FROM (jtbl_tlkpmicromicrofacies j
             JOIN tlkpmicromicrofacies l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_mineralogy AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_mineralogy
           FROM (jtbl_tlkpmicromineralogy j
             JOIN tlkpmicromineralogy l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_porositydirection AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_porositydirection
           FROM (jtbl_tlkpmicroporositydirection j
             JOIN tlkpmicroporositydirection l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_porosityprocess AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_porosityprocess
           FROM (jtbl_tlkpmicroporosityprocess j
             JOIN tlkpmicroporosityprocess l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_porositysize AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_porositysize
           FROM (jtbl_tlkpmicroporositysize j
             JOIN tlkpmicroporositysize l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_porositytypes AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_porositytypes
           FROM (jtbl_tlkpmicroporositytypes j
             JOIN tlkpmicroporositytypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        ), micro_texturetypes AS (
         SELECT j.microstructureid,
            string_agg(DISTINCT (l.textfield)::text, ', '::text ORDER BY (l.textfield)::text) AS micro_texturetypes
           FROM (jtbl_tlkpmicrotexturetypes j
             JOIN tlkpmicrotexturetypes l ON ((j.fieldvalueid = l.valueid)))
          GROUP BY j.microstructureid
        )
 SELECT p.projectid AS project_projectid,
    p.projectname AS project_projectname,
    p.principalinvestigator AS project_principalinvestigator,
    p.siteorlocationname AS project_siteorlocationname,
    p.startdate AS project_startdate,
    p.enddate AS project_enddate,
    p.instrumentsused AS project_instrumentsused,
    p.orcid AS project_orcid,
    p.otherteammembers AS project_otherteammembers,
    p.areaofinterest AS project_areaofinterest,
    p.purposeofstudy AS project_purposeofstudy,
    p.fundingsource AS project_fundingsource,
    p.grantid AS project_grantid,
    lp_projecttectonicsetting.textfield AS project_projecttectonicsetting,
    mega.megastructureid AS mega_megastructureid,
    mega.projectid AS mega_projectid,
    mega.citationgroupid AS mega_citationgroupid,
    mega.megasampleid_local AS mega_megasampleid_local,
    mega.megasampleid_sesar AS mega_megasampleid_sesar,
    mega.datesamplecollected AS mega_datesamplecollected,
    mega.fieldbook AS mega_fieldbook,
    mega.fieldbookpage AS mega_fieldbookpage,
    mega.fieldwaypointname AS mega_fieldwaypointname,
    mega.latitude AS mega_latitude,
    mega.longitude AS mega_longitude,
    mega.elevation AS mega_elevation,
    mega.supergroup AS mega_supergroup,
    mega."group" AS mega_group,
    mega.formation AS mega_formation,
    mega.member AS mega_member,
    mega.timescaleage AS mega_timescaleage,
    mega.geochronage AS mega_geochronage,
    mega.geochronageerror AS mega_geochronageerror,
    mega.geochronagebasis AS mega_geochronagebasis,
    mega.megacomplete AS mega_megacomplete,
    mega.megaismacro AS mega_megaismacro,
    mega.linnaeanname AS mega_linnaeanname,
    mega.notes AS mega_notes,
    mega.section_name AS mega_section_name,
    mega.total_sect_thickness_m AS mega_total_sect_thickness_m,
    mega.sample_height_in_section_m AS mega_sample_height_in_section_m,
    l_mega_buildupinterface.textfield AS mega_megabuildupinterface,
    l_mega_builduptype.textfield AS mega_megabuilduptype,
    l_mega_depositionalsetting.textfield AS mega_megadepositionalsetting,
    l_mega_horizontalscale.textfield AS mega_megahorizontalscale,
    l_mega_initiation.textfield AS mega_megainitiation,
    l_mega_sedinterface.textfield AS mega_megasedinterface,
    l_mega_substrate.textfield AS mega_megasubstrate,
    l_mega_verticalscale.textfield AS mega_megaverticalscale,
    mega.lat_long AS mega_lat_long,
    mega.location_desc AS mega_location_desc,
    l_mega_latlongquality.textfield AS mega_megalat_long_quality,
    mega.collectionid AS mega_collectionid,
    mega_lithology.mega_lithology,
    mega_megastructureshape.mega_megastructureshape,
    mega_microbialitetypes.mega_microbialitetypes,
    macro.macrostructureid AS macro_macrostructureid,
    macro.megastructureid AS macro_megastructureid,
    macro.sampleid AS macro_sampleid,
    macro.macroismeso AS macro_macroismeso,
    macro.sampleid_sesar AS macro_sampleid_sesar,
    macro.macrocomplete AS macro_macrocomplete,
    l_macro_aspectratio.textfield AS macro_macroaspectratio,
    l_macro_attitude.textfield AS macro_macroattitude,
    l_macro_growthvariability.textfield AS macro_macrogrowthvariability,
    l_macro_linkage.textfield AS macro_macrolinkage,
    l_macro_spacing.textfield AS macro_macrospacing,
    macro.macrosampleid_local AS macro_macrosampleid_local,
    macro_branchingmode.macro_branchingmode,
    macro_branchingstyle.macro_branchingstyle,
    macro_columnshape.macro_columnshape,
    macro_conicalshapes.macro_conicalshapes,
    macro_divergenceangle.macro_divergenceangle,
    macro_domeshape.macro_domeshape,
    macro_layershape.macro_layershape,
    macro_planview.macro_planview,
    macro_shape.macro_shape,
    meso.mesostructureid AS meso_mesostructureid,
    meso.macrostructureid AS meso_macrostructureid,
    meso.sampleid AS meso_sampleid,
    meso.sampleid_sesar AS meso_sampleid_sesar,
    meso.mesolamthickness AS meso_mesolamthickness,
    meso.mesowavelength AS meso_mesowavelength,
    meso.notes AS meso_notes,
    meso.infru AS meso_infru,
    meso.researcheranalyst AS meso_researcheranalyst,
    meso.mesocomplete AS meso_mesocomplete,
    l_meso_clothierarchy.textfield AS meso_mesoclothierarchy,
    l_meso_laminainheritance.textfield AS meso_mesolaminainheritance,
    l_meso_latcontinuity.textfield AS meso_mesolatcontinuity,
    l_meso_modalityskewness.textfield AS meso_mesomodalityskewness,
    l_meso_synopticrelief.textfield AS meso_mesosynopticrelief,
    l_meso_walls.textfield AS meso_mesowalls,
    meso.mesosampleid_local AS meso_mesosampleid_local,
    meso_alternation.meso_alternation,
    meso_architecture.meso_architecture,
    meso_clotshape.meso_clotshape,
    meso_graintypes.meso_graintypes,
    meso_lampattern.meso_lampattern,
    meso_lamprofile.meso_lamprofile,
    meso_lamwaviness.meso_lamwaviness,
    meso_macrolaminae.meso_macrolaminae,
    meso_oncoidflattening.meso_oncoidflattening,
    meso_oncoids.meso_oncoids,
    meso_oncoidshape.meso_oncoidshape,
    meso_stackingoverlap.meso_stackingoverlap,
    meso_types.meso_types,
    micro.microstructureid AS micro_microstructureid,
    micro.mesostructureid AS micro_mesostructureid,
    micro.sampleid AS micro_sampleid,
    micro.subsample AS micro_subsample,
    micro.porositypercentest AS micro_porositypercentest,
    micro.cementfilledporosity AS micro_cementfilledporosity,
    micro.micronotes AS micro_micronotes,
    micro.microsampleid_local AS micro_microsampleid_local,
    micro.microsampleid_sesar AS micro_microsampleid_sesar,
    micro.microreferenceimage AS micro_microreferenceimage,
    micro.microcomplete AS micro_microcomplete,
    micro.txtmicronotes AS micro_txtmicronotes,
    l_micro_wentworth.textfield AS micro_microwentworth,
    l_micro_percentclastics.textfield AS micro_micropercentclastics,
    micro_carbonategrains.micro_carbonategrains,
    micro_cementtypes.micro_cementtypes,
    micro_clasticgrains.micro_clasticgrains,
    micro_microfacies.micro_microfacies,
    micro_mineralogy.micro_mineralogy,
    micro_porositydirection.micro_porositydirection,
    micro_porosityprocess.micro_porosityprocess,
    micro_porositysize.micro_porositysize,
    micro_porositytypes.micro_porositytypes,
    micro_texturetypes.micro_texturetypes
   FROM ((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((((tbl_projectdata p
     LEFT JOIN tlkpprojecttectonicsetting lp_projecttectonicsetting ON ((p.projecttectonicsettingid = lp_projecttectonicsetting.valueid)))
     LEFT JOIN tbl_megastructuredata mega ON ((p.projectid = mega.projectid)))
     LEFT JOIN tlkpmegabuildupinterface l_mega_buildupinterface ON ((mega.megabuildupinterfaceid = l_mega_buildupinterface.valueid)))
     LEFT JOIN tlkpmegabuilduptype l_mega_builduptype ON ((mega.megabuilduptypeid = l_mega_builduptype.valueid)))
     LEFT JOIN tlkpmegadepositionalsetting l_mega_depositionalsetting ON ((mega.megadepositionalsettingid = l_mega_depositionalsetting.valueid)))
     LEFT JOIN tlkpmegahorizontalscale l_mega_horizontalscale ON ((mega.megahorizontalscaleid = l_mega_horizontalscale.valueid)))
     LEFT JOIN tlkpmegainitiation l_mega_initiation ON ((mega.megainitiationid = l_mega_initiation.valueid)))
     LEFT JOIN tlkpmegasedinterface l_mega_sedinterface ON ((mega.megasedinterfaceid = l_mega_sedinterface.valueid)))
     LEFT JOIN tlkpmegasubstrate l_mega_substrate ON ((mega.megasubstrateid = l_mega_substrate.valueid)))
     LEFT JOIN tlkpmegaverticalscale l_mega_verticalscale ON ((mega.megaverticalscaleid = l_mega_verticalscale.valueid)))
     LEFT JOIN tlkpmegalat_long_quality l_mega_latlongquality ON ((mega.megalat_long_qualityid = l_mega_latlongquality.valueid)))
     LEFT JOIN mega_lithology ON ((mega.megastructureid = mega_lithology.megastructureid)))
     LEFT JOIN mega_megastructureshape ON ((mega.megastructureid = mega_megastructureshape.megastructureid)))
     LEFT JOIN mega_microbialitetypes ON ((mega.megastructureid = mega_microbialitetypes.megastructureid)))
     LEFT JOIN tbl_macrostructuredata macro ON ((mega.megastructureid = macro.megastructureid)))
     LEFT JOIN tlkpmacroaspectratio l_macro_aspectratio ON ((macro.macroaspectratioid = l_macro_aspectratio.valueid)))
     LEFT JOIN tlkpmacroattitude l_macro_attitude ON ((macro.macroattitudeid = l_macro_attitude.valueid)))
     LEFT JOIN tlkpmacrogrowthvariability l_macro_growthvariability ON ((macro.macrogrowthvariabilityid = l_macro_growthvariability.valueid)))
     LEFT JOIN tlkpmacrolinkage l_macro_linkage ON ((macro.macrolinkageid = l_macro_linkage.valueid)))
     LEFT JOIN tlkpmacrospacing l_macro_spacing ON ((macro.macrospacingid = l_macro_spacing.valueid)))
     LEFT JOIN macro_branchingmode ON ((macro.macrostructureid = macro_branchingmode.macrostructureid)))
     LEFT JOIN macro_branchingstyle ON ((macro.macrostructureid = macro_branchingstyle.macrostructureid)))
     LEFT JOIN macro_columnshape ON ((macro.macrostructureid = macro_columnshape.macrostructureid)))
     LEFT JOIN macro_conicalshapes ON ((macro.macrostructureid = macro_conicalshapes.macrostructureid)))
     LEFT JOIN macro_divergenceangle ON ((macro.macrostructureid = macro_divergenceangle.macrostructureid)))
     LEFT JOIN macro_domeshape ON ((macro.macrostructureid = macro_domeshape.macrostructureid)))
     LEFT JOIN macro_layershape ON ((macro.macrostructureid = macro_layershape.macrostructureid)))
     LEFT JOIN macro_planview ON ((macro.macrostructureid = macro_planview.macrostructureid)))
     LEFT JOIN macro_shape ON ((macro.macrostructureid = macro_shape.macrostructureid)))
     LEFT JOIN tbl_mesostructuredata meso ON ((macro.macrostructureid = meso.macrostructureid)))
     LEFT JOIN tlkpmesoclothierarchy l_meso_clothierarchy ON ((meso.mesoclothierarchyid = l_meso_clothierarchy.valueid)))
     LEFT JOIN tlkpmesolaminainheritance l_meso_laminainheritance ON ((meso.mesolaminainheritanceid = l_meso_laminainheritance.valueid)))
     LEFT JOIN tlkpmesolatcontinuity l_meso_latcontinuity ON ((meso.mesolatcontinuityid = l_meso_latcontinuity.valueid)))
     LEFT JOIN tlkpmesomodalityskewness l_meso_modalityskewness ON ((meso.mesomodalityskewnessid = l_meso_modalityskewness.valueid)))
     LEFT JOIN tlkpmesosynopticrelief l_meso_synopticrelief ON ((meso.mesosynopticreliefid = l_meso_synopticrelief.valueid)))
     LEFT JOIN tlkpmesowalls l_meso_walls ON ((meso.mesowallsid = l_meso_walls.valueid)))
     LEFT JOIN meso_alternation ON ((meso.mesostructureid = meso_alternation.mesostructureid)))
     LEFT JOIN meso_architecture ON ((meso.mesostructureid = meso_architecture.mesostructureid)))
     LEFT JOIN meso_clotshape ON ((meso.mesostructureid = meso_clotshape.mesostructureid)))
     LEFT JOIN meso_graintypes ON ((meso.mesostructureid = meso_graintypes.mesostructureid)))
     LEFT JOIN meso_lampattern ON ((meso.mesostructureid = meso_lampattern.mesostructureid)))
     LEFT JOIN meso_lamprofile ON ((meso.mesostructureid = meso_lamprofile.mesostructureid)))
     LEFT JOIN meso_lamwaviness ON ((meso.mesostructureid = meso_lamwaviness.mesostructureid)))
     LEFT JOIN meso_macrolaminae ON ((meso.mesostructureid = meso_macrolaminae.mesostructureid)))
     LEFT JOIN meso_oncoidflattening ON ((meso.mesostructureid = meso_oncoidflattening.mesostructureid)))
     LEFT JOIN meso_oncoids ON ((meso.mesostructureid = meso_oncoids.mesostructureid)))
     LEFT JOIN meso_oncoidshape ON ((meso.mesostructureid = meso_oncoidshape.mesostructureid)))
     LEFT JOIN meso_stackingoverlap ON ((meso.mesostructureid = meso_stackingoverlap.mesostructureid)))
     LEFT JOIN meso_types ON ((meso.mesostructureid = meso_types.mesostructureid)))
     LEFT JOIN tbl_microstructuredata micro ON ((meso.mesostructureid = micro.mesostructureid)))
     LEFT JOIN tlkpmicrowentworth l_micro_wentworth ON ((micro.microwentworthid = l_micro_wentworth.valueid)))
     LEFT JOIN tlkpmicropercentclastics l_micro_percentclastics ON ((micro.micropercentclasticsid = l_micro_percentclastics.valueid)))
     LEFT JOIN micro_carbonategrains ON ((micro.microstructureid = micro_carbonategrains.microstructureid)))
     LEFT JOIN micro_cementtypes ON ((micro.microstructureid = micro_cementtypes.microstructureid)))
     LEFT JOIN micro_clasticgrains ON ((micro.microstructureid = micro_clasticgrains.microstructureid)))
     LEFT JOIN micro_microfacies ON ((micro.microstructureid = micro_microfacies.microstructureid)))
     LEFT JOIN micro_mineralogy ON ((micro.microstructureid = micro_mineralogy.microstructureid)))
     LEFT JOIN micro_porositydirection ON ((micro.microstructureid = micro_porositydirection.microstructureid)))
     LEFT JOIN micro_porosityprocess ON ((micro.microstructureid = micro_porosityprocess.microstructureid)))
     LEFT JOIN micro_porositysize ON ((micro.microstructureid = micro_porositysize.microstructureid)))
     LEFT JOIN micro_porositytypes ON ((micro.microstructureid = micro_porositytypes.microstructureid)))
     LEFT JOIN micro_texturetypes ON ((micro.microstructureid = micro_texturetypes.microstructureid)))
  ORDER BY p.projectid, mega.megastructureid, macro.macrostructureid, meso.mesostructureid, micro.microstructureid;

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views