Create Table: sdg_target_indicator

[fyliu]

Dependency

• [x] #70

Overview

We need to create the sdg_target_indicator table so that we can update a shared data store across hackforla.org, vrms, civictechjobs, and tables (onboarding) project.

Details

A table and a model are the same thing

Action Items

• [x] identify and document table description (see spreadsheet under Resources)
  • [ ] if not, reach out to PD leads
• [x] compare and check off the data fields (below) against the ERD. Note any fields in the ERD that's missing from the list. (see Resources)
• [x] compare the check off associated tables (below) against the ERD. Note any associated tables in the ERD that's missing from the list (see Resources)
• [ ] create a single model in Django (defining schema)
• [ ] add seed data
• [ ] write a test for the relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project).
• [ ] write an API end point
• [ ] write API unit tests
• [ ] document the endpoint

Resources/Instructions

• See People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• See the wiki page for instructions.

Description

Dictionary of SDG targets and indicators with their target number, description, etc.

Data Fields

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • [x] (PK) id - int
   • [x] (FK) sdg_id - int
   • [x] code - varchar
   • [x] description_number - varchar
   • [x] descriptoin_text - varchar

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

Associated Tables

1. Copied from spreadsheet and checked off according to ERD. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • [x] sdg (many-to-one)

2. In ERD only (having items here indicates a mismatch, which requires a review)

   • None

[fyliu]

sdg_indicator in Fields spreadsheet is completely different from the one in the ERD.

[Neecolaa]

Currently, the spreadsheet still has the sdg_target and sdg_indicator as separate tables, while the ERD and the data we've prepared in the spreadsheet have them combined into sdg_target_indicator.

I've updated the fields tab to match the ERD

[ExperimentsInHonesty]

@Neecolaa I read your last comment. Is this issue ready to work on, or do we need to make a decision on what to do?