Another Data Model Update

After additional review of my notes and thinking through the use cases a bit more, I've updated the ERM diagram for the trading system.  The current version is below.

Trading System V1 - ERM Diagram - Third Draft

The system will use Spring Security, and the associated tables are below.  The users table in the diagram above is the same users table shown in the next table.  Persistent logins will not be used, but the table is still included in the diagram.

Trading System V1 Security - ERM Diagram

I suspect I will have at least one more update to the trading system diagram, but the structure is getting pretty close.  I will describe how the tables will be used in one of the next posts.

Trading System V1 Data Model Thoughts Continued

After further review of the design notes I've kept over the last few months, I made some updates to the data model I posted yesterday.  Here's the new model created in MySQL Workbench:

Trading System V1 - ERM Diagram - Second Draft

Trading System V1 Thoughts

Using the data model from the revised backtesting system as a starting point, I've started planning the data model and Java component interaction / logical architecture.  The first draft of the ERM diagram is below:

Trading System V1 - ERM Diagram

The security_option table is a placeholder for a parent table called security.  The SecurityOption will be a subclass of the Security abstract class in code.