PAThs.docs
Tracking Papyrus and Parchment Paths.
An Archaeological Atlas of Coptic Literature.

PAThs’ database managing system

PAThs’ database managing system

This document lists a verbose description of the relationship of the different entities of the database, which are:

  • Manuscripts
  • Collections
  • Works
  • Titles
  • Colophons
  • Authors
  • Places
  • Bibliographic database
  • Files

Manuscripts

  • A Manuscript (ie. Codicological Unit) is composed by one or many fragments, identified by a Collection name, a Shelfmark number and eventually by page numbers

  • A Manuscript is linked to zero, one or many Places; for each connection a type (production, storage or discovery) must be specified

  • A Manuscript is made up of one or many quires.

  • A Manuscript is linked to zero, one or many Bibliographical records

  • A Manuscript is linked to zero, one or many Works

  • A Manuscript contains zero, one or many Titles

  • A Manuscript contains zero, one or many Colophons

  • A Manuscript can be linked to zero, one or many Files


Collections

  • A Collection is linked to zero, one or many Bibliographical records

  • A Collection can be linked to zero, one or many Files


Works

  • A Work is linked to zero, one or many Bibliographical records

  • A Work is written by zero, one or many Authors; for each connection an authorship type (stated, creator or master) must be specified

  • A Work can be paired by zero, one or many Titles

  • A Work can be linked to zero, one or many Files

  • (A Works is contained in one or many Manuscripts)


Titles

  • A Title is linked to zero, one or many Bibliographical records

  • A Title is contained in one or many fragments, identified by a Collection name, a Shelfmark number and eventually by page numbers.

  • A Title can be linked to zero, one or many Files

  • (A Title is contained in one Manuscript)


Colophons

  • A Colophon is linked to zero, one or many Bibliographical records

  • A Colophon is contained in one or many fragments, identified by a Collection name, a Shelfmark number and eventually by page numbers

  • A Colophon can be linked to zero, one or many Files

  • (A Colophon is contained in one Manuscript)


Places

  • A Place is linked to zero, one or many Bibliographical records

  • A Place can have one or many Chronological phases

  • A Place can be linked to zero, one or many Files

  • A Place have one or many Geodata

  • (A Place can be linked to zero, one or many Manuscripts)

  • [A Place can have one or many Toponyms]


Bibliographic record

  • (A Bibliographic record can be linked to zero, one or many Manuscripts)

  • (A Bibliographic record can be linked to zero, one or many Collections)

  • (A Bibliographic record can be linked to zero, one or many Works)

  • (A Bibliographic record can be linked to zero, one or many Titles)

  • (A Bibliographic record can be linked to zero, one or many Colophons)

  • (A Bibliographic record can be linked to zero, one or many Places)

  • (A Bibliographic record can be linked to zero, one or many Files)


Files

  • (A File can be linked to zero, one or many Manuscripts)

  • (A File can be linked to zero, one or many Collections)

  • (A File can be linked to zero, one or many Works)

  • (A File can be linked to zero, one or many Titles)

  • (A File can be linked to zero, one or many Colophons)

  • (A File can be linked to zero, one or many Places)

  • (A File can be linked to zero, one or many Bibliographic record)