import { relations } from "drizzle-orm";
import { int, sqliteTable, text } from "drizzle-orm/sqlite-core";
export const user = sqliteTable("users_table", {
userId: int().primaryKey({ autoIncrement: true }),
name: text().notNull(),
age: int().notNull(),
email: text().notNull().unique(),
});
export const post = sqliteTable("posts_table", {
id: int().primaryKey({ autoIncrement: true }),
userId: int().notNull(),
title: text().notNull(),
content: text().notNull(),
});
export const postRelations = relations(post, ({ one }) => ({
user: one(user, {
fields: [post.userId],
references: [user.userId],
}),
}));
import { relations } from "drizzle-orm";
import { int, sqliteTable, text } from "drizzle-orm/sqlite-core";
export const user = sqliteTable("users_table", {
userId: int().primaryKey({ autoIncrement: true }),
name: text().notNull(),
age: int().notNull(),
email: text().notNull().unique(),
});
export const post = sqliteTable("posts_table", {
id: int().primaryKey({ autoIncrement: true }),
userId: int().notNull(),
title: text().notNull(),
content: text().notNull(),
});
export const postRelations = relations(post, ({ one }) => ({
user: one(user, {
fields: [post.userId],
references: [user.userId],
}),
}));