[PROD-007] .NET source-specific master/detail insert runtime

[ktalpay]

Task ID: PROD-007
Lane: dotnet
Status: merged
Agent: dotnet-agent
Depends on: PROD-006

Goal:
Add .NET source-specific master/detail insert runtime for production parity.

Scope:

• Map parsed source-family output into source-specific master/detail tables.
• Support GHG Protocol, DEFRA/DESNZ, and IPCC EFDB tables.
• Use the PostgreSQL schema/year-state baseline from PROD-005.
• Use source-cycle parsing output from PROD-006.
• Insert records idempotently and skip duplicates safely.
• Update source-family year-state only after successful master/detail insert.
• Keep run-once guarded until E2E parity is complete if needed.

Non-goals:

• No final production-ready claim.
• No Python runtime changes.
• No uncontrolled live network calls.
• No destructive DB operations.
• No production credentials.

Acceptance:

• Master/detail mapping exists for all three source families.
• Idempotent insert behavior is tested.
• Duplicate source/year/artifact reruns do not duplicate rows.
• Year-state update occurs only after successful insert.
• Diagnostics are redacted.
• Docker PostgreSQL opt-in validation is added or documented.
• No generated artifacts.

Task-ID: PROD-007

[github-actions]

Agent Task Watcher updated task status.

Detected task: PROD-007
Merged PR: #627
Task issue status: status:in-progress -> status:merged

Downstream task update summary:

No dependent tasks were declared in Unblocks:.