Overview

We need to create the url_status_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

• identify if table has a description (see spreadsheet under Resources)
  • if not, reach out to PD leads
• identify and document (below) what other tables are associated (see ERD under 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 in Swagger

Resources/Instructions

• See People Depot Resources wiki page for links

Items to document (referenced above)

Description

The url_status_type table lists the types of states URLs can be in (potential examples: active, archived, 404, ..?).

Data Fields

1. Copied from spreadsheet and checked off once they have been added to the ERD.

Associated Tables

1. Copied from spreadsheet and checked off once they have been added to the ERD.
   • project_url (one-to-many)