Schema: update schema to match existing database
BryceGraves opened this issue · 0 comments
BryceGraves commented
After looking through the existing database I feel like the best solution to ensure database viability is have it match the clients current access layout and trim from there.
Task List:
- Connect front end and back end access files
- Generate dump from connected db files
- Use an automatic model generator to create models from dump
- Use the models generated to verify the current state of our models
- Once verified make this the default db state on first migration
- Optimize schema without removing content or tables through migration
- Dig through xlsx file provided by client and remove tables when requested