I am working on a personal project and I want to make sure that my data model is correct and following the best practices. Receiving feedback on my data model is important in improving my ability and knowledge of databases.
I am designing a stock market program of sorts. My model for it is pretty simple.
The workflow of my project:
- A user creates a user account and enters their address
- A user then can create an account for a specific stock at a share and USD amount
My plan is to make the account table a type two table. Valid from will be set to the date the account was created and valid to will be initially null. Valid to will be set to current date once the account is closed.