Skip to content

snapshots

const snapshots: MySqlTableWithColumns<{ columns: { a11yViolations: 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: "a11y_violations"; notNull: false; tableName: "snapshots"; }, { }, { }>; baselineId: 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: "baseline_id"; notNull: false; tableName: "snapshots"; }, { }, { }>; baselineVersion: 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: "baseline_version"; notNull: false; tableName: "snapshots"; }, { }, { }>; 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: "snapshots"; }, { }, { }>; buildId: 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: "build_id"; notNull: true; tableName: "snapshots"; }, { }, { }>; 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: "snapshots"; }, { }, { }>; designUrl: 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: "design_url"; notNull: false; tableName: "snapshots"; }, { }, { }>; diffPassed: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "diff_passed"; notNull: false; tableName: "snapshots"; }, { }, { }>; diffPath: 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: "diff_path"; notNull: false; tableName: "snapshots"; }, { }, { }>; diffPixels: 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: "diff_pixels"; notNull: false; tableName: "snapshots"; }, { }, { }>; diffRatio: MySqlColumn<{ baseColumn: never; columnType: "MySqlDouble"; data: number; dataType: "number"; driverParam: string | number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "diff_ratio"; notNull: false; tableName: "snapshots"; }, { }, { }>; durationMs: 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: "duration_ms"; notNull: false; tableName: "snapshots"; }, { }, { }>; envChange: 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: "env_change"; notNull: false; tableName: "snapshots"; }, { }, { }>; 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: "snapshots"; }, { }, { }>; infraHash: 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: "infra_hash"; notNull: false; tableName: "snapshots"; }, { }, { }>; inherited: 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: "inherited"; notNull: true; tableName: "snapshots"; }, { }, { }>; mode: 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: "mode"; notNull: false; tableName: "snapshots"; }, { }, { }>; projectId: 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: "project_id"; notNull: true; tableName: "snapshots"; }, { }, { }>; reviewedAt: 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: "reviewed_at"; notNull: false; tableName: "snapshots"; }, { }, { }>; reviewedBy: 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: "reviewed_by"; notNull: false; tableName: "snapshots"; }, { }, { }>; screenshotPath: 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: "screenshot_path"; notNull: true; tableName: "snapshots"; }, { }, { }>; status: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; data: "pending" | "approved" | "rejected" | "new" | "unchanged" | "changed"; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "status"; notNull: true; tableName: "snapshots"; }, { }, { $type: "pending" | "approved" | "rejected" | "new" | "unchanged" | "changed"; }>; storyId: 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: "story_id"; notNull: true; tableName: "snapshots"; }, { }, { }>; storyImportPath: 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: "story_import_path"; notNull: false; tableName: "snapshots"; }, { }, { }>; storyName: 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: "story_name"; notNull: true; tableName: "snapshots"; }, { }, { }>; storyTitle: 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: "story_title"; notNull: true; tableName: "snapshots"; }, { }, { }>; 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: "snapshots"; }, { }, { }>; viewportHeight: 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: "viewport_height"; notNull: true; tableName: "snapshots"; }, { }, { }>; viewportName: 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: "viewport_name"; notNull: true; tableName: "snapshots"; }, { }, { }>; viewportWidth: 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: "viewport_width"; notNull: true; tableName: "snapshots"; }, { }, { }>; }; dialect: "mysql"; name: "snapshots"; schema: undefined; }>

Defined in: packages/db-mysql/src/schema/snapshot.ts:8

Narrow snapshots table definition.