search

DLR-SC / ESID

This is the repository to the ESID frontend for visualization of infectious disease propagation.
Apache License 2.0
15 stars 3 forks source link

Define database scheme #17

Closed lucaspataro closed 2 years ago

lucaspataro commented 3 years ago

database-diagram

lucaspataro commented 3 years ago

This is the current database model for scenarios, modeled against https://gitlab.dlr.de/hpc-against-corona/epidemiology/-/blob/master/cpp/tests/data/GraphNode0.xml

@mknaranja @dabele does any of you see anything wrong with it? @JonasGilg i am not sure if we want to keep the split into StageTimes adn Probabilities for the frontend, what do you think?

JonasGilg commented 3 years ago

@JonasGilg i am not sure if we want to keep the split into StageTimes adn Probabilities for the frontend, what do you think?

In general it doesn't hurt (except some join's). Do you see any major upside to merge them?

One upside of keeping them separate is the possibility to just query one table, without the other, which might become a use case in the future.

lucaspataro commented 3 years ago

After some discussion with @dabele and @mknaranja i generalized the Scheme even further database-diagram