[Feature Request] - Support for Gen-Delegation Certificate

[rdlrt]

Versions
The db-sync version (eg cardano-db-sync --version): 13.0.2
PostgreSQL version: 14.x

Additional context

Feature Request to support for genesis delegation certificates (present since shelley CDDL ). This is useful to report rotation of genesis delegation certificates from BFT entities.

Problem Report

A sample Tx from guild network:

cat example/gend-tx7u.tx
{
    "type": "Tx AlonzoEra",
    "description": "",
    "cborHex": "84a400818258205cda6d6e655e80487d1ef1ce13773de4d99173a9cc4e6e81674758d3816ce7d10001818258390037103100f399e239c8c398e343008cf1fbbf4272e2079477f8b0db9abf258e8f2abad8eeeefcd454dcf9add84efe57250eb4d4ae01c753701b00025f8a2b3ca3eb021a000f490404818405581c092d63dc21a01055bbf36b210ed9dcca2a824590a9ddb19852c2d870581c82f1c8df53ba5dba4d7bfe5cbec180b33cec2049edc112f38f9c0dfd5820af194eb918ff28584f93acd0a5014cfbafbe6c0363774c18a0f2411a896687b2a1008282582058c24568653e9d6baece1a5559dedb27d4b5067874d9893fba0068b7b789b3425840504b8adf41fb4f021936d6869e51019eb45719d528c61eb81522f643a6b9bc8352d971a165c64b4b5aa1d18c9faff511190c082fb70c9d4b1c0b5c76ec958a0482582007209d446a540a689507238070a97821bedf37b20d740865284ced7f91887aa55840f1dcf6286d212610e236ed069b1f428ff94ef4df495a66c3404a297ad9de4ff96c0c00937cf3126e1d47bd4c3e340ddfb7bdb631e5786fd6a3bc9007a389d105f5f6"
}

cardano-cli transaction view --tx-file example/gend-tx7u.tx
auxiliary scripts: null
certificates:
- GenesisKeyDelegationCertificate "092d63dc21a01055bbf36b210ed9dcca2a824590a9ddb19852c2d870"
  "82f1c8df53ba5dba4d7bfe5cbec180b33cec2049edc112f38f9c0dfd" "af194eb918ff28584f93acd0a5014cfbafbe6c0363774c18a0f2411a896687b2"
era: Alonzo
fee: 1001732 Lovelace
inputs:
- 5cda6d6e655e80487d1ef1ce13773de4d99173a9cc4e6e81674758d3816ce7d1#0
metadata: null
mint: null
outputs:
- address: addr_test1qqm3qvgq7wv7ywwgcwvwxscq3nclh06zwt3q09rhlzcdhx4lyk8g7246mrhwalx52nw0ntwcfml9wfgwkn22uqw82dcq7ct4gk
  address era: Shelley
  amount:
    lovelace: 667996988941291
  datum: null
  network: Testnet
  payment credential:
    key hash: 37103100f399e239c8c398e343008cf1fbbf4272e2079477f8b0db9a
  stake reference:
    key hash: bf258e8f2abad8eeeefcd454dcf9add84efe57250eb4d4ae01c75370
update proposal: null
validity range:
  lower bound: null
  upper bound: null
withdrawals: null

Current representation for tx in dbsync (prolly irrelevant as the support isnt there yet):

select * from tx where hash = decode('eea6701e2bfd09797bb54d60d8b7693a86be8ad37a3612a311aa3b5d77ff041f','hex');
  id   |                                hash                                | block_id | block_index |     out_sum     |   fee   | deposit | size | invalid_before | invalid_hereafter | valid_contract | script_size
-------+--------------------------------------------------------------------+----------+-------------+-----------------+---------+---------+------+----------------+-------------------+----------------+-------------
 60370 | \xeea6701e2bfd09797bb54d60d8b7693a86be8ad37a3612a311aa3b5d77ff041f |   996624 |           0 | 667996988941291 | 1001732 |       0 |  421 |                |                   | t              |           0
(1 row)

[erikd]

This will need to be a separate table.