Appearance
Documentation / @kizami/db / shiftDays
Variable: shiftDays
constshiftDays:SQLiteTableWithColumns<{columns: {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_days"; }, { }, { }>;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_days"; }, { }, { }>;createdBy: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:"created_by";notNull:true;tableName:"shift_days"; }, { }, {length:number|undefined; }>;date: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:"date";notNull:true;tableName:"shift_days"; }, { }, {length:number|undefined; }>;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_days"; }, { }, {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_days"; }, { }, { }>;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_days"; }, { }, {length:number|undefined; }>;patternId: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:"pattern_id";notNull:false;tableName:"shift_days"; }, { }, {length:number|undefined; }>;planId: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:"plan_id";notNull:true;tableName:"shift_days"; }, { }, {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_days"; }, { }, { }>;supersedesId: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:"supersedes_id";notNull:false;tableName:"shift_days"; }, { }, {length:number|undefined; }>;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_days"; }, { }, {length:number|undefined; }>;userId: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:"user_id";notNull:true;tableName:"shift_days"; }, { }, {length:number|undefined; }>; };dialect:"sqlite";name:"shift_days";schema:undefined; }>
Defined in: packages/db/src/schema/shifts.ts:76
user × date の所定(追記専用・supersedes 型)。有効行 = 他のどの行の supersedes_id からも 参照されていない行(NOT EXISTS、packages/db/src/queries/shifts.ts の listValidShiftDaysInRange 参照。punch_events の listValidPunches と同じ解決規則)。