Schema for f7

CREATE TABLE "f7" (
"notice_date" TEXT,
  "initiated_date" TEXT,
  "employer" TEXT,
  "employer_street" TEXT,
  "employer_city" TEXT,
  "employer_state" TEXT,
  "employer_zip" TEXT,
  "employer_representative" TEXT,
  "employer_representative_phone" TEXT,
  "employer_representative_title" TEXT,
  "employer_representative_email" TEXT,
  "union_name" TEXT,
  "union_street" TEXT,
  "union_city" TEXT,
  "union_state" TEXT,
  "union_zip" TEXT,
  "union_representative" TEXT,
  "union_representative_phone" TEXT,
  "union_representative_title" TEXT,
  "union_representative_email" TEXT,
  "affected_location_city" TEXT,
  "affected_location_state" TEXT,
  "affected_location_zip" TEXT,
  "expiration_date" TEXT,
  "naics" INTEGER,
  "industry" TEXT,
  "bargaining_unit_size" INTEGER,
  "establishment_size" INTEGER,
  "notice_submitted_by" TEXT,
  "category" TEXT,
  "healthcare_related" INTEGER,
  "location_negotiation_city" TEXT,
  "location_negotiation_state" TEXT,
  "location_negotiation_zip" TEXT
);
CREATE TABLE 'f7_fts_data'(id INTEGER PRIMARY KEY, block BLOB);
CREATE TABLE 'f7_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;
CREATE TABLE 'f7_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB);
CREATE TABLE 'f7_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID;
CREATE TABLE sqlite_stat1(tbl,idx,stat);
CREATE VIRTUAL TABLE [f7_fts] USING FTS5 (
    [union_name], [union_street], [union_city], [union_state], [union_zip],
    content=[f7]
)