Update "Create Table" issue template

[fyliu]

Overview

Based on experiences from "Create Table" issues, come up with a better "Create Table" issues template

Action Items

• Update from Create Table: User #15
• Update from Create Table: project #16
• Update from Create Table: recurring_event #14
• Update from Create Table: user permission #22

Update the template below this line

---

Overview

We need to create the [name of table] 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

• identify if table has a description (see spreadsheet under Resources)
  • if not, reach out to PD leads
• identify and document (below) what the data fields are and make sure the ERD and spreadsheets match (see Resources)
• identify and document (below) what other tables are associated and make sure the ERD and spreadsheets match (see Resources)
• create a single model in Django (defining schema)
• 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

Items to document (referenced above)

Description

Data Fields

1. Copied from spreadsheet and checked off according to ERD. Data fields are bolded and relation fields are not. (unchecked items indicate a mismatch between ERD and spreadsheet, which requires a review)

   • [name] - [type]

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

   • [name] - [type]

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)

   • [other_table] ([relationship])

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

   • None