CREATE TABLE Entity (
  id     INTEGER PRIMARY KEY,
  name   VARCHAR(100),
  schema VARCHAR(400)
);

CREATE TABLE Field (
  id        INTEGER PRIMARY KEY,
  entity_id INTEGER REFERENCES Entity(id),
  type      VARCHAR(20),
  name      VARCHAR(100)
);


CREATE TABLE Instance (
  id        INTEGER PRIMARY KEY,
  entity_id INTEGER REFERENCES Entity(id),
  data      BLOB
);


CREATE TABLE InstanceField (
  id          INTEGER PRIMARY KEY,
  field_id    INTEGER REFERENCES Field(id),
  instance_id INTEGER REFERENCES Instance(id),
  value       VARCHAR(100)
);