Skip to content

snapshots

const snapshots: PgTableWithColumns<{ columns: { a11yViolations: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "snapshots"; }, { }, { }>; designUrl: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgBoolean"; data: boolean; dataType: "boolean"; driverParam: boolean; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "diff_passed"; notNull: false; tableName: "snapshots"; }, { }, { }>; diffPath: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgInteger"; 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: PgColumn<{ baseColumn: never; columnType: "PgDoublePrecision"; 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: PgColumn<{ baseColumn: never; columnType: "PgInteger"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgBoolean"; data: boolean; dataType: "boolean"; driverParam: boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "inherited"; notNull: true; tableName: "snapshots"; }, { }, { }>; mode: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "reviewed_at"; notNull: false; tableName: "snapshots"; }, { }, { }>; reviewedBy: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updated_at"; notNull: true; tableName: "snapshots"; }, { }, { }>; viewportHeight: PgColumn<{ baseColumn: never; columnType: "PgInteger"; 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: PgColumn<{ baseColumn: never; columnType: "PgText"; 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: PgColumn<{ baseColumn: never; columnType: "PgInteger"; 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: "pg"; name: "snapshots"; schema: undefined; }>

Defined in: packages/db-postgres/src/schema/snapshot.ts:16

Narrow snapshots table definition.