database-tables

To create PostgreSQL table schemas using Drizzle ORM, define tables with appropriate prefixes in backend/src/db/schema.ts, add relations and indexes, then run the migration tooling from the backend directory to apply schema changes.

Framework tables require the base_ prefix and app tables require the app_ prefix in Drizzle schema files. This convention separates core framework data from application-specific data within your PostgreSQL database.

Generate database migrations with Drizzle ORM by defining or altering table structures in backend/src/db/schema.ts, then executing the provided drizzle tooling from the backend directory to create migration files.

Yes, you can add indexes and timestamp fields to existing PostgreSQL tables using Drizzle ORM. Alter your table definitions in backend/src/db/schema.ts following Drizzle patterns, then generate a new migration to apply the changes.

This database schema approach works specifically through Drizzle ORM for PostgreSQL. It leverages Drizzle's schema definition patterns and migration tooling rather than writing raw SQL scripts directly.

The best way to structure database tables using Drizzle is to centralize definitions in backend/src/db/schema.ts, apply base_ and app_ prefixes to distinguish layers, define relations explicitly, and generate migrations via tooling.