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,
unique,
} from "drizzle-orm/sqlite-core";
import { user } from "../users";
import { workspace } from "../workspaces";
export const slackUser = sqliteTable(
"slack_user",
{
id: integer("id").primaryKey({ autoIncrement: true }),
workspaceId: integer("workspace_id")
.notNull()
.references(() => workspace.id, { onDelete: "cascade" }),
slackTeamId: text("slack_team_id").notNull(),
slackUserId: text("slack_user_id").notNull(),
userId: integer("user_id")
.notNull()
.references(() => user.id),
createdAt: integer("created_at", { mode: "timestamp" })
.notNull()
.default(sql`(strftime('%s', 'now'))`),
},
(t) => [
unique().on(t.workspaceId, t.slackTeamId, t.slackUserId),
index("slack_user_user_id_idx").on(t.userId),
],
);
export const slackUserRelations = relations(slackUser, ({ one }) => ({
workspace: one(workspace, {
fields: [slackUser.workspaceId],
references: [workspace.id],
}),
user: one(user, {
fields: [slackUser.userId],
references: [user.id],
}),
}));