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 { externalService } from "./external_service";
import { externalServiceComponent } from "./external_service_component";
export const externalServiceReport = sqliteTable(
"external_service_report",
{
id: integer("id").primaryKey(),
externalServiceId: integer("external_service_id")
.notNull()
.references(() => externalService.id),
externalServiceComponentId: integer(
"external_service_component_id",
).references(() => externalServiceComponent.id),
reporterHash: text("reporter_hash", { length: 64 }).notNull(),
country: text("country", { length: 2 }).notNull().default(""),
createdAt: integer("created_at", { mode: "timestamp" })
.notNull()
.default(sql`(strftime('%s', 'now'))`),
},
(t) => [
index("external_service_report_service_idx").on(
t.externalServiceId,
t.createdAt,
),
index("external_service_report_component_idx").on(
t.externalServiceComponentId,
t.createdAt,
),
],
);