Skip to content

armgit / papra

Public Imported from GitHub
0

The minimalistic document archiving platform.

719 B
Raw Blame
import { sqliteTable, text } from 'drizzle-orm/sqlite-core';
import { organizationsTable } from '../organizations/organizations.table';
import { createPrimaryKeyField, createTimestampColumns } from '../shared/db/columns.helpers';
import { DOCUMENT_VIEW_ID_PREFIX } from './document-views.constants';

export const documentViewsTable = sqliteTable('document_views', {
  ...createPrimaryKeyField({ prefix: DOCUMENT_VIEW_ID_PREFIX }),
  ...createTimestampColumns(),

  organizationId: text('organization_id')
    .notNull()
    .references(() => organizationsTable.id, { onDelete: 'cascade', onUpdate: 'cascade' }),
  name: text('name').notNull(),
  query: text('query').notNull(),
  description: text('description'),
});