Open-source status page, incident response and uptime monitoring
TypeScript alertingincident-managementmcpmcp-servermonitoringmonitoring-as-codeobservabilityon-callopen-sourcesrestatus-pagestatuspagesynthetic-monitoringterraformtinybirdtursouptimeuptime-checkeruptime-monitor
import { relations, sql } from "drizzle-orm";
import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
import { pageComponent } from "../page_components";
import { page } from "../pages";
import { workspace } from "../workspaces";
export const pageComponentGroup = sqliteTable(
"page_component_groups",
{
id: integer("id").primaryKey(),
workspaceId: integer("workspace_id")
.references(() => workspace.id, { onDelete: "cascade" })
.notNull(),
pageId: integer("page_id")
.references(() => page.id, { onDelete: "cascade" })
.notNull(),
name: text("name").notNull(),
defaultOpen: integer("default_open", { mode: "boolean" })
.default(false)
.notNull(),
createdAt: integer("created_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
updatedAt: integer("updated_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
},
(t) => [
index("page_component_groups_page_id_idx").on(t.pageId),
index("page_component_groups_workspace_id_idx").on(t.workspaceId),
],
);
export const pageComponentGroupRelations = relations(
pageComponentGroup,
({ one, many }) => ({
workspace: one(workspace, {
fields: [pageComponentGroup.workspaceId],
references: [workspace.id],
}),
page: one(page, {
fields: [pageComponentGroup.pageId],
references: [page.id],
}),
pageComponents: many(pageComponent),
}),
);