Appearance
Documentation / @kizami/db / shiftPatterns
Variable: shiftPatterns
constshiftPatterns:SQLiteTableWithColumns<{columns: {archivedAt: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:"archived_at";notNull:false;tableName:"shift_patterns"; }, { }, { }>;breakMinutes: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:"break_minutes";notNull:true;tableName:"shift_patterns"; }, { }, { }>;createdAt: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:"created_at";notNull:true;tableName:"shift_patterns"; }, { }, { }>;dayType: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:"day_type";notNull:true;tableName:"shift_patterns"; }, { }, {length:number|undefined; }>;endMinutes: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:"end_minutes";notNull:true;tableName:"shift_patterns"; }, { }, { }>;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:"shift_patterns"; }, { }, {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:"shift_patterns"; }, { }, {length:number|undefined; }>;startMinutes: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:"start_minutes";notNull:true;tableName:"shift_patterns"; }, { }, { }>;tenantId: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:"tenant_id";notNull:true;tableName:"shift_patterns"; }, { }, {length:number|undefined; }>; };dialect:"sqlite";name:"shift_patterns";schema:undefined; }>
Defined in: packages/db/src/schema/shifts.ts:23
シフトパターン(早番/遅番/休み等)の定義。archivedAt が null なら使用可能。 過去に割り当てた shift_days.pattern_id が指す行は archivedAt 後も残す(履歴保護のため 物理削除しない — punch_events 系と同じ「追記専用ログは消さない」方針)。