gui.do
Sifa professional network API (Fastify, AT Protocol, Jetstream)
sifa.id/
1import { pgTable, text, timestamp, primaryKey, index } from 'drizzle-orm/pg-core';
2
3export const invites = pgTable(
4 'invites',
5 {
6 inviterDid: text('inviter_did').notNull(),
7 subjectDid: text('subject_did').notNull(),
8 createdAt: timestamp('created_at', { withTimezone: true }).notNull().defaultNow(),
9 },
10 (table) => [
11 primaryKey({ columns: [table.inviterDid, table.subjectDid] }),
12 index('idx_invites_subject').on(table.subjectDid),
13 ],
14);