Skip to content

database-schema.md

Latest commit

 

History

History
29 lines (21 loc) · 617 Bytes

database-schema.md

File metadata and controls

29 lines (21 loc) · 617 Bytes

Database Schema

The database schema is defined using Drizzle ORM in drizzle/schema.ts.

Core Tables

  • users: Stores user accounts, hashed passwords, and profile info.
  • repositories: Stores repository metadata (owner, name, visibility).
  • pull_requests: Stores PR data, status, and description.
  • sessions: Stores active login sessions (if using database sessions).

Migrations

We use drizzle-kit for migrations.

Generate a migration:

npm run db:generate

Apply migrations:

npm run db:migrate

Push schema (Prototyping):

npm run db:push