charts
Data license: CC-BY
0 rows where publishedByUserId = 15 sorted by id descending
This data as json
0 records
CREATE TABLE "charts" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "slug" VARCHAR(255) NULL , "type" VARCHAR(255) NULL , "config" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "lastEditedAt" DATETIME NOT NULL , "publishedAt" DATETIME NULL , "lastEditedByUserId" INTEGER NOT NULL , "publishedByUserId" INTEGER NULL , "isIndexable" TINYINT NOT NULL DEFAULT '0', title TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.title')) VIRTUAL, subtitle TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.subtitle')) VIRTUAL, note TEXT GENERATED ALWAYS as (JSON_EXTRACT(config, '$.note')) VIRTUAL, title_plus_variant GENERATED ALWAYS as (printf("%s (%s)", title, json_extract(config, "$.variantName"))) VIRTUAL, configWithDefaults json, FOREIGN KEY("lastEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("publishedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "charts_lastEditedByUserId" ON "charts" ("lastEditedByUserId"); CREATE INDEX "charts_publishedByUserId" ON "charts" ("publishedByUserId"); CREATE INDEX "charts_slug" ON "charts" ("slug"); CREATE INDEX idx_title_plus_variant ON charts(title_plus_variant);