Tables


SchemaSpy Analysis of microbialitesDB_Backend.microbialitesdb

Generated on Fri Jun 26 20:51 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 125
VIEWS 8
COLUMNS 797
Constraints 117
Anomalies 6
Routines 779

Database Properties

Database Type: PostgreSQL - 17.0 (Debian 17.0-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
jtbl_tlkpmacrolayershape 0 2 2 70 Table
ann_megatrait_observation_quality 0 2 5 -1 Table
tlkpmegalat_long_quality 0 0 3 -1 Table
jtbl_tlkpmacroshape 0 2 2 128 Table
tlkpmacrocolumnshape 1 0 3 5 Table
tlkpmesooncoidshape 1 0 3 4 Table
tlkpmicroclasticgrains 1 0 3 11 Table
jtbl_tlkpmegamegastructureshape 0 2 2 95 Table
jtbl_tlkpmicromicrofacies 0 2 2 -1 Table
ann_macrotrait_observation_quality 0 2 5 -1 Table
jtbl_tlkpmacrobranchingstyle 0 2 2 3 Table
tlkpmicrocarbonategrains 0 0 3 -1 Table
jtbl_tlkpmacroconicalshapes 0 2 2 -1 Table
jtbl_microstructure_gigapans 0 1 4 88 Table
jtbl_tlkpmacrodivergenceangle 0 2 2 1 Table
tlkpmesograintypes 1 0 3 7 Table
tlkpmacroshape 1 0 3 10 Table
tlkpmesosynopticrelief 1 0 3 6 Table
tlkpmacrogrowthvariability 1 0 3 4 Table
jtbl_tlkpmicrocementtypes 0 2 2 -1 Table
tlkpmicroporositytypes 1 0 3 16 Table
jtbl_tlkpmesomacrolaminae 0 2 2 83 Table
jtbl_tlkpmicrocarbonategrains 0 1 3 12 Table
tlkpmesoarchitecture 1 0 3 9 Table
tlkpmesolamprofile 1 0 3 12 Table
ann_mesotrait_observation_quality 0 2 5 -1 Table
tlkpmesolatcontinuity 1 0 3 8 Table
jtbl_tlkpmegamicrobialitetypes 0 2 2 128 Table
jtbl_tlkpmicroporositydirection 0 2 2 -1 Table
tlkpmegaageunit 1 0 3 -1 Table
jtbl_tlkpmesograintypes 0 2 2 105 Table
tlkpmegadepositionalsetting 1 0 3 17 Table
tlkpmegaageinterpretationbasis 1 0 3 -1 Table
tlkpmegasubstrate 1 0 3 4 Table
tlkpmesooncoids 1 0 3 6 Table
jtbl_project_citations 0 2 3 -1 Table
jtbl_tlkpmesooncoids 0 2 2 1 Table
jtbl_tlkpmesoclotshape 0 2 2 49 Table
tlkpmesowalls 1 0 3 7 Table
tlkpmacrobranchingstyle 1 0 3 7 Table
jtbl_tlkpmesolampattern 0 2 2 85 Table
tlkpitemtype 0 0 4 26 Table
tlkpmesolampattern 1 0 3 3 Table
jtbl_tlkpmicroporositysize 0 2 2 -1 Table
jtbl_tlkpmesooncoidflattening 0 2 2 1 Table
jtbl_tlkpmesostackingoverlap 0 2 2 86 Table
tbl_projectdata 6 1 14 12 Table
tlkpmacroaspectratio 1 0 3 4 Table
tbl_megastructuredata 11 15 45 160 Table
tlkpmesolaminainheritance 1 0 3 5 Table
tlkpmacrodivergenceangle 1 0 3 5 Table
jtbl_tlkpmicroporositytypes 0 2 3 -1 Table
jtbl_collection_citations 0 2 3 -1 Table
jtbl_tlkpmacrobranchingmode 0 2 2 1 Table
tlkpmegamegastructureshape 1 0 3 10 Table
tbl_macrostructuredata 16 6 12 183 Table
tlkpmegasedinterface 1 0 3 4 Table
jtbl_tlkpmicrosecondarymin 0 2 2 -1 Table
tlkpmacroattitude 1 0 3 9 Table
tlkpsemandotherdatatypes 0 0 3 6 Table
jtbl_citationgroups 0 2 3 3 Table
tlkpmegageotimescale 0 0 9 135 Table
tlkpmegainitiation 1 0 3 5 Table
tbl_collections 4 0 11 6 Table
tlkpmacroplanview 1 0 3 14 Table
tlkpmesomacrolaminae 1 0 3 6 Table
jtbl_tlkpmicroporosityprocess 0 2 2 -1 Table
ann_microtrait_observation_quality 0 2 5 -1 Table
tlkptrait_observation_quality 4 0 3 -1 Table
tlkpmegaagequalifier 1 0 3 -1 Table
tlkpmesoclothierarchy 1 0 3 4 Table
jtbl_tlkpmicroclasticgrains 0 2 2 9 Table
tlkpmesoclotshape 1 0 3 12 Table
tlkpmicropercentclastics 0 0 3 -1 Table
jtbl_tlkpmesotypes 0 2 2 130 Table
tlkpmesotypes 1 0 3 14 Table
jtbl_megastructure_geologicage 0 1 7 117 Table
tbl_citations 3 0 29 13 Table
tlkpmicroporositysize 1 0 3 4 Table
tlkpmicrotexturetypes 1 0 3 11 Table
tlkpmicrowentworth 0 0 3 -1 Table
tlkpmegahorizontalscale 1 0 3 9 Table
jtbl_tlkpmacrocolumnshape 0 2 2 6 Table
jtbl_tlkpmegalithology 0 2 2 103 Table
jtbl_tlkpmesoarchitecture 0 2 2 83 Table
tlkpmicrocementtypes 1 0 3 16 Table
tlkpmacrolinkage 1 0 3 5 Table
jtbl_tlkpmesooncoidshape 0 2 2 1 Table
tlkpmesostackingoverlap 1 0 3 4 Table
tlkpmegabuilduptype 1 0 3 6 Table
tbl_query_builder_fields 0 0 17 69 Table
tbl_mesostructuredata 20 7 17 277 Table
tlkpmacrodomeshape 1 0 3 5 Table
tbl_citationgroup 4 0 4 5 Table
tlkpmesooncoidflattening 1 0 3 4 Table
tlkpmacrospacing 1 0 3 5 Table
tlkpmegabuildupinterface 1 0 3 3 Table
jtbl_tlkpmacrodomeshape 0 2 2 56 Table
tlkpmegabedgeometry 0 0 3 6 Table
spatial_ref_sys 2 0 5 8500 Table
tlkpmicroporositydirection 1 0 3 4 Table
jtbl_tlkpmesoalternation 0 2 2 84 Table
tbl_users 0 0 6 -1 Table
jtbl_tlkpmicromineralogy 0 2 2 12 Table
tbl_microstructuredata 16 1 14 177 Table
jtbl_tlkpmacroplanview 0 2 2 82 Table
jtbl_tlkpmicrotexturetypes 0 2 2 53 Table
tlkpmacrolayershape 1 0 3 7 Table
tlkpmesomodalityskewness 1 0 3 5 Table
jtbl_tlkpmesolamprofile 0 2 2 87 Table
tlkpmegaverticalscale 1 0 3 9 Table
tlkpprojecttectonicsetting 1 0 3 8 Table
tbl_photolinksdata 0 4 21 1924 Table
tlkpmicroporosityprocess 1 0 3 4 Table
tlkpmegamicrobialitetypes 1 0 3 8 Table
tlkpmicromineralogy 2 0 3 16 Table
jtbl_tlkpmesolamwaviness 0 2 2 97 Table
tbl_helpimagelinks 0 0 4 39 Table
tlkpmicromicrofacies 1 0 3 3 Table
tlkpmegaageconfidence 1 0 3 -1 Table
tlkpmegalithology 1 0 3 7 Table
tlkpmesoalternation 1 0 3 8 Table
tlkpmacrobranchingmode 1 0 3 4 Table
tlkpmesolamwaviness 1 0 3 7 Table
tlkpmacroconicalshapes 1 0 3 11 Table
geography_columns 0 1 7 0 View
v_export_master 0 11 131 0 View
v_export_meso 0 2 30 0 View
v_export_mega 0 4 42 0 View
geometry_columns 0 1 7 0 View
v_export_micro 0 2 24 0 View
v_export_project 0 1 14 0 View
v_export_macro 0 2 21 0 View