Tables


SchemaSpy Analysis of stonebuiltdb_2025.stonebuiltdb_2025

Generated on Thu Sep 25 10:14 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 41
VIEWS 0
COLUMNS 420
Constraints 58
Anomalies 2
Routines 0

Database Properties

Database Type: MySQL - 11.4.8-MariaDB-ubu2404

Tables

Table / View Children Parents Columns Rows Type Comments
location 2 3 41 61 Table

Locations/Addresses for stoneworks, marble mills etc.

dic_material_source_distance 1 0 3 5 Table

Dictionary of qualitative material source distance from heritage site (e.g. onsite, local)

dic_material_condition 1 0 3 5 Table

Dictionary of material condition

dic_material_type 2 0 6 195 Table

Dictionary of materials, rock types from Macrostrat

dic_relationship 1 0 2 17 Table

Dictionary of relationship between people (e.g. parent of)

dic_century 1 0 2 20 Table

Dictionary of centuries, and archaeological periods

commodity 1 2 3 221 Table

Linking material to material source

dic_style 1 0 4 32 Table

Dictionary of styles (e.g. Gothic, Romanesque)

dic_gsi_strat 1 0 21 1139 Table

Dictionary of lithostratigraphic unit names from Geological Survey Ireland

dic_georef_protocol 3 0 4 2 Table

Dictionary of georeferencing protocols

material_use_finish 0 2 3 715 Table

Linking material use to one or more finishes

heritage_site 2 5 50 201 Table

Heritages sites including their location and a description

person_title 0 2 7 70 Table

Linking people to one or more titles

person_relationship 0 3 10 175 Table

Linking people to other people e.g. parents/children

construction_styles 0 2 4 97 Table

Linking a phase of construction to one or more architectural styles

dic_title 1 0 2 23 Table

Dictionary of titles for people (e.g. Earl)

dic_finish 1 0 3 34 Table

Dictionary of material finishes (e.g. polished)

material_use 2 8 16 742 Table

Material use in a heritage site. Central linking table, including details of where and how the material was used.

dic_ics_age 1 0 6 173 Table

Dictionary of International Commission on Stratigraphy geological age names

dic_fossil 1 0 2 22 Table

Dictionary of fossils

material_fossil 0 2 2 53 Table

Linking materials to one or more fossils

dic_role 4 0 2 12 Table

Dictionary of roles for people (e.g. architect, builder)

dic_form_of_address 1 0 3 26 Table

Dictionary of forms of address for people e.g. Rev. Col)

material_source 3 7 54 301 Table

Material Sources (quarries) including a description and their location.

material 4 6 35 264 Table

Materials (stones) including a description and their geological context.

person 7 3 31 620 Table

People and firms/companies, including dates

dic_townland 3 0 14 60534 Table

Dictionary of townlands, downloaded from townlands.ie

dic_material_position 1 0 2 2 Table

Dictionary of material use position in a heritage site (interior, exterior)

dic_material_source_type 1 0 2 2 Table

Dictionary of material source type (e.g. quarry, brickfield)

material_sample 0 1 3 2 Table

Linking materials to one or more museum samples

person_material_source 0 3 15 302 Table

Linking people to a material source (e.g. owner of a quarry)

person_location 1 2 15 78 Table

Linking people to a location (e.g. a marble mill, stoneworks)

dic_heritage_site_type 1 0 2 59 Table

Dictionary of heritage site types e.g. church, bank

dic_grain_crystal_size 1 0 2 4 Table

Dictionary of grain/crystal sizes

dic_person_suffix 1 0 3 3 Table

Dictionary of suffixes for peoples names (e.g. Jr. Sr. Esq.)

person_construction 0 3 9 551 Table

Linking people to phases of construction

dic_use_feature 1 0 4 125 Table

Dictionary of features (e.g. column, wall)

dic_county 4 0 4 35 Table

Dictionary of counties

dic_status 1 0 3 3 Table

Dictionary of status for material sources (e.g. active, inactive)

construction 3 1 15 308 Table

Phases of construction for a heritage site

person_material_use 0 4 8 21 Table

Linking people to a material use (e.g. stonemason to a carving)