PAThs database schema documentation

This section of the PAThs documentation repository provides a complete documentation of PAThs database schema, currently implemented at db.bradypus.net.

If you are looking for the user & reader guide please follow this link.

The current database engine used by PAThs is Sqlite, «a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world» (https://www.sqlite.org). The DDL describing each table is standard SQL and will work—with minor changes—with other database engines, like MySQL, PostgreSQL, etc.

Table of contents

• The database managing system
• Table list
  1. Manuscripts
  2. Collections
  3. Works
  4. Titles
  5. Colophons
  6. Authors
  7. Places
  8. Persons
  9. Bibliographic database
• Auxiliary tables
  1. m_biblio
  2. m_hands
  3. m_msplaces
  4. m_nameforms
  5. m_placephase
  6. m_quires
  7. m_shelfmarks
  8. m_toponyms
  9. m_nameforms
  10. m_wkauthors
• System tables
  1. Files
  2. Charts
  3. Queries
  4. Rs
  5. Userlinks
  6. Vocabularies