building analog.now, an open source calendar • design engineer • freelance → http://jeanmeijer.com 🇪🇺🇳🇱 • cracked autistic engineer • 🏳️🌈 he/him
![// ...
import type { Message, Attachment } from "ai";
export const message = pgTable("message", {
id: text("id").primaryKey(),
chatId: text("chatId")
.notNull()
.references(() => chat.id),
// infers: "data" | "user" | "system" | "assistant"
role: text("role", { enum: ["data", "user", "system", "assistant"]}).notNull(),
// infers: (TextUIPart | ReasoningUIPart | .... )[] | undefined
parts: json("parts").notNull().$type<Message["parts"]>(),
content: text("content").notNull(),
attachments: json("attachments").notNull().$type<Attachment[]>(),
createdAt: timestamp("createdAt").defaultNow().notNull(),
});
// ...](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:wpjoj2j6syhumlofqjcefsnz/bafkreia7mlomavhjaozc32grqnmrgw55ek4ixuhw5rbkitlt5axh35tkhm)
building analog.now, an open source calendar • design engineer • freelance → http://jeanmeijer.com 🇪🇺🇳🇱 • cracked autistic engineer • 🏳️🌈 he/him