CMS / foldkit-cms-drizzle

sqliteTables

function · packages/cms-drizzle/src/tables.ts:16

function sqliteTables(): { entries: SQLiteTableWithColumns<{ name: "cms_entries"; schema: undefined; columns: { id: SQLiteColumn<{ name: string; tableName: "cms_entries"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: true; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; type: SQLiteColumn<{ name: string; tableName: "cms_entries"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; targetId: SQLiteColumn<{ name: string; tableName: "cms_entries"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; label: SQLiteColumn<{ name: string; tableName: "cms_entries"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: [string, ...string[]]; baseColumn: never; identity: undefined; generated: undefined; }, {}>; createdBy: SQLiteColumn<{ name: string; tableName: "cms_entries"; dataType: "string"; data: string; driver …;

cms_entries: a piece of content from first keystroke to archive. It exists before its content row does.
cms_drafts: an entry's one working copy; its id is the entry's.
cms_revisions: published values, append-only.