diff options
| author |  Anshul Gupta <ansg191@anshulg.com>
| 2024-08-07 19:48:19 -0700 |
|---|---|---|
| committer | Anshul Gupta <ansg191@anshulg.com>
| 2024-08-07 19:48:52 -0700 |
| commit | a439618cdc8168bad617d04875697b572f3ed41d (patch) | |
| tree | b6d867a2d65713deb2e8c2daa25a9df2dd23308b /backend/db | |
| parent | 55231eb4cfb5b5ce246a68ef456619cdb65d8af1 (diff) | |
| download | ibd-trader-a439618cdc8168bad617d04875697b572f3ed41d.tar.gz ibd-trader-a439618cdc8168bad617d04875697b572f3ed41d.tar.zst ibd-trader-a439618cdc8168bad617d04875697b572f3ed41d.zip | |
Rewrite `LetterRating` to match protobuf def
Also changes DB schema to accept strings instead of integers.
Diffstat (limited to 'backend/db')
| -rw-r--r-- | backend/db/migrations/000002_create_data_tables.up.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/backend/db/migrations/000002_create_data_tables.up.sql b/backend/db/migrations/000002_create_data_tables.up.sql index 116c424..f279aa3 100644 --- a/backend/db/migrations/000002_create_data_tables.up.sql +++ b/backend/db/migrations/000002_create_data_tables.up.sql @@ -55,9 +55,9 @@ CREATE TABLE IF NOT EXISTS ratings composite SMALLINT, -- The composite rating (0-99) eps SMALLINT, -- The EPS rating (0-99) rel_str SMALLINT, -- The relative strength rating (0-99) - group_rel_str SMALLINT, -- The group relative strength rating (E-A+) E=0, A+=13 - smr SMALLINT, -- The SMR rating (E-A+) - acc_dis SMALLINT, -- The acc/dis rating (E-A+) + group_rel_str CHAR(2), -- The group relative strength rating (E-A+) E=0, A+=13 + smr CHAR(2), -- The SMR rating (E-A+) + acc_dis CHAR(2), -- The acc/dis rating (E-A+) chart_analysis UUID REFERENCES chart_analysis (id), -- The ID of the chart analysis for the stock price MONEY, -- The price of the stock at the time of the rating |