diff options
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 |