Create Table: sdg

[fyliu]

Overview

We need to create the sdg 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)
• [x] 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).
• [x] write an API end point
• [x] write API unit tests
• [x] document the endpoint
• [x] take #66 out of ice box
• [x] release #71 from ice box

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 SDGs

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 - Record Id
   • [x] name - varchar
   • [x] description - textfield
   • [x] image - url 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] project_sdg_xref (one-to-many)

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

   • [ ] sdg_target_indicator (one-to-many)

[freaky4wrld]

ETA: 1/22/24 Availability: Evenings

[freaky4wrld]

Maybe need some more time to setup and understand the issue extending ETA a bit further ETA: EoD 1/26/24