Bug Reports

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