Use when adding/modifying database tables or columns in Drizzle ORM schema
createdAt: text("created_at").notNull() to new tablesupdatedAt: text("updated_at").notNull() to new tablesonDelete for all foreign keys (cascade/set null)packages/db/src/schema/relations.ts if adding relationspnpm --filter @mf-dashboard/db exec drizzle-kit generatearchitecture/database-schema.md with new ERDpackages/db/src/schema/tables.tspackages/db/src/schema/relations.tspackages/db/src/repositories/packages/db/src/types.tsexport const newTable = sqliteTable("new_table", {
id: integer("id").primaryKey({ autoIncrement: true }),
// ... your columns ...
createdAt: text("created_at").notNull(),
updatedAt: text("updated_at").notNull(),
});
foreignKeyColumn: integer("foreign_key_column")
.notNull()
.references(() => parentTable.id, { onDelete: "cascade" }),
export const myTable = sqliteTable(
"my_table",
{
// columns...
},
(table) => [index("my_table_column_idx").on(table.columnName)],
);