PRAGMA foreign_keys = ON;
PRAGMA foreign_keys;

DROP TABLE if exists Sequence;
DROP TABLE if exists SubSequence;


CREATE TABLE Sequence (
  ID INTEGER RIMARY KEY,
  description TEXT,
  string TEXT
);

CREATE TABLE SubSequence (
  ID INTEGER RIMARY KEY,
  string TEXT,
  position INTEGER,
  FOREIGN KEY(baseString) REFERENCES Sequence(ID)
);

$