drizzle_orm_one_to_many_users_posts_relations.ts

1import { pgTable, serial, text, integer } from 'drizzle-orm/pg-core';
2import { relations } from 'drizzle-orm';
3
4export const users = pgTable('users', {
5  id: serial('id').primaryKey(),
6  name: text('name').notNull(),
7});
8
9export const usersRelations = relations(users, ({ many }) => ({
10  posts: many(posts),
11}));
12
13export const posts = pgTable('posts', {
14  id: serial('id').primaryKey(),
15  content: text('content').notNull(),
16  authorId: integer('author_id').notNull(),
17});
18
19export const postsRelations = relations(posts, ({ one }) => ({
20  author: one(users, {
21    fields: [posts.authorId],
22    references: [users.id],
23  }),
24}));