ER: Skill matrix that support role and users tables

[ExperimentsInHonesty]

Emergent Requirement - Problem

We are changing from having a lot of titles with descriptions and requirements to a small number of practice areas (research, design, etc.) and need to change the table structure to accommodate that.

Issue you discovered this emergent requirement in

• Create Table: skills (formerly role) 😄  #38

Date discovered

2023-03-23

Did you have to do something temporarily

• YES
• NO

Who was involved

@ExperimentsInHonesty , @Neecolaa , @fyliu @yoyoyojoe

What happens if this is not addressed

CTJ can't help people post open roles using the new skills matrix

Resources

• skills matrix
• Zoom Setup spreadsheet - see column C for abbreviations of who would attend a meeting

Recommended Action Items

• Make a new issue or revise Make current_skills a many-to-many with a new skills table #90
• Discuss with team
• Let a Team Lead know
• We need to talk to VRMS about permission changes triggering access
• CTJ to let them know we are removing the
  • responsibilities - varchar
  • qualifications - varchar
• after discussion make issues below

Potential solutions [draft]

We are going to need a skills table with rows for each user
three more tables

1. skills list (name of skill, roles associated with, id)
2. competency level
   (1 (no experience) 2 (exposure) 3 (some experience) 4 (experience) 5 (portfolio item))
3. table that joins the many users to their many skills

[PlantGirlCodes]

• Clarification of the ask: this issue should revise Make current_skills a many-to-many with a new skills table #90

[ExperimentsInHonesty]

• This is being closed and we will track the issue making from Make current_skills a many-to-many with a new skills table #90