Update Table: event

[ExperimentsInHonesty]

Overview

We need to update the event table model to include new fields and have the correct names for fields.

Details

• The initial model issue: Create Table: recurring_event #14 & Update Table: recurring_event (rename to event) #173

Action Items

Update existing Django model

• In the files indicated by Resource 1.01, Change the following items in the code

Current Name in code	Updated Name	Updated Type (may already be this type)	FK Table	FK Table Issue(s)
project_id	project	UUID	#16 & #197 & #607
brigade_id	org	UUID	#56

• Add the following items in the code

Name	Type	FK Table	FK Table Issue(s)
description	varchar
event_type	UUID	eventtype	#50
rrule	RecurrenceField
location	UUID	location	#44
last_generated	DateTimeField
previous-version	UUID	event	#14 & #173
ended_on	Date

• Write a test for the new relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project) if any.
• Update API end point
• Update API unit tests
• generate a schema table description (see resources 1.04), post it in a comment below, and add a link to it in the Update Schema dependency issue
• Document the endpoint in ReDocs (see resources 1.05)

FK status

• Create Table: project #16
• Update Table: project #197
• Update Table: project #607
• Create Table: org (formerly brigade) #56
• Create Table: event_type #50
• Create Table: location #44
• Create Table: recurring_event #14
• Update Table: recurring_event (rename to event) #173

Resources

• 1.01 Code locations
  • 1.01.01 /app/core/models.py
  • 1.01.02 /app/core/admin.py
  • 1.01.03 /app/core/api/serializers.py
  • 1.01.04 /app/core/api/views.py
• 1.02 People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• 1.03 Spreadsheet: PD: Table and field explanations, Current Field Permission tab
  -1.03.01 event filter
• 1.04 Instructions for how to generate a schema table description
• 1.05 Instructions for how to Document End point step 3