Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ER: Consolidating Technology, Tool, Language tables into one table. #202

Closed
2 of 9 tasks
ExperimentsInHonesty opened this issue Sep 18, 2023 · 2 comments
Closed
2 of 9 tasks
Labels
complexity: missing feature: ERD/SS adjustment Requires adjustments to be made to the ERD & Spreadsheet feature: table creation feature: update table role: db architect s: CTJ stakeholder: Civic Tech Jobs s: hackforla.org stakeholder: hackforla.org website s: PD team stakeholder: People Depot Team s: VRMS stakeholder: VRMS size: 0.25pt Can be done in 0.5-1.5 hours

Comments

@ExperimentsInHonesty
Copy link
Member

ExperimentsInHonesty commented Sep 18, 2023

Emergent Requirement - Problem

We need to combine the technology, tools and languages into one table that has a FK of type. The type would come from a new table that would have the following values:

  • tool
  • technology
  • language (cannot be edited manually, only can be updated by GitHub API call to find project languages.

The new type table will be stack_element_type

Issue you discovered this emergent requirement in

Date discovered

2023-09-18

Did you have to do something temporarily

  • YES
  • NO

Who was involved

@Neecolaa @PlantGirlCodes @ExperimentsInHonesty

What happens if this is not addressed

its inefficient and we will have to write sophisticated sql queries to make sure that the values aren't classified under a different category.

Resources

Recommended Action Items

  • Make a new issue
  • Discuss with team
  • Let a Team Lead know

Potential solutions [draft]

@ExperimentsInHonesty ExperimentsInHonesty changed the title ER: [replace with info ] ER: Consolodating Technology, Tool, Language tables into one table. Sep 18, 2023
@ExperimentsInHonesty ExperimentsInHonesty added feature: table creation role: db architect s: CTJ stakeholder: Civic Tech Jobs s: VRMS stakeholder: VRMS s: hackforla.org stakeholder: hackforla.org website s: PD team stakeholder: People Depot Team size: 0.25pt Can be done in 0.5-1.5 hours feature: ERD/SS adjustment Requires adjustments to be made to the ERD & Spreadsheet feature: update table labels Sep 18, 2023
@Neecolaa

This comment was marked as outdated.

@Neecolaa

This comment was marked as resolved.

@fyliu fyliu changed the title ER: Consolodating Technology, Tool, Language tables into one table. ER: Consolidating Technology, Tool, Language tables into one table. Oct 6, 2023
@shmonks shmonks moved this to Done in P: PD: Project Board Jun 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
complexity: missing feature: ERD/SS adjustment Requires adjustments to be made to the ERD & Spreadsheet feature: table creation feature: update table role: db architect s: CTJ stakeholder: Civic Tech Jobs s: hackforla.org stakeholder: hackforla.org website s: PD team stakeholder: People Depot Team s: VRMS stakeholder: VRMS size: 0.25pt Can be done in 0.5-1.5 hours
Projects
Status: ✅Done
Development

No branches or pull requests

2 participants