tbl_microstructuredata

177 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
microstructureid serial 10 √ nextval('"tbl_MicrostructureData_microstructureID_seq"'::regclass)
ann_microtrait_observation_quality.microstructureid fk_microtrait_quality_parent C
jtbl_microstructure_gigapans.microstructureid fk_microstructure C
jtbl_tlkpmicrocarbonategrains.microstructureid Implied Constraint R
jtbl_tlkpmicrocementtypes.microstructureid fk_junct_microstructures R
jtbl_tlkpmicroclasticgrains.microstructureid fk_junct_microstructures R
jtbl_tlkpmicromicrofacies.microstructureid fk_junct_microstructures R
jtbl_tlkpmicromineralogy.microstructureid fk_junct_microstructures R
jtbl_tlkpmicroporositydirection.microstructureid fk_junct_microstructures R
jtbl_tlkpmicroporosityprocess.microstructureid fk_junct_microstructures R
jtbl_tlkpmicroporositysize.microstructureid fk_junct_microstructures R
jtbl_tlkpmicroporositytypes.microstructureid fk_junct_microstructures R
jtbl_tlkpmicrosecondarymin.microstructureid fk_junct_microstructures R
jtbl_tlkpmicrotexturetypes.microstructureid fk_junct_microstructures R
tbl_photolinksdata.microstructureid fk_photolinks_microstructure N
v_export_master.micro_microstructureid Implied Constraint R
v_export_micro.micro_microstructureid Implied Constraint R
mesostructureid int4 10 √ null
tbl_mesostructuredata.mesostructureid fk_mesostructure_microstructure N
sampleid varchar 255 √ null
subsample varchar 255 √ null
porositypercentest varchar 255 √ null
cementfilledporosity varchar 255 √ null
micronotes text 2147483647 √ null
microsampleid_local text 2147483647 √ null
microsampleid_sesar text 2147483647 √ null
microreferenceimage varchar 255 √ null
microcomplete bool 1 √ null
txtmicronotes text 2147483647 √ null

Notes on petrography
microwentworthid int4 10 √ null
micropercentclasticsid int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_MicrostructureData_pkey Primary key Asc microstructureid

Relationships

Close relationships within degrees of separation