Skip to content

projects

const projects: SQLiteTableWithColumns<{ columns: { aiProfile: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "ai_profile"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; automigrate: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "automigrate"; notNull: true; tableName: "projects"; }, { }, { }>; browser: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "browser"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; browsers: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "browsers"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; createdAt: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; executePlay: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "execute_play"; notNull: true; tableName: "projects"; }, { }, { }>; gitDefaultBranch: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "git_default_branch"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; gitRepository: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "git_repository"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; id: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: true; name: "id"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; maxDiffRatio: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteReal"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "max_diff_ratio"; notNull: true; tableName: "projects"; }, { }, { }>; modesAllowlist: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "modes_allowlist"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; name: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "name"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; pixelThreshold: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteReal"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "pixel_threshold"; notNull: true; tableName: "projects"; }, { }, { }>; playTimeoutMs: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "play_timeout_ms"; notNull: true; tableName: "projects"; }, { }, { }>; publicBranchRegex: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "public_branch_regex"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; reviewApprovals: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "review_approvals"; notNull: true; tableName: "projects"; }, { }, { }>; reviewEnabled: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "review_enabled"; notNull: true; tableName: "projects"; }, { }, { }>; runA11y: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "run_a11y"; notNull: true; tableName: "projects"; }, { }, { }>; runTests: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "run_tests"; notNull: true; tableName: "projects"; }, { }, { }>; slug: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "slug"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; storybookMeta: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string | null | undefined; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "storybook_meta"; notNull: false; tableName: "projects"; }, { }, { $type: string | null | undefined; length: number | undefined; }>; storybookUrlTtlSeconds: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "storybook_url_ttl_seconds"; notNull: false; tableName: "projects"; }, { }, { }>; updatedAt: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updated_at"; notNull: true; tableName: "projects"; }, { }, { length: number | undefined; }>; viewports: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "viewports"; notNull: false; tableName: "projects"; }, { }, { length: number | undefined; }>; }; dialect: "sqlite"; name: "projects"; schema: undefined; }>

Defined in: packages/db-sqlite/src/schema/project.ts:4

Narrow projects table definition.