Replace addresses across all Postgres tables with fk references to a separate `addresses` table #105

i-norden · 2019-06-18T03:22:53Z

Originally recommended by @ramilexe, this will reduce redundancy in our database and should improve index performance. This work is potentialy relevant to multiple work streams, putting this here in part so that we make sure not to duplicate this effort!

i-norden · 2019-12-04T20:36:21Z

PR #126 addresses this issue.

I think there are still a few places where we need to update to using the FK reference though e.g. in 00017_create_log_filters.sql and the new cid tables (00034_create_receipt_cids.sql contract field, and 00035_create_state_cids.sql could reference the addresses.hashed_address for its state_key field)

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Replace addresses across all Postgres tables with fk references to a separate `addresses` table #105

Replace addresses across all Postgres tables with fk references to a separate `addresses` table #105

i-norden commented Jun 18, 2019

i-norden commented Dec 4, 2019 •

edited

Loading

Replace addresses across all Postgres tables with fk references to a separate addresses table #105

Replace addresses across all Postgres tables with fk references to a separate addresses table #105

Comments

i-norden commented Jun 18, 2019

i-norden commented Dec 4, 2019 • edited Loading

Replace addresses across all Postgres tables with fk references to a separate `addresses` table #105

Replace addresses across all Postgres tables with fk references to a separate `addresses` table #105

i-norden commented Dec 4, 2019 •

edited

Loading