export const users = mysqlTable(
"users",
{
id: serial("id").primaryKey(),
name: varchar("name", { length: 256 }),
email: varchar("email", { length: 256 }).notNull(),
image: text("image"),
}
);
export const animes = mysqlTable(
"anime",
{
id: serial("id").primaryKey(),
userId: int("user_id").references(() => users.id),
animeId: varchar("anime_id", { length: 256 }).notNull(),
status: mysqlEnum("status", ["WATCHING", "HOLD"]).default("WATCHING"),
score: int("score").default(0),
progress: int("progress").default(0),
},
(animes) => ({
animeFk: foreignKey({
columns: [animes.userId],
foreignColumns: [users.id],
}),
})
);
export const users = mysqlTable(
"users",
{
id: serial("id").primaryKey(),
name: varchar("name", { length: 256 }),
email: varchar("email", { length: 256 }).notNull(),
image: text("image"),
}
);
export const animes = mysqlTable(
"anime",
{
id: serial("id").primaryKey(),
userId: int("user_id").references(() => users.id),
animeId: varchar("anime_id", { length: 256 }).notNull(),
status: mysqlEnum("status", ["WATCHING", "HOLD"]).default("WATCHING"),
score: int("score").default(0),
progress: int("progress").default(0),
},
(animes) => ({
animeFk: foreignKey({
columns: [animes.userId],
foreignColumns: [users.id],
}),
})
);