openstatus.dev
Openstatus
www.openstatus.dev
1import { sql } from "drizzle-orm";
2import { integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
3
4import { page } from "../pages";
5import { workspace } from "../workspaces";
6
7export const monitorGroup = sqliteTable("monitor_group", {
8 id: integer("id").primaryKey(),
9 workspaceId: integer("workspace_id")
10 .references(() => workspace.id, { onDelete: "cascade" })
11 .notNull(),
12 pageId: integer("page_id")
13 .references(() => page.id, { onDelete: "cascade" })
14 .notNull(),
15 name: text("name").notNull(),
16
17 createdAt: integer("created_at", { mode: "timestamp" }).default(
18 sql`(strftime('%s', 'now'))`,
19 ),
20 updatedAt: integer("updated_at", { mode: "timestamp" }).default(
21 sql`(strftime('%s', 'now'))`,
22 ),
23});