Create Table: organization (formerly brigade)

[ericvennemeyer]

Overview

We need to create the organization 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 and document table description (see spreadsheet under Resources)
  • if not, reach out to PD leads
• 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)
• 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)
• 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

List of organizations (formerly brigades)

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)

   • (PK) id - int - Record Id
   • name - varchar()
   • time_zone - 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)

   • recurring_event (one-to-many) Update Table: recurring_event (rename to event) #173
   • user_check (one-to-many) Create Table: user_check #80

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

   • None

[ExperimentsInHonesty]

@Neecolaa do you feel you have enough answers in order to finish this issue?

[Neecolaa]

• I added a comment to the audit epic noting the need to change brigade_id to org_id Epic: Audit differences between code and documented field names #432
• If we add the relationship between organization and affiliate, it would affect the structure of affiliate but not organization. This means it's not a blocker for organization being built, so this issue is able to be prioritized again