lib/db/src/schema/savedLists.ts

import { pgTable, text, timestamp, serial, jsonb } from "drizzle-orm/pg-core";

export const savedListsTable = pgTable("saved_lists", {
  id: serial("id").primaryKey(),
  userId: text("user_id").notNull(),
  name: text("name").notNull(),
  groupIds: jsonb("group_ids").$type<string[]>().notNull(),
  createdAt: timestamp("created_at").notNull().defaultNow(),
});

export type SavedList = typeof savedListsTable.$inferSelect;