Information about the Database: labuser_jdesiderio version 1 (20.12.2021)

Contact of the author:
Dr. Janyce Desiderio
beda.delocissanctis@gmail.com

This publication is the result of a project funded by the Alexander von Humboldt Foundation (post-doctoral fellowship), led at the Department of Greek and Latin Philology at the Ludwig-Maximilians-Universität in Munich. It consists of a new critical edition of The Venerable Bede's De locis sanctis, in a digital format, with details about the manuscripts, an index of every place-name cited in the text, and a bibliography. 

The text may be displayed online in 5 different ways:
    - Latin Text: the plain edited Latin text, with reproductions of the floor plans as drawn in Ms N.
    - Apparatus: the edited Latin text with its apparatus criticus. Each word is linked to the variants table: by clicking on a word in the text, you get the corresponding line in the table, showing you each manuscript version of the word. If you click on any Edited word in the table, it takes you back to the right line in the text. The apparatus table contains only expanded versions of the words; to get more information about the abbreviations and ligatures in the manuscripts, go to the Manuscripts tab.
    - Sources: each sentence of the text is given alongside the references of the passages Bede copied, abridged or paraphrased. A link to an online edition of the source is given whenever possible (CSEL - from the Open Greek and Latin Perseus Digital Library, Patrologia Latina - on archive.org, the Vulgate - from the Academic Bible website).
    - Toponyms: each reference to a place in the text is linked to its information sheet: by clicking on a highlighted term, you get an overview of the location, its alternate names, if Bede gives more than one denomination, and a short commentary.
    - Translation: an original French translation is given opposite to the Latin text.

The edited text, the indexes and the bibliography are accessible at this URL: https://www.bedadls.gwi.uni-muenchen.de/

The data is free to use under the CC BY-SA 4.0 license: https://creativecommons.org/licenses/by-sa/4.0/legalcode.
For any enquiry, please contact the author at the e-mail address above.

The data is accessible in the following formats : SQL and CSV.
The database, the tables and the columns are commented.

The files below hold: 
- the version 1 of the database labuser_jdesiderio (20/12/2021): 
    - labuser_jdesiderio.sql: structure and data of the whole database in SQL format;
    - AlignmentBeda.sql: table AlignmentBeda (structure and data) in SQL format;
    - AlignmentToponyms.sql: table AlignmentToponyms (structure and data) in SQL format;
    - Edition.sql: table Edition (structure and data) in SQL format;
    - EditionCorrections.sql: table EditionCorrections (structure and data) in SQL format;
    - Queries.sql: table Queries (structure and data) in SQL format;
    - SiglaCodicum.sql: table SiglaCodicum (structure and data) in SQL format;
    - SourceAuthors.sql: table SourceAuthors (structure and data) in SQL format;
    - SourceReferences.sql: table SourceReferences (structure and data) in SQL format;
    - SourceTexts.sql: table SourceTexts (structure and data) in SQL format;
    - SubtokenMss.sql: table SubtokenMss (structure and data) in SQL format;
    - ToponymsList.sql: table ToponymsList (structure and data) in SQL format;
    - Translation.sql: table Translation (structure and data) in SQL format.

    - labuser_jdesiderio.csv: all the tables in CSV format (Separator = TAB);
    - AlignmentBeda.csv: table AlignmentBeda in CSV format (Separator = TAB);
    - AlignmentToponyms.csv: table AlignmentToponyms in CSV format (Separator = TAB);
    - Edition.csv: table Edition in CSV format (Separator = TAB);
    - EditionCorrections.csv: table EditionCorrections in CSV format (Separator = TAB);
    - Queries.csv: table Queries in CSV format (Separator = TAB);
    - SiglaCodicum.csv: table SiglaCodicum in CSV format (Separator = TAB);
    - SourceAuthors.csv: table SourceAuthors in CSV format (Separator = TAB);
    - SourceReferences.csv: table SourceReferences in CSV format (Separator = TAB);
    - SourceTexts.csv: table SourceTexts in CSV format (Separator = TAB);
    - SubtokenMss.csv: table SubtokenMss in CSV format (Separator = TAB);
    - ToponymsList.csv: table ToponymsList in CSV format (Separator = TAB);
    - Translation.csv: table Translation in CSV format (Separator = TAB).

The database labuser_jdesiderio contains the following tables:

AlignmentBeda (
  `id_edition` int(4) NOT NULL DEFAULT '0' COMMENT 'ID of the edited tokens',
  `sentence` int(3) DEFAULT NULL COMMENT 'text sentence number',
  `ms1` int(4) DEFAULT NULL COMMENT 'aligned id_item from MS 1 (from SubtokenMss)',
  `ms2` int(4) DEFAULT NULL COMMENT 'aligned id_item from MS 2 (from SubtokenMss)',
  `ms3` int(5) DEFAULT NULL COMMENT 'aligned id_item from MS 3 (from SubtokenMss)',
  `ms53` int(5) DEFAULT NULL COMMENT 'aligned id_item from MS 53 (from SubtokenMss)',
  `ms20` int(5) DEFAULT NULL COMMENT 'aligned id_item from MS 20 (from SubtokenMss)',
  `ms21` int(5) DEFAULT NULL COMMENT 'aligned id_item from MS 21 (from SubtokenMss)',
  `priority` int(2) DEFAULT NULL COMMENT 'ID of the manuscript with the best reading',
  `problem` int(1) DEFAULT NULL COMMENT '1 when no manuscript presents a viable reading (linked to EditionCorrections)',
  `topo_nr` int(3) DEFAULT NULL COMMENT 'counting tokens which are toponyms (linked to AlignmentToponyms)'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='associative table containing the alignment of the 'id_item' of each manuscripts (so that words match from one manuscript to the other), the 'priority' indicating which manuscript contains the best reading, 'problem' indicating the absence of a good variant, linked with the conjectures of EditionCorrections, and the markup of toponyms in the text (linked to AlignmentToponyms).';

--

AlignmentToponyms (
  `topo_nr` int(3) NOT NULL DEFAULT '0' COMMENT 'unique id of toponyms occurrences in the text (in AlignmentBeda)',
  `id_toponym` int(3) DEFAULT NULL COMMENT 'ID of the toponym in ToponymsList',
  `topo_name_nr` int(2) DEFAULT NULL COMMENT 'ordering toponyms' names formed by more than one word',
  `topo_occurrence` int(3) DEFAULT NULL COMMENT 'number of occurrences of the toponym in the course of the text'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='associative table between AlignmentBeda and ToponymsList.';

--

Edition (
  `id_edition` int(4) DEFAULT NULL COMMENT 'ID of the edited tokens',
  `id_ms` int(2) DEFAULT NULL COMMENT 'ID of the manuscript with the "best" reading',
  `chapter` int(2) DEFAULT NULL COMMENT 'text chapter number',
  `sentence` int(3) DEFAULT NULL COMMENT 'text sentence number',
  `problem` int(1) DEFAULT NULL COMMENT '1 when no manuscript presents a viable reading (linked to EditionCorrections)',
  `topo_nr` int(3) DEFAULT NULL COMMENT 'unique id of toponyms occurrences in the text',
  `edited_token` varchar(28) DEFAULT NULL COMMENT 'best token constituting the final DLS text'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='contains the edited tokens, to facilitate queries on the edited DLS text for the website.';

--

EditionCorrections (
  `id_edition` int(6) NOT NULL COMMENT 'ID of the edited token',
  `id_ms` int(1) DEFAULT NULL COMMENT 'ID of the manuscript with the best reading',
  `chapter` int(2) DEFAULT NULL COMMENT 'text chapter number',
  `token` varchar(20) DEFAULT NULL COMMENT 'best reading of the word in the manuscripts',
  `correction` varchar(20) DEFAULT NULL COMMENT 'editorial correction',
  `editor` varchar(2) DEFAULT NULL COMMENT 'initials of the editor (JD = Janyce Desiderio)',
  `remark` varchar(17) DEFAULT NULL COMMENT 'information when needed'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='contains the corrections and conjectures made by JD when no manuscript holds a correct reading. Linked to AlignmentBeda via 'id_edition' and 'problem'.';

--

Queries (
  `id_query` int(3) NOT NULL COMMENT 'ID of the query',
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT 'name of the query',
  `query` varchar(10000) COLLATE utf8_unicode_ci NOT NULL COMMENT 'whole query to copy-paste',
  `comment` varchar(300) COLLATE utf8_unicode_ci NOT NULL COMMENT 'short description of the query's aim'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 
COMMENT='contains a list of useful queries to treat the data + the queries used on the website.';

--

SiglaCodicum (
  `id_text` int(2) DEFAULT NULL COMMENT 'id of the text contained in the manuscripts (from SourceTexts): 11 = Beda DLS',
  `id_ms` int(11) NOT NULL COMMENT 'unique ID of each manuscript',
  `siglum` varchar(3) COLLATE utf8_unicode_ci NOT NULL COMMENT 'traditional short sigla for ancient manuscripts',
  `siglum_geyer` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'sigla of the manuscripts in Geyer's edition (1898)',
  `country` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'country where the manuscript is kept',
  `city` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'city where the manuscript is kept',
  `institution` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'institution where the manuscript is kept',
  `collection` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'collection of the manuscript, when needed',
  `number` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'manuscript's number in the institution's catalogue',
  `catalogue` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'reference in specific catalogues',
  `date` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'estimation of the date of production',
  `folios` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT 'exact pages containing the DLS in the manuscripts',
  `descr_link` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'links to online descriptions of the manuscripts'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 
COMMENT='index of the manuscripts containing Beda's DLS.';

--

SourceAuthors (
  `id_author` int(11) NOT NULL COMMENT 'unique ID of each author used in the edition',
  `name` varchar(60) DEFAULT NULL COMMENT 'full Latin name',
  `short_name` varchar(20) DEFAULT NULL COMMENT 'abbreviated name',
  `viaf` int(11) DEFAULT NULL COMMENT 'VIAF authority number: http://viaf.org/viaf/"#"',
  `qid` int(11) DEFAULT NULL COMMENT 'Wikidata ID: https://www.wikidata.org/wiki/Q"#"'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='index of ancient authors used.';

--

SourceReferences (
  `id_reference` int(3) NOT NULL DEFAULT '0' COMMENT 'unique ID of each reference to a source text',
  `id_text` int(2) DEFAULT NULL COMMENT 'ID of the cited text (from SourceTexts)',
  `reference` varchar(21) DEFAULT NULL COMMENT 'reference of the chapter / paragraph / verse of the passage',
  `printed_ref` varchar(25) DEFAULT NULL COMMENT 'page and line numbers of the printed edition of reference',
  `id_edited_text` int(2) DEFAULT NULL COMMENT 'ID of the edited text (from SourceTexts): 11 = beda DLS',
  `sentence` int(3) DEFAULT NULL COMMENT 'text sentence number',
  `link` varchar(87) DEFAULT NULL COMMENT 'link to online editions of the texts (which are not CSEL or PL)',
  `link_csel` varchar(107) DEFAULT NULL COMMENT 'links to the online editions of the CSEL',
  `link_pl` varchar(72) DEFAULT NULL COMMENT ' links to the online editions of the Patrologia Latina (digitized version)'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='list of ancient sources with their references used by Bede in the DLS text. Linked to AlignmentBeda via 'sentence'.';

--

SourceTexts (
  `id_text` int(11) NOT NULL unique COMMENT 'ID of each text cited in the edition',
  `id_author` varchar(1) DEFAULT NULL COMMENT 'ID of the author of the text  (from SourceAuthors)',
  `lat_title` varchar(100) DEFAULT NULL COMMENT 'full Latin title',
  `short_title` varchar(25) DEFAULT NULL COMMENT 'abbreviated title',
  `viaf` varchar(40) DEFAULT NULL COMMENT ' VIAF authority number: http://viaf.org/viaf/"#"',
  `qid` int(11) DEFAULT NULL COMMENT 'Wikidata ID: https://www.wikidata.org/wiki/Q"#"',
  `printed_ed` varchar(150) DEFAULT NULL COMMENT 'printed edition of reference',
  `online_ed` varchar(150) DEFAULT NULL COMMENT 'online open edition > links in SourceReferences'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='index of ancient texts used, with their edition of reference.';

--

SubtokenMss (
  `id_item` int(5) NOT NULL COMMENT 'id of each subtoken',
  `id_ms` int(1) DEFAULT NULL COMMENT 'ID of the transcripted manuscripts (from SiglaCodicum)',
  `page` int(2) DEFAULT NULL COMMENT 'page of the manuscript',
  `line` int(3) DEFAULT NULL COMMENT 'line of the manuscript',
  `pos_in_line` int(2) DEFAULT NULL COMMENT 'position of subtoken in line',
  `chapter` int(2) DEFAULT NULL COMMENT 'text chapter number',
  `sentence` int(3) DEFAULT NULL COMMENT 'text sentence number',
  `pos_in_sent` int(2) DEFAULT NULL COMMENT 'position of subtoken in sentence',
  `id_token` int(4) DEFAULT NULL COMMENT 'full token's id number',
  `subtoken_nr` int(1) DEFAULT NULL COMMENT 'number of subtoken parts in token',
  `subtoken` text COMMENT 'words / word parts (cut at the end of line) in beta code',
  `expand_abbr` text COMMENT 'words / word parts (expanded from abbreviation)',
  `symbols_abbr` text COMMENT 'words / word part (with manuscript symbols of abbreviation)'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='tokenized version of the manuscripts' transcriptions, ordered by position in the page and the syntax.';

--

ToponymsList (
  `id_toponym` int(11) NOT NULL COMMENT 'unique ID for each toponym in the text',
  `lat_name` varchar(100) DEFAULT NULL COMMENT 'main placename as given in the text',
  `sec_name` varchar(100) DEFAULT NULL COMMENT 'secondary name as given in the text',
  `en_name` varchar(200) DEFAULT NULL COMMENT 'translation of the placename in English / modern name',
  `type` varchar(20) DEFAULT NULL COMMENT 'typology of places (territories, settlements, geographical features, landmarks, buildings)',
  `location` varchar(20) DEFAULT NULL COMMENT 'level of certainty of the location (certain, uncertain, unknown)',
  `biblical` tinyint(1) NOT NULL COMMENT 'is the site specifically linked to a biblical episode?',
  `geonames` int(10) DEFAULT NULL COMMENT 'Geonames ID: https://www.geonames.org/"#"',
  `pleiades` int(10) DEFAULT NULL COMMENT 'Pleiades ID: https://pleiades.stoa.org/places/"#"',
  `qid` int(11) DEFAULT NULL COMMENT 'Wikidata ID: https://www.wikidata.org/wiki/Q"#"',
  `wibilex` int(10) DEFAULT NULL COMMENT 'wissenschaftliche Bibellexikon im Internet: https://www.bibelwissenschaft.de/stichwort/"#"',
  `corp_huj` varchar(200) DEFAULT NULL COMMENT 'link to the corpus: https://dig.corps-cmhl.huji.ac.il/',
  `atlas_ref` text COMMENT 'some references to printed atlases',
  `latitude` decimal(8,6) DEFAULT NULL,
  `longitude` decimal(9,6) DEFAULT NULL,
  `id_mother` int(3) DEFAULT NULL COMMENT 'ID of the toponym in which the place is directly located',
  `comment` text COMMENT 'analysis of the use of the toponym in the context of Bede''s text'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='index of the toponyms cited in the text.';

--

Translation (
  `id_text` int(2) DEFAULT NULL COMMENT 'edited text ID (from SourceTexts): 11 = Beda DLS',
  `chapter` int(2) DEFAULT NULL COMMENT 'text chapter number',
  `sentence` int(3) NOT NULL DEFAULT '0' COMMENT 'text sentence number',
  `text_fr` text COMMENT 'French translation, organized by sentence'
) 
ENGINE=InnoDB DEFAULT CHARSET=utf8 
COMMENT='contains the French translation of the text, ordered by sentence.';

-------

AlignmentBeda PRIMARY KEY (`id_edition`);
AlignmentToponyms PRIMARY KEY (`topo_nr`);
EditionCorrections PRIMARY KEY (`id_edition`);
Queries PRIMARY KEY (`id_query`);
SiglaCodicum PRIMARY KEY (`id_ms`);
SourceAuthors PRIMARY KEY (`id_author`);
SourceReferences PRIMARY KEY (`id_reference`);
SourceTexts PRIMARY KEY (`id_text`);
SubtokenMss PRIMARY KEY (`id_item`);
ToponymsList PRIMARY KEY (`id_toponym`);
Translation PRIMARY KEY (`sentence`);