colorstackorg/oyster

Infrastructure for School Chapters 🧱

Opened this issue · 1 comments

Description

We eventually want to have more support and functionality for chapters within the member profile. First, we'll need to get the basic infrastructure in place to support this. In this issue we will do 2 things:

  • Create a chapters table
  • Add the ability for admins to mark a school that has a chapter

Acceptance Criteria

  • Create a chapters table that for now only needs to do two things: (1) store which schools have a chapter by linking the school_id and (2) store the timestamp of when a school was added to the chapters table
  • Add a field to the dropdown in the "Schools" page of the Admins dashboard
  • This new field should add a school to the chapters table when selected
  • Add a confirmation modal that appears after selecting the field (and before adding the school to the chapters table)
  • The new field should only appear in the dropdown for a school if the school is not yet in the chapters table

Additional Context

This is what the dropdown currently shows:

Screenshot 2024-09-03 at 2 23 22 PM

I'd like to tackle this!