export const tableFilters = pgTable(
"table_filters",
{
id: text("id").primaryKey(),
userId: varchar("user_id", {
length: 32,
})
.notNull()
.references(() => users.userId),
name: text("name").notNull(),
isDefault: boolean("is_default").default(false).notNull(),
target: text("target").notNull(),
filter: jsonb("filter").$type<Filter>().notNull(),
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow(),
},
(table) => ({
targetUserIdx: index("target_user_idx").on(table.target, table.userId),
}),
);
export const tableFilters = pgTable(
"table_filters",
{
id: text("id").primaryKey(),
userId: varchar("user_id", {
length: 32,
})
.notNull()
.references(() => users.userId),
name: text("name").notNull(),
isDefault: boolean("is_default").default(false).notNull(),
target: text("target").notNull(),
filter: jsonb("filter").$type<Filter>().notNull(),
createdAt: timestamp("created_at").defaultNow().notNull(),
updatedAt: timestamp("updated_at").defaultNow(),
},
(table) => ({
targetUserIdx: index("target_user_idx").on(table.target, table.userId),
}),
);