bcgov / bcgov/wps

ASA: Normalize advisory_classified_hfi table

Open
#2,473 0 comments 0 reactions 0 assignees View on GitHub
Task
Dominant language
Python
Stars
65
Forks
11
Avg merge
21h 25m
Merged PRs (30d)
70

Description

We now have a run_parameters table that contains unqiue combinations of run_type, run_datetime and for_date. This table is referenced by the high_hfi_area table, but should also be used by the advisory_classified_hfi table so we are not repetitively storing this data in each row.

**Acceptance Criteria**
- [ ] advisory_classfied_hfi has a foreign key reference to run_parameters
- [ ] run_type, run_datetime and for_date fields are removed from advisory_classified_hfi
- [ ] crud operations on advisory_classified_hfi are updated to join reflect the changes

Contributor guide

Open the contributing guide

Research direction

Start by locating the advisory_classified_hfi and run_parameters table definitions, the existing high_hfi_area relationship, and the CRUD operations for advisory_classified_hfi. Compare the current schema and queries with the acceptance criteria, then verify the foreign key, removed fields, and updated join behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Refactor
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.