hackforla / hackforla/VRMS

Create Spreadsheet of VRMS Database Fields for People Depot

Open
#1,772 1 comment 0 reactions 0 assignees View on GitHub
complexity: medium feature: Database role: Product size: 2pt
Dominant language
JavaScript
Stars
61
Forks
101
PR merge metrics
No merged PRs in 30d

Description

### Overview
People Depot is building a new backend for VRMS. In order to do so, People Depot requires a list of all database fields and corresponding screens that this information is required on.

### Action Items
- [ ] Coordinate with Developers to create export of database fields
- [ ] Research and document the process for reviewing database fields in VRMS and identifying the screens they are associated with.
- [ ] Review the VRMS Backend and current screens across vrms.io. Update this [Google Sheet](https://docs.google.com/spreadsheets/d/1Gr6XNgwHm1BXdZQJm-Jqm_HmKDBwWnO43wKeqsneDR4/edit?usp=sharing) to include each database field and list all screens that retrieve data from those fields.
- [ ] Create a legend in the spreadsheet with screenshots of each referenced screen, along with corresponding titles for each screen.
- [ ] Notify PM and Lead Dev (@JackHaeg & @trillium) when complete to review and take on the next steps:
- [ ] Review with stakeholder Bonnie
- [ ] Send People Depot PM Sarah Monks, PhD the completed spreadsheet to review with the People Depot Team

### Resources/Instructions
[Google Sheet](https://docs.google.com/spreadsheets/d/1Gr6XNgwHm1BXdZQJm-Jqm_HmKDBwWnO43wKeqsneDR4/edit?usp=sharing)

VRMS Database Table Names

![Database table names](https://github.com/user-attachments/assets/4743e810-dbcc-4d32-9c45-38a386071c34)


Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.