Sifa professional network API (Fastify, AT Protocol, Jetstream)
sifa.id/
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});