Audit Log

1import { index, jsonb, pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
2 
3export const auditLogEvents = pgTable(
4  "audit_log_events",
5  {
6    id: uuid("id").primaryKey().defaultRandom(),
7    actorId: text("actor_id"),
8    actorType: text("actor_type").notNull().default("user"),
9    action: text("action").notNull(),
10    resourceType: text("resource_type").notNull(),
11    resourceId: text("resource_id"),
12    organizationId: text("organization_id"),
13    metadata: jsonb("metadata").$type<Record<string, unknown>>().notNull().default({}),
14    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
15  },
16  (table) => [
17    index("audit_log_events_org_idx").on(table.organizationId),
18    index("audit_log_events_resource_idx").on(table.resourceType, table.resourceId),
19  ]
20);