import { relations } from "drizzle-orm";
import { integer, text, pgTable } from "drizzle-orm/pg-core";
export const units = pgTable("units", {
id: integer("id").primaryKey(),
description: text("description").notNull(),
title: text("title").notNull(),
});
export const unitsRelations = relations(units, ({ many }) => ({
lessons: many(lessons),
}));
export const lessons = pgTable("lessons", {
id: integer("id").primaryKey(),
unitId: integer("unit_id"),
});
export const lessonsRelations = relations(lessons, ({ one }) => ({
unit: one(units, {
fields: [lessons.unitId],
references: [units.id],
}),
}));
import { relations } from "drizzle-orm";
import { integer, text, pgTable } from "drizzle-orm/pg-core";
export const units = pgTable("units", {
id: integer("id").primaryKey(),
description: text("description").notNull(),
title: text("title").notNull(),
});
export const unitsRelations = relations(units, ({ many }) => ({
lessons: many(lessons),
}));
export const lessons = pgTable("lessons", {
id: integer("id").primaryKey(),
unitId: integer("unit_id"),
});
export const lessonsRelations = relations(lessons, ({ one }) => ({
unit: one(units, {
fields: [lessons.unitId],
references: [units.id],
}),
}));