Upgrade to Sixth Normal Form

[TheLoneRonin]

Description

• All active queries that require sorting should be to tables in sixth normal form.

• Primary key indexed data storing regular table metadata should be in second normal form.

• Sixth normal form ensures optimal performance on queries.

Table Structure

General guideline for restructuring tables... Subject to change on implementation

• Primary key for blocks table is changed to height and an integer

• transactions table is converted into an auto increment table containing id as an integer and tx_hash as the actual transaction id.

• Key metadata for transactions and tags are refactored to reference this id as an integer instead of varchar

References

• https://en.wikipedia.org/wiki/Second_normal_form

• https://en.wikipedia.org/wiki/Sixth_normal_form