# Phase 4 Database Structure

## Tables
- `bugs`: core bug records with severity, status, assignment, environment, screenshot.
- `bug_histories`: bug lifecycle timeline (created, status transitions, reopen, QA actions).
- `testing_reports`: QA test execution summaries and performance score.
- `developer_penalties`: penalty points tied to reopened bugs and severity.

## Lifecycle Fields
- Status values: open, in_progress, resolved, qa_approved, qa_rejected, reopened, closed.
- `reopen_count` tracks repeated regression/reopen events.