Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/openstatusHQ/openstatus. 🫖 Status page with uptime monitoring & API monitoring as code 🫖 openstatus.dev
bun drizzle-orm monitoring monitoring-as-code nextjs observability on-call open-source shadcn-ui status-page statuspage synthetic-monitoring tinybird turso uptime uptime-checker uptime-monitor
Something went wrong. Try again.
1.6 kB · 45 lines
TypeScript
at incident-api
12345678910111213141516171819202122232425262728293031323334353637383940414243444546import { relations, sql } from "drizzle-orm";import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";import { createInsertSchema, createSelectSchema } from "drizzle-zod";import type { z } from "zod";
import { workspace } from "./workspace";
export const workspaceSsoDomain = sqliteTable( "workspace_sso_domain", { id: integer("id").primaryKey(), workspaceId: integer("workspace_id") .notNull() .references(() => workspace.id, { onDelete: "cascade" }), // Globally unique: two workspaces claiming the same domain would make the // login-time lookup ambiguous, which is an account-takeover vector. domain: text("domain").notNull().unique(), // Only ever written from the `organization_domain.verified` webhook. verifiedAt: integer("verified_at", { mode: "timestamp" }), createdAt: integer("created_at", { mode: "timestamp" }).default( sql`(strftime('%s', 'now'))`, ), }, (t) => [index("workspace_sso_domain_workspace_id_idx").on(t.workspaceId)],);
export const workspaceSsoDomainRelations = relations( workspaceSsoDomain, ({ one }) => ({ workspace: one(workspace, { fields: [workspaceSsoDomain.workspaceId], references: [workspace.id], }), }),);
export const insertWorkspaceSsoDomainSchema = createInsertSchema(workspaceSsoDomain);export const selectWorkspaceSsoDomainSchema = createSelectSchema(workspaceSsoDomain);
export type WorkspaceSsoDomain = z.infer<typeof selectWorkspaceSsoDomainSchema>;export type InsertWorkspaceSsoDomain = z.infer< typeof insertWorkspaceSsoDomainSchema>;