{"code":"import{sql}from\"drizzle-orm\";import{index,integer,pgTable,text,timestamp,uuid,uniqueIndex}from\"drizzle-orm/pg-core\";import{approvals}from\"./approvals.js\";import{budgetPolicies}from\"./budget_policies.js\";import{companies}from\"./companies.js\";const budgetIncidents=pgTable(\"budget_incidents\",{id:uuid(\"id\").primaryKey().defaultRandom(),companyId:uuid(\"company_id\").notNull().references(()=>companies.id),policyId:uuid(\"policy_id\").notNull().references(()=>budgetPolicies.id),scopeType:text(\"scope_type\").notNull(),scopeId:uuid(\"scope_id\").notNull(),metric:text(\"metric\").notNull(),windowKind:text(\"window_kind\").notNull(),windowStart:timestamp(\"window_start\",{withTimezone:true}).notNull(),windowEnd:timestamp(\"window_end\",{withTimezone:true}).notNull(),thresholdType:text(\"threshold_type\").notNull(),amountLimit:integer(\"amount_limit\").notNull(),amountObserved:integer(\"amount_observed\").notNull(),status:text(\"status\").notNull().default(\"open\"),approvalId:uuid(\"approval_id\").references(()=>approvals.id),resolvedAt:timestamp(\"resolved_at\",{withTimezone:true}),createdAt:timestamp(\"created_at\",{withTimezone:true}).notNull().defaultNow(),updatedAt:timestamp(\"updated_at\",{withTimezone:true}).notNull().defaultNow()},table=>({companyStatusIdx:index(\"budget_incidents_company_status_idx\").on(table.companyId,table.status),companyScopeIdx:index(\"budget_incidents_company_scope_idx\").on(table.companyId,table.scopeType,table.scopeId,table.status),policyWindowIdx:uniqueIndex(\"budget_incidents_policy_window_threshold_idx\").on(table.policyId,table.windowStart,table.thresholdType).where(sql`${table.status} <> 'dismissed'`)}));export{budgetIncidents};\n","warnings":[],"map":{"version":3,"mappings":"AAAA,OAAS,QAAW,cACpB,OAAS,MAAO,QAAS,QAAS,KAAM,UAAW,KAAM,gBAAmB,sBAC5E,OAAS,cAAiB,iBAC1B,OAAS,mBAAsB,uBAC/B,OAAS,cAAiB,iBAEnB,MAAM,gBAAkB,QAC7B,mBACA,CACE,GAAI,KAAK,IAAI,EAAE,WAAW,EAAE,cAAc,EAC1C,UAAW,KAAK,YAAY,EAAE,QAAQ,EAAE,WAAW,IAAM,UAAU,EAAE,EACrE,SAAU,KAAK,WAAW,EAAE,QAAQ,EAAE,WAAW,IAAM,eAAe,EAAE,EACxE,UAAW,KAAK,YAAY,EAAE,QAAQ,EACtC,QAAS,KAAK,UAAU,EAAE,QAAQ,EAClC,OAAQ,KAAK,QAAQ,EAAE,QAAQ,EAC/B,WAAY,KAAK,aAAa,EAAE,QAAQ,EACxC,YAAa,UAAU,eAAgB,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EACvE,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EACnE,cAAe,KAAK,gBAAgB,EAAE,QAAQ,EAC9C,YAAa,QAAQ,cAAc,EAAE,QAAQ,EAC7C,eAAgB,QAAQ,iBAAiB,EAAE,QAAQ,EACnD,OAAQ,KAAK,QAAQ,EAAE,QAAQ,EAAE,QAAQ,MAAM,EAC/C,WAAY,KAAK,aAAa,EAAE,WAAW,IAAM,UAAU,EAAE,EAC7D,WAAY,UAAU,cAAe,CAAE,aAAc,IAAK,CAAC,EAC3D,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,EAChF,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,CAClF,EACC,QAAW,CACV,iBAAkB,MAAM,qCAAqC,EAAE,GAAG,MAAM,UAAW,MAAM,MAAM,EAC/F,gBAAiB,MAAM,oCAAoC,EAAE,GAC3D,MAAM,UACN,MAAM,UACN,MAAM,QACN,MAAM,MACR,EACA,gBAAiB,YAAY,8CAA8C,EAAE,GAC3E,MAAM,SACN,MAAM,YACN,MAAM,aACR,EAAE,MAAM,MAAM,MAAM,MAAM,iBAAiB,CAC7C,EACF","names":[],"ignoreList":[],"sources":["/var/www/paperclip.westilt.com/packages/db/src/schema/budget_incidents.ts"],"sourcesContent":[null]}}