Cardano Updates

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

feat: expose deposit on account and drep endpoints

Missed the unpaged variant when fixing the paged one.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Match the openapi schema (null on `deregistered` and `updated`) and
align with the stake-account registrations endpoint's convention,
where `null` denotes "not the deposit-paying side of the event".

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Keep deposit only on the per-event endpoints (/registrations and
/updates) where it semantically belongs. The top-level fields were
redundant — same number derivable from a single registrations/updates
row — and the "deposit paid at registration" framing differs from
Koios's "deposit currently locked" semantics, inviting confusion.

Reverts:
- accounts_stake_address.sql: drop the `deposit` column and the
  registration_state CTE; restore the inline MAX-tx_id comparison
  for the `registered` field.
- dreps_drep_id.sql: drop the `deposit` column.
- TS query types: drop `deposit` from Account and DRepsDrepID.
- Account fixtures: drop `deposit` from /accounts/:stake_address
  query/response fixtures (keeps it on the registrations fixtures).

Bumps @blockfrost/openapi to 0.1.88-beta.2 (drops `deposit` from
account_content and drep schemas).

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds three endpoints for surfacing constitutional committee state and votes:

- GET /governance/committee — current committee snapshot with members,
  quorum, members count, and source NewCommittee gov action (genesis
  committee returns proposal fields as null and `is_genesis: true`).
- GET /governance/committee/votes — paged list of all CC votes ever cast.
- GET /governance/committee/:cc_id/votes — paged list of votes filtered
  by CIP-129 hot (cc_hot1...) or cold (cc_cold1...) credential.
  Cold queries aggregate across every hot key the cold has authorized.

Per-vote shape includes the voting anchor (metadata_url / metadata_hash),
governance_type, block height/time, and the voter's CIP-129 hot id.

Depends on a forthcoming @blockfrost/openapi release that adds the
matching path + schema definitions.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

- Fixtures: add `deposit` to /accounts/:stake_address response/query
  fixtures and per-row to /accounts/:stake_address/registrations
  (registered → string; deregistered → null) so route unit tests
  cover the new field per Copilot review.
- SQL: lift the `MAX(stake_registration.tx_id) > MAX(stake_deregistration.tx_id)`
  comparison into a `registration_state` CTE and reuse it from both
  the `registered` field and the deposit CASE. Eliminates a redundant
  pair of subqueries per request.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>

Adds a `deposit` field to:
- /accounts/:stake_address
- /accounts/:stake_address/registrations (per row)
- /governance/dreps/:drep_id
- /governance/dreps/:drep_id/updates (per row)

For stake registrations, falls back to epoch_param.key_deposit at the
registration's epoch when stake_registration.deposit is NULL (rows
predating db-sync's deposit column).

Requires @blockfrost/openapi 0.1.88-beta.0 for the matching schema.

Co-Authored-By: Claude Opus 4.7 (1M context) <[email protected]>