Open-source status page, incident response and uptime monitoring
TypeScript alertingincident-managementmcpmcp-servermonitoringmonitoring-as-codeobservabilityon-callopen-sourcesrestatus-pagestatuspagesynthetic-monitoringterraformtinybirdtursouptimeuptime-checkeruptime-monitor
import { relations } from "drizzle-orm";
import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
import { monitorStatus } from "../monitors/constants";
import { monitor } from "../monitors/monitor";
export const monitorTransition = sqliteTable(
"monitor_transition",
{
id: integer("id").primaryKey(),
monitorId: integer("monitor_id")
.notNull()
.references(() => monitor.id, { onDelete: "cascade" }),
region: text("region").notNull(),
cronTimestamp: integer("cron_timestamp").notNull(),
fromStatus: text("from_status", { enum: monitorStatus }).notNull(),
toStatus: text("to_status", { enum: monitorStatus }).notNull(),
quorumCount: integer("quorum_count").notNull(),
regionCount: integer("region_count").notNull(),
transitioned: integer("transitioned", { mode: "boolean" }).notNull(),
outboxRows: integer("outbox_rows").default(0).notNull(),
createdAt: integer("created_at").notNull(),
},
(t) => [
index("monitor_transition_monitor_id_cron_timestamp_idx").on(
t.monitorId,
t.cronTimestamp,
),
index("monitor_transition_created_at_idx").on(t.createdAt),
],
);
export const monitorTransitionRelations = relations(
monitorTransition,
({ one }) => ({
monitor: one(monitor, {
fields: [monitorTransition.monitorId],
references: [monitor.id],
}),
}),
);