Account Deletion

1import { index, jsonb, pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
2 
3export const accountDeletion = pgTable(
4  "account_deletion",
5  {
6    id: uuid("id").primaryKey().defaultRandom(),
7    ownerId: text("owner_id"),
8    organizationId: text("organization_id"),
9    key: text("key").notNull(),
10    status: text("status").notNull().default("pending"),
11    metadata: jsonb("metadata").$type<Record<string, unknown>>().notNull().default({}),
12    expiresAt: timestamp("expires_at", { withTimezone: true }),
13    completedAt: timestamp("completed_at", { withTimezone: true }),
14    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
15  },
16  (item) => [
17    index("account_deletion_owner_idx").on(item.ownerId),
18    index("account_deletion_organization_idx").on(item.organizationId),
19  ]
20);