Currently, we have a lot of redundancy in the DB, mostly due to the catalogue enty (what's on handrit) vs manuscript (unified catalogue entries with the same ms ID), which have mostly the same data, but in separate tables, each having its own junction tables etc. They even store string references to each other.
By improving our DB model, this redundancy could be vastly reduced.
Currently, we have a lot of redundancy in the DB, mostly due to the catalogue enty (what's on handrit) vs manuscript (unified catalogue entries with the same ms ID), which have mostly the same data, but in separate tables, each having its own junction tables etc. They even store string references to each other.
By improving our DB model, this redundancy could be vastly reduced.