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) |