{"code":"import{pgTable,uuid,text,timestamp,integer,index,boolean,jsonb}from\"drizzle-orm/pg-core\";import{companies}from\"./companies.js\";import{agents}from\"./agents.js\";import{issues}from\"./issues.js\";import{projects}from\"./projects.js\";import{goals}from\"./goals.js\";import{heartbeatRuns}from\"./heartbeat_runs.js\";import{costEvents}from\"./cost_events.js\";const financeEvents=pgTable(\"finance_events\",{id:uuid(\"id\").primaryKey().defaultRandom(),companyId:uuid(\"company_id\").notNull().references(()=>companies.id),agentId:uuid(\"agent_id\").references(()=>agents.id),issueId:uuid(\"issue_id\").references(()=>issues.id),projectId:uuid(\"project_id\").references(()=>projects.id),goalId:uuid(\"goal_id\").references(()=>goals.id),heartbeatRunId:uuid(\"heartbeat_run_id\").references(()=>heartbeatRuns.id),costEventId:uuid(\"cost_event_id\").references(()=>costEvents.id),billingCode:text(\"billing_code\"),description:text(\"description\"),eventKind:text(\"event_kind\").notNull(),direction:text(\"direction\").notNull().default(\"debit\"),biller:text(\"biller\").notNull(),provider:text(\"provider\"),executionAdapterType:text(\"execution_adapter_type\"),pricingTier:text(\"pricing_tier\"),region:text(\"region\"),model:text(\"model\"),quantity:integer(\"quantity\"),unit:text(\"unit\"),amountCents:integer(\"amount_cents\").notNull(),currency:text(\"currency\").notNull().default(\"USD\"),estimated:boolean(\"estimated\").notNull().default(false),externalInvoiceId:text(\"external_invoice_id\"),metadataJson:jsonb(\"metadata_json\").$type(),occurredAt:timestamp(\"occurred_at\",{withTimezone:true}).notNull(),createdAt:timestamp(\"created_at\",{withTimezone:true}).notNull().defaultNow()},table=>({companyOccurredIdx:index(\"finance_events_company_occurred_idx\").on(table.companyId,table.occurredAt),companyBillerOccurredIdx:index(\"finance_events_company_biller_occurred_idx\").on(table.companyId,table.biller,table.occurredAt),companyKindOccurredIdx:index(\"finance_events_company_kind_occurred_idx\").on(table.companyId,table.eventKind,table.occurredAt),companyDirectionOccurredIdx:index(\"finance_events_company_direction_occurred_idx\").on(table.companyId,table.direction,table.occurredAt),companyHeartbeatRunIdx:index(\"finance_events_company_heartbeat_run_idx\").on(table.companyId,table.heartbeatRunId),companyCostEventIdx:index(\"finance_events_company_cost_event_idx\").on(table.companyId,table.costEventId)}));export{financeEvents};\n","warnings":[],"map":{"version":3,"mappings":"AAAA,OAAS,QAAS,KAAM,KAAM,UAAW,QAAS,MAAO,QAAS,UAAa,sBAC/E,OAAS,cAAiB,iBAC1B,OAAS,WAAc,cACvB,OAAS,WAAc,cACvB,OAAS,aAAgB,gBACzB,OAAS,UAAa,aACtB,OAAS,kBAAqB,sBAC9B,OAAS,eAAkB,mBAEpB,MAAM,cAAgB,QAC3B,iBACA,CACE,GAAI,KAAK,IAAI,EAAE,WAAW,EAAE,cAAc,EAC1C,UAAW,KAAK,YAAY,EAAE,QAAQ,EAAE,WAAW,IAAM,UAAU,EAAE,EACrE,QAAS,KAAK,UAAU,EAAE,WAAW,IAAM,OAAO,EAAE,EACpD,QAAS,KAAK,UAAU,EAAE,WAAW,IAAM,OAAO,EAAE,EACpD,UAAW,KAAK,YAAY,EAAE,WAAW,IAAM,SAAS,EAAE,EAC1D,OAAQ,KAAK,SAAS,EAAE,WAAW,IAAM,MAAM,EAAE,EACjD,eAAgB,KAAK,kBAAkB,EAAE,WAAW,IAAM,cAAc,EAAE,EAC1E,YAAa,KAAK,eAAe,EAAE,WAAW,IAAM,WAAW,EAAE,EACjE,YAAa,KAAK,cAAc,EAChC,YAAa,KAAK,aAAa,EAC/B,UAAW,KAAK,YAAY,EAAE,QAAQ,EACtC,UAAW,KAAK,WAAW,EAAE,QAAQ,EAAE,QAAQ,OAAO,EACtD,OAAQ,KAAK,QAAQ,EAAE,QAAQ,EAC/B,SAAU,KAAK,UAAU,EACzB,qBAAsB,KAAK,wBAAwB,EACnD,YAAa,KAAK,cAAc,EAChC,OAAQ,KAAK,QAAQ,EACrB,MAAO,KAAK,OAAO,EACnB,SAAU,QAAQ,UAAU,EAC5B,KAAM,KAAK,MAAM,EACjB,YAAa,QAAQ,cAAc,EAAE,QAAQ,EAC7C,SAAU,KAAK,UAAU,EAAE,QAAQ,EAAE,QAAQ,KAAK,EAClD,UAAW,QAAQ,WAAW,EAAE,QAAQ,EAAE,QAAQ,KAAK,EACvD,kBAAmB,KAAK,qBAAqB,EAC7C,aAAc,MAAM,eAAe,EAAE,MAAsC,EAC3E,WAAY,UAAU,cAAe,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EACrE,UAAW,UAAU,aAAc,CAAE,aAAc,IAAK,CAAC,EAAE,QAAQ,EAAE,WAAW,CAClF,EACC,QAAW,CACV,mBAAoB,MAAM,qCAAqC,EAAE,GAAG,MAAM,UAAW,MAAM,UAAU,EACrG,yBAA0B,MAAM,4CAA4C,EAAE,GAC5E,MAAM,UACN,MAAM,OACN,MAAM,UACR,EACA,uBAAwB,MAAM,0CAA0C,EAAE,GACxE,MAAM,UACN,MAAM,UACN,MAAM,UACR,EACA,4BAA6B,MAAM,+CAA+C,EAAE,GAClF,MAAM,UACN,MAAM,UACN,MAAM,UACR,EACA,uBAAwB,MAAM,0CAA0C,EAAE,GACxE,MAAM,UACN,MAAM,cACR,EACA,oBAAqB,MAAM,uCAAuC,EAAE,GAClE,MAAM,UACN,MAAM,WACR,CACF,EACF","names":[],"ignoreList":[],"sources":["/var/www/paperclip.westilt.com/packages/db/src/schema/finance_events.ts"],"sourcesContent":[null]}}