From 4ad7206443660587a15a7b47384b927188155da8 Mon Sep 17 00:00:00 2001 From: Terry Truong Date: Wed, 28 Dec 2022 20:49:13 +1100 Subject: Convert 'scores' table to 'events_disp', removing 'scores' column --- backend/hist_data/README.md | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'backend/hist_data/README.md') diff --git a/backend/hist_data/README.md b/backend/hist_data/README.md index 1a832ef..b557b14 100644 --- a/backend/hist_data/README.md +++ b/backend/hist_data/README.md @@ -33,9 +33,9 @@ This directory holds files used to generate the history database data.db. - `dist`:
Format: `scale INT, unit INT, count INT, PRIMARY KEY (scale, unit)`
Maps scale units to event counts. -- `scores`:
- Format: `id INT, scale INT, score INT, PRIMARY KEY (id, scale)`
- Maps events to score values for each scale (used to show events by popularity and uniformity across scale). +- `event_disp`:
+ Format: `id INT, scale INT, PRIMARY KEY (id, scale)`
+ Maps events to scales they are 'displayable' on (used to make displayed events more uniform across time). # Generating the Database @@ -83,5 +83,5 @@ Some of the scripts use third-party packages: ## Remove Events Without Images/Descs 1. Run `reduce_event_data.py` to remove data for events that have no image/description. -## Generate Distribution and Score Data -1. Run `gen_score_data.py`, which add the `dist` and `scores` tables. +## Generate Distribution and Displayability Data +1. Run `gen_disp_data.py`, which add the `dist` and `event_disp` tables. -- cgit v1.2.3