Implement support for on-chain notes

[bobbinth]

Currently, the node can handle only off-chain notes. To support on-chain notes we'd need to do the following:

1. Add necessary tables to the store database to store on-chain note info.
2. Update block producer to make sure it extracts on-chain note data from proven transactions and send this data to the store via apply_block.
3. Update the store to record the on-chain note data in the DB.
4. Update the store and the RPC to provide an endpoint for users to retrieve on-chain note details
   a. Maybe also update sync_state endpoint to return on-chain note details for such notes (though, this requires a bit more thinking).

This work requires 0xPolygonMiden/miden-base#403 to be completed.

[hackaugusto]

For some context:

related issues in miden-base: 0xPolygonMiden/miden-base#403 0xPolygonMiden/miden-base#402
related PRs so far: 0xPolygonMiden/miden-base#481 0xPolygonMiden/miden-base#485

[Dominik1999]

We break it down into smaller issues @hackaugusto @Dominik1999 @bobbinth

• issue to create an endpoint
• issue for DB
• ...

[Dominik1999]

@bobbinth see comment above

[bobbinth]

I broke out points 1 and 4 into separate issues: #286 and #288. So, this issue is now only for points 2 and 3 of the original description. I think the order of implementation could be:

1. Update storage to support on-chain notes #288
2. Implement GetNotesById endpoint #286
3. And then this issue.

[Dominik1999]

Should be closed by #310