Skip to content

Documentation


Documentation / @kizami/db / allowanceDefinitionVersions

Variable: allowanceDefinitionVersions

const allowanceDefinitionVersions: SQLiteTableWithColumns<{ columns: { conditions: 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: "conditions"; notNull: true; tableName: "allowance_definition_versions"; }, { }, { length: number | undefined; }>; 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: "allowance_definition_versions"; }, { }, { }>; definitionId: 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: "definition_id"; notNull: true; tableName: "allowance_definition_versions"; }, { }, { length: number | undefined; }>; effectiveFrom: 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: "effective_from"; notNull: true; tableName: "allowance_definition_versions"; }, { }, { length: number | undefined; }>; 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: "allowance_definition_versions"; }, { }, { 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: "allowance_definition_versions"; }, { }, { 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: "allowance_definition_versions"; }, { }, { length: number | undefined; }>; }; dialect: "sqlite"; name: "allowance_definition_versions"; schema: undefined; }>

Defined in: packages/db/src/schema/allowances.ts:41

allowance_definitions の版(追記専用)。conditions は engine の AllowanceDefinition["conditions"]({ dates?, weekdays?, timeBand? })の JSON 文字列表現。 DB 層は中身を解釈しない(tenantSettingVersions.legalHolidayRule と同じ流儀)。