The minimalistic document archiving platform.
import { EVENT_NAMES } from '@papra/webhooks';
import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';
import { organizationsTable } from '../organizations/organizations.table';
import { createPrimaryKeyField, createTimestampColumns } from '../shared/db/columns.helpers';
import { usersTable } from '../users/users.table';
import { WEBHOOK_ID_PREFIX } from './webhooks.constants';
export const webhooksTable = sqliteTable('webhooks', {
...createPrimaryKeyField({ prefix: WEBHOOK_ID_PREFIX }),
...createTimestampColumns(),
name: text('name').notNull(),
url: text('url').notNull(),
secret: text('secret'),
enabled: integer('enabled', { mode: 'boolean' }).notNull().default(true),
createdBy: text('created_by').references(() => usersTable.id, {
onDelete: 'set null',
onUpdate: 'cascade',
}),
organizationId: text('organization_id').references(() => organizationsTable.id, {
onDelete: 'cascade',
onUpdate: 'cascade',
}),
});
export const webhookEventsTable = sqliteTable('webhook_events', {
...createPrimaryKeyField({ prefix: 'wbh_ev' }),
...createTimestampColumns(),
webhookId: text('webhook_id')
.notNull()
.references(() => webhooksTable.id, { onDelete: 'cascade', onUpdate: 'cascade' }),
eventName: text('event_name', { enum: EVENT_NAMES }).notNull(),
});
export const webhookDeliveriesTable = sqliteTable('webhook_deliveries', {
...createPrimaryKeyField({ prefix: 'wbh_dlv' }),
...createTimestampColumns(),
webhookId: text('webhook_id')
.notNull()
.references(() => webhooksTable.id, { onDelete: 'cascade', onUpdate: 'cascade' }),
eventName: text('event_name').notNull(),
requestPayload: text('request_payload').notNull(),
responsePayload: text('response_payload').notNull(),
responseStatus: integer('response_status').notNull(),
});