Open-source AI coworkers that each get a computer of their own: a browser, files and tools, with every action decided before it happens and recorded after. Bring any AG-UI agent.
import type { VoiceTranscriptEntry } from "@openbot/shared/voice-session";
import { sql } from "drizzle-orm";
import {
check,
index,
integer,
pgTable,
text,
timestamp,
} from "drizzle-orm/pg-core";
import { channels, users } from "./core";
import { jsonb } from "./json";
/** Spoken conversations are durable even when no agent/tool run was needed. */
export const voiceSessions = pgTable(
"voice_sessions",
{
id: text("id").primaryKey(),
channelId: text("channel_id")
.notNull()
.references(() => channels.id, { onDelete: "cascade" }),
userId: text("user_id")
.notNull()
.references(() => users.id, { onDelete: "cascade" }),
anchorMessageId: text("anchor_message_id"),
startedAt: timestamp("started_at", { withTimezone: true }).notNull(),
endedAt: timestamp("ended_at", { withTimezone: true }).notNull(),
durationSeconds: integer("duration_seconds").notNull(),
transcript: jsonb("transcript")
.$type<{ entries: VoiceTranscriptEntry[] }>()
.notNull(),
summary: text("summary"),
summaryStatus: text("summary_status")
.$type<"ready" | "failed">()
.notNull()
.default("failed"),
},
(table) => [
index("voice_sessions_channel_started_idx").on(
table.channelId,
table.startedAt,
table.id,
),
check("voice_sessions_duration_check", sql`${table.durationSeconds} >= 0`),
check(
"voice_sessions_summary_check",
sql`(${table.summaryStatus} = 'ready' AND ${table.summary} IS NOT NULL) OR (${table.summaryStatus} = 'failed' AND ${table.summary} IS NULL)`,
),
],
);