CREATE TABLE "appliances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "brand" varchar, "category" varchar, "model" varchar, "name" varchar, "description" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
CREATE TABLE "spec_keys" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "dimension" integer DEFAULT 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)
CREATE TABLE "item_specs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "appliance_id" integer NOT NULL, "spec_key_id" integer NOT NULL, "value_text" varchar, "value_integer" integer, "value_double" float, "value_boolean" boolean, "value_date" date, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)