diff options
Diffstat (limited to 'src/main/resources')
| -rw-r--r-- | src/main/resources/db/20251114-0-init-schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/main/resources/db/20251114-0-init-schema.sql b/src/main/resources/db/20251114-0-init-schema.sql index b9b921f..886a961 100644 --- a/src/main/resources/db/20251114-0-init-schema.sql +++ b/src/main/resources/db/20251114-0-init-schema.sql @@ -47,7 +47,7 @@ create table equity_change_event equity_change_cost_basis_usd DECIMAL(14, 2) NOT NULL, equity_change_type VARCHAR(20) NOT NULL CHECK (equity_change_type IN ('BUY', 'SELL')), -- This is essentially '+' or '-' - equity_change_timestamp TIMESTAMP NOT NULL + equity_change_timestamp TIMESTAMP NOT NULL, + equity_change_type_score NUMERIC AS (CASE WHEN equity_change_type = 'BUY' THEN 1.0 ELSE -1.0 END) STORED, + equity_change_est_price DECIMAL(14, 2) AS (equity_change_cost_basis_usd / equity_change_quantity) STORED ); - ---TODO construct views on event collation? heavy calculation requirements....
\ No newline at end of file |