CREATE TABLE paths__colophons (
id INTEGER PRIMARY KEY, -- primary key
creator TEXT, -- automatically filled by the RDBMS with the current user id
msid TEXT REFERENCES paths__manuscripts (id), -- foreign key: manuscripts.id
chronofrom TEXT,
chronoto TEXT,
datingcriteria TEXT,
donationistitution TEXT,
istitutionplace INTEGER, -- places.id
dialect TEXT, -- semi-colon-separated-values: vocabularies.def = 'dialects'
dialectnotes TEXT,
greektext TEXT,
writingaxis TEXT, -- vocabularies.def = 'dialects'
thickandthin TEXT, -- 1|0
cryptography TEXT, -- 1|0
minusculecopitc TEXT, -- 1|0
minusculegreek TEXT, -- 1|0
description TEXT,
text TEXT,
translation TEXT,
taggedtext TEXT,
editors VARCHAR(255), -- semi-colon-separated-values: vocabularies.def = 'persons'
status, VARCHAR(255) -- vocabularies.def = 'status'
lastmodified TEXT
);