Open-source status page, incident response and uptime monitoring
TypeScript alertingincident-managementmcpmcp-servermonitoringmonitoring-as-codeobservabilityon-callopen-sourcesrestatus-pagestatuspagesynthetic-monitoringterraformtinybirdtursouptimeuptime-checkeruptime-monitor
import { sql } from "drizzle-orm";
import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
import {
type ApiConfig,
type Industry,
STATUS_PAGE_PROVIDERS,
} from "./constants";
export const externalService = sqliteTable(
"external_service",
{
id: integer("id").primaryKey(),
slug: text("slug", { length: 64 }).notNull().unique(),
aliases: text("aliases", { mode: "json" })
.$type<string[]>()
.default(sql`(json_array())`)
.notNull(),
name: text("name", { length: 256 }).notNull(),
url: text("url").notNull(),
statusPageUrl: text("status_page_url").notNull(),
provider: text("provider", { enum: STATUS_PAGE_PROVIDERS }).notNull(),
industry: text("industry", { mode: "json" }).$type<Industry[]>().notNull(),
description: text("description"),
apiConfig: text("api_config", { mode: "json" }).$type<ApiConfig>(),
deletedAt: integer("deleted_at", { mode: "timestamp" }),
createdAt: integer("created_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
updatedAt: integer("updated_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
},
(t) => [index("external_service_deleted_at_idx").on(t.deletedAt)],
);