API Keys

1import { pgTable, text, timestamp, uuid } from "drizzle-orm/pg-core";
2 
3export const apiKeys = pgTable("api_keys", {
4  id: uuid("id").primaryKey().defaultRandom(),
5  ownerId: text("owner_id").notNull(),
6  name: text("name").notNull(),
7  prefix: text("prefix").notNull(),
8  hash: text("hash").notNull(),
9  scopes: text("scopes").array().notNull().default([]),
10  lastUsedAt: timestamp("last_used_at", { withTimezone: true }),
11  revokedAt: timestamp("revoked_at", { withTimezone: true }),
12  createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
13});