[PROD-005] .NET PostgreSQL schema bootstrap and year-state runtime

[ktalpay]

Task ID: PROD-005
Lane: dotnet
Status: merged
Agent: dotnet-agent
Depends on: PROD-004

Goal:
Add the .NET PostgreSQL runtime foundation needed for production parity: safe schema bootstrap and source-family year-state behavior.

Scope:

• Use the .NET production config boundary from PROD-004.
• Add PostgreSQL connection/runtime boundary for the .NET service.
• Bootstrap required shared/source-family schema additively and idempotently.
• Read latest successful year per source family.
• Return configured initial year when no data exists.
• Record successful source-family year state after a future insert boundary.
• Wire validation/status into service command surface without implementing ingestion.
• Add opt-in Docker PostgreSQL tests where practical.

Non-goals:

• No source download/parsing orchestration.
• No source-specific master/detail insert implementation.
• No Python runtime changes.
• No production credentials.
• No destructive DB operations.

Acceptance:

• Missing/invalid DB config fails closed.
• Bootstrap is additive/idempotent.
• Year-state read/write behavior is tested.
• Service command reports runtime readiness without claiming .NET production-ready.
• No generated artifacts.

Task-ID: PROD-005

[github-actions]

Agent Task Watcher updated task status.

Detected task: PROD-005
Merged PR: #622
Task issue status: status:missing -> status:merged

Downstream task update summary:

No dependent tasks were declared in Unblocks:.