Billing Core

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