schema.sql

CREATE TABLE entities (
  id SERIAL PRIMARY KEY,
  time INT4RANGE,
  class SMALLINT NOT NULL
);

CREATE TABLE documents (
  id SERIAL PRIMARY KEY,
  language INT2 NOT NULL,
  raw TEXT NOT NULL,
  rendered TEXT NOT NULL
);

CREATE TABLE characters (
  id SERIAL PRIMARY KEY,
  entity_id INTEGER NOT NULL REFERENCES entities,
  name VARCHAR(80) NOT NULL,
  history INTEGER NOT NULL REFERENCES documents
);

CREATE TABLE relationships (
  id SERIAL PRIMARY KEY,
  origin INTEGER NOT NULL REFERENCES characters,
  destination INTEGER NOT NULL REFERENCES characters,
  during INT4RANGE,
  description INTEGER NOT NULL REFERENCES documents
);