Create Table: recurring_event

[ExperimentsInHonesty]

Overview

We need to create the recurring_event table so that we can connect it with projects table data in the CMS

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 in Swagger

Resources/Instructions

• See People Depot Resources wiki page for links

Items to document (referenced above)

Description

• Recurring events

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)

   • (PK) id - int - Record Id
   • (FK) project_id - int - Record Id
   • name - varchar
   • (FK) location_id - int - Record Id
   • (FK) event_type_id - int - Record Id
   • (FK) brigade_id - int - Record Id
   • (FK) day_of_week - varchar - enumerated field
   • start_time - time
   • duration_in_min - int
   • created - timestamp
   • updated - timestamp
   • video_conference_url - urlstring
   • must_roles - int[ ] (roleIDs)
   • should_roles - int[ ] (roleIDs)
   • could_roles - int[ ] (roleIDs)
   • additional_info - varchar()
   • (FK) frequency_id - int

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)

   • brigade (many-to-one)
   • cancelled_event (one-to-many)
   • event (one-to-many)
   • event_history (one-to-many)
   • event_type (many-to-one)
   • frequency (many-to-one) table removed
   • location (many-to-one)
   • project (many-to-one)
   • user (many-to-many array of ids) - 8/10 Nicole confirmed that the ERD relation to role is the more updated one

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

   • role (many-to-many array of ids)

Swagger Endpoint Link