Create Table: leadership_type :smile:

[Neecolaa]

Overview

We need to create the leadership_type 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

• [ ] add issue link to the tables tab of the spreadsheet
• [ ] identify and document table description (see spreadsheet under Resources)
• [ ] 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)
• [ ] add seed data
• [ ] 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

Dictionary of leadership types to be associated with a project i.e. "Mentor Led", "Peer Led"

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
   • [ ] description - textfield

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 (one-to-many)

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

   • None

[ExperimentsInHonesty]

I am unsure of this table. When I went to the spreadsheet, it says the following, which looking at the example would only make sense for Communities of Practice. Which are projects but all projects won't have this.

Table Name	Has Issue (provide issue number linked)	Priority	Junction Table (T/F)	Tables Joined To	Brief Description	Long Description	Visible to whom	Tables Joined To as checkboxes
leadership_type	https://github.com/hackforla/peopledepot/issues/42		F	project (one-to-many)	Dictionary of leadership types to be associated with a project	i.e. "Mentor Led", "Peer Led"		- [ ] project (one-to-many)

[fyliu]

I edited the field types to use textfield for description

[ExperimentsInHonesty]

@swdesign13 Please provide update

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures or links* (if necessary): "Add any pictures or links that will help illustrate what you are working on."

• remember to add links to the top of the issue if they are going to be needed again.

[Neecolaa]

I am unsure of this table. When I went to the spreadsheet, it says the following, which looking at the example would only make sense for Communities of Practice. Which are projects but all projects won't have this.

Table Name Has Issue (provide issue number linked) Priority Junction Table (T/F) Tables Joined To Brief Description Long Description Visible to whom Tables Joined To as checkboxes leadership_type #42   F project (one-to-many) Dictionary of leadership types to be associated with a project i.e. "Mentor Led", "Peer Led"   - [ ] project (one-to-many)

@ExperimentsInHonesty Did we resolve this uncertainty? That's the only block for this table being re-added to the Prioritized backlog.

If not all projects have a leadership_type, we could allow leadership_type_id in project to be null. project_leads would also be null in that case, since there wouldn't be any leads.

[shmonks]

Only CoPs have leadership_type - and projects are product by default.