Account Modes

1import { index, jsonb, pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
2 
3export const accountModes = pgTable(
4  "account_modes",
5  {
6    id: uuid("id").primaryKey().defaultRandom(),
7    accountId: text("account_id").notNull(),
8    mode: text("mode").notNull().default("personal"),
9    status: text("status").notNull().default("active"),
10    metadata: jsonb("metadata").$type<Record<string, unknown>>().notNull().default({}),
11    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
12    updatedAt: timestamp("updated_at", { withTimezone: true }).defaultNow().notNull(),
13  },
14  (item) => [index("account_modes_account_idx").on(item.accountId)]
15);