dic_material_type

195 rows


Description

Dictionary of materials, rock types from Macrostrat

Columns

Column Type Size Nulls Auto Default Children Parents Comments
material_type_id INT 10 √ null
material.material_type_id material_ibfk_4 R
material_source.material_type_id material_source_ibfk_7 R

Primary key, autoincrementing
material_name VARCHAR 250 null

Name of the material (e.g. granite, limestone, yellow brick, galena)
material_type VARCHAR 250 √ NULL

Material type (e.g. volcanic, carbonate, siliciclastic)
material_group VARCHAR 250 √ NULL

Material group (e.g. sandstones, mafic, felsic, Dunham, Folk)
material_class VARCHAR 250 √ NULL

Material class (igneous, sedimentary, metamorphic)
material_category VARCHAR 250 null

Primary material category (rock, mineral, other)

Indexes

Constraint Name Type Sort Column(s)
dic_material_type_s_pk Primary key Asc material_type_id
material_name Performance Asc material_name
PRIMARY Must be unique Asc material_type_id

Relationships

Close relationships within degrees of separation