snapshots
constsnapshots: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.