osu-cascades/batabase

Schema: update schema to match existing database

Closed this issue · 0 comments

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