Documentation

---

Documentation / @kizami/db / shiftPlans

Variable: shiftPlans

const shiftPlans: SQLiteTableWithColumns<{ columns: { 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_plans"; }, { }, { }>; 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_plans"; }, { }, { length: number | undefined; }>; periodEnd: 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: "period_end"; notNull: true; tableName: "shift_plans"; }, { }, { length: number | undefined; }>; periodStart: 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: "period_start"; notNull: true; tableName: "shift_plans"; }, { }, { length: number | undefined; }>; publishedAt: 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: "published_at"; notNull: false; tableName: "shift_plans"; }, { }, { }>; publishedBy: 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: "published_by"; notNull: false; tableName: "shift_plans"; }, { }, { 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_plans"; }, { }, { 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_plans"; }, { }, { length: number | undefined; }>; }; dialect: "sqlite"; name: "shift_plans"; schema: undefined; }>

Defined in: packages/db/src/schema/shifts.ts:50

変形期間の器。1 user × 1期間([periodStart, periodEnd])につき高々1件 (同じユーザー・重複する期間の plan を複数作ることは apps/api 側で防ぐ)。 publishedAt が null なら未確定(下書き)。