Skip to content

projects

const projects: MySqlTableWithColumns<{ columns: { aiProfile: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; automigrate: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "automigrate"; notNull: true; tableName: "projects"; }, { }, { }>; browser: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; browsers: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; createdAt: MySqlColumn<{ baseColumn: never; columnType: "MySqlCustomColumn"; data: string; dataType: "custom"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "projects"; }, { }, { }>; executePlay: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "execute_play"; notNull: true; tableName: "projects"; }, { }, { }>; gitDefaultBranch: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; gitRepository: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; id: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; maxDiffRatio: MySqlColumn<{ baseColumn: never; columnType: "MySqlDouble"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "max_diff_ratio"; notNull: true; tableName: "projects"; }, { }, { }>; modesAllowlist: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; name: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; pixelThreshold: MySqlColumn<{ baseColumn: never; columnType: "MySqlDouble"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "pixel_threshold"; notNull: true; tableName: "projects"; }, { }, { }>; playTimeoutMs: MySqlColumn<{ baseColumn: never; columnType: "MySqlInt"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "play_timeout_ms"; notNull: true; tableName: "projects"; }, { }, { }>; publicBranchRegex: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; reviewApprovals: MySqlColumn<{ baseColumn: never; columnType: "MySqlInt"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "review_approvals"; notNull: true; tableName: "projects"; }, { }, { }>; reviewEnabled: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "review_enabled"; notNull: true; tableName: "projects"; }, { }, { }>; runA11y: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "run_a11y"; notNull: true; tableName: "projects"; }, { }, { }>; runTests: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "run_tests"; notNull: true; tableName: "projects"; }, { }, { }>; slug: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; storybookMeta: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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; }>; storybookUrlTtlSeconds: MySqlColumn<{ baseColumn: never; columnType: "MySqlInt"; data: number; dataType: "number"; driverParam: string | 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: MySqlColumn<{ baseColumn: never; columnType: "MySqlCustomColumn"; data: string; dataType: "custom"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updated_at"; notNull: true; tableName: "projects"; }, { }, { }>; viewports: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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"; }, { }, { }>; }; dialect: "mysql"; name: "projects"; schema: undefined; }>

Defined in: packages/db-mysql/src/schema/project.ts:5

Narrow projects table definition.