Create Table: check_type :smile:

[ericvennemeyer]

Overview

We need to create the check_type 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)
  • [x] 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)
• [x] add seed data
• [x] 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

Resources/Instructions

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

Description

Types of checks we perform

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] name - varchar
   • [x] description - 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] user_check (one-to-many)

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

   • None

[fyliu]

Edited description field to be text field in django

[fyliu]

This is actually v0.1 since we need this for the permissions system to work.

[ExperimentsInHonesty]

@janebirman Please provide update

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures or links* (if necessary): "Add any pictures or links that will help illustrate what you are working on."

• remember to add links to the top of the issue if they are going to be needed again.

[dmartin4820]

@fyliu Should I update this issue description, ERD, and Google Sheets so that the field data types match the available Django types (e.g. varchar -> CharField)? In the meantime, I'll be working through the PeopleDepot docs to implement the tables.

If the update is needed, I don't think I can update the ERD since I don't have the login info.

This issue contains a step for documenting the endpoint. It looks like this is auto-generated with Swagger at http://localhost:8000/api/schema/swagger-ui/. I'm checking that step unless there are other places I need to document