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

m_msplaces

m_msplaces

m_msplaces is a junction table that servers the purpose of linking one or more records of any table Manuscripts to one or more records of table Places

DDL

CREATE TABLE paths__m_msplaces (
  id          INTEGER PRIMARY KEY, -- primary key
  table_link  TEXT, -- dynamic foreign key, combined with id_link
  id_link     INTEGER, -- dynamic foreign key, combined with table_link
  type        TEXT,
  place       INTEGER,
  sourceinfo  TEXT,
  sourcenotes TEXT,
  sort        INTEGER
);
  • Manuscripts >— m_msplaces —< Places