CREATE TABLE "Tablechild" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "propstr" TEXT NOT NULL
);

CREATE TABLE "Tablemaster" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "propstr" TEXT,
  "propint" INTEGER,
  "propdate" DATETIME,
  "propstrnotnull" TEXT NOT NULL,
  "tablechild" INTEGER NOT NULL REFERENCES "Tablechild" ("id") ON DELETE CASCADE
);

CREATE INDEX "idx_tablemaster__tablechild" ON "Tablemaster" ("tablechild")