Sifa professional network API (Fastify, AT Protocol, Jetstream) sifa.id/
at main 9 lines 412 B view raw
1import { pgTable, serial, text, date, timestamp } from 'drizzle-orm/pg-core'; 2 3export const featuredProfiles = pgTable('featured_profiles', { 4 id: serial('id').primaryKey(), 5 did: text('did').notNull(), 6 featuredDate: date('featured_date').notNull().unique(), 7 postedAt: timestamp('posted_at', { withTimezone: true }), 8 createdAt: timestamp('created_at', { withTimezone: true }).notNull().defaultNow(), 9});