Hello there!
I need help regarding the database design for the following use case.
It’s an investment tracker allowing users to monitor stock/crypto.
The image above shows a crypto portfolio a user can have. Assets are grouped in “Accounts” to better organize investments. For instance, assets coming from a same wallet or broker platform would be part of a same Account. When a user adds a new asset he/she can choose to put it in an existing Account or create a new one on the fly. A given asset cannot belong to more than one Account.
Currently, I have the following data types:
Maybe the Account field on the datatype Cryptocurrency should refer to the datatype Account instead of the text type?
I was wondering if this structure is good or if it can be improved.