Create Table: cancelled_event

[ericvennemeyer]

Dependency

• Implement a solution for cancelled events #151 will decide if we need this issue

Overview

We need to create the cancelled_event table so that ???

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

Events that have been cancelled

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
   • (FK) recurring_event_id - int - Record Id
   • (FK) project_id - int - Record Id
   • cancelled_event_date - date
   • reason - varchar
   • (FK) user_id - int - Record Id

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)

   • project (many-to-one)
   • user (many-to-one)
   • recurring_event (many-to-one)

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

   • None

[PlantGirlCodes]

• per fyliu this is being worked on in Implement a solution for cancelled events #151 can be closed

[fyliu]

• This table was dropped during the event table redesign Epic: Redesign event schema #88 but we need something different than what that event library provides. Implement a solution for cancelled events #151 is the issue to work on that and we should close this issue since we're not going to create this table. Do we need to delete the design from the ERD and spreadsheet?