state_provider keyauth, suggestion of changes
table holding keys has 3 columns (key_auth, authority_kind, account_name), it holds info about keys that account uses and used without differentiating them.
In my opinion there should be another table for current state of an account and the informations should be extended to (auth, authority_kind, account_name, timestamp (for example when last time owner was changed), source_op (id of operation that changed owner keys), source_op_block (block_num where operation took place)). Additionally currently we dont hold informations about account_auths and memokey that i think should be added to the gathered informations (every additional information that i suggest can be gathered from the same operations currently used).
Edited by Michal Zander