KIZAMI

Appearance

Documentation

Documentation / @kizami/db / tenantSettingVersions

Variable: tenantSettingVersions ​

const tenantSettingVersions: SQLiteTableWithColumns<{ columns: { breakRule: 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: "break_rule"; notNull: true; tableName: "tenant_setting_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: "tenant_setting_versions"; }, { }, { }>; dayBoundaryMinutes: 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: "day_boundary_minutes"; notNull: true; tableName: "tenant_setting_versions"; }, { }, { }>; 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: "tenant_setting_versions"; }, { }, { length: number | undefined; }>; gpsEnabled: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteBoolean"; data: boolean; dataType: "boolean"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "gps_enabled"; notNull: true; tableName: "tenant_setting_versions"; }, { }, { }>; gpsRetentionDays: 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: "gps_retention_days"; notNull: false; tableName: "tenant_setting_versions"; }, { }, { }>; 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: "tenant_setting_versions"; }, { }, { length: number | undefined; }>; legalHolidayRule: 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: "legal_holiday_rule"; notNull: true; tableName: "tenant_setting_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: "tenant_setting_versions"; }, { }, { length: number | undefined; }>; variablePeriodStartDay: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "variable_period_start_day"; notNull: true; tableName: "tenant_setting_versions"; }, { }, { }>; weekStartWeekday: SQLiteColumn<{ baseColumn: never; columnType: "SQLiteInteger"; data: number; dataType: "number"; driverParam: number; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "week_start_weekday"; notNull: true; tableName: "tenant_setting_versions"; }, { }, { }>; }; dialect: "sqlite"; name: "tenant_setting_versions"; schema: undefined; }>

Defined in: packages/db/src/schema/settings.ts:23

テナント設定の版(追記専用)。

legalHolidayRule / breakRule は型付き構造(packages/engine の LegalHolidayRule / CalcSettings["breakRule"] 相当)を JSON 文字列として保持する。DB 層は中身を解釈しない。