Currently, connections between database models are inferred via names (username, job_name, run_name, ...). To make querying more efficient names could be replaced by id (foreign keys).
Things to consider:
the ids should not be used anywhere outside of the database connectors
it might prohibit hybrid database use, e.g. managing users via OIDC and the rest via sqlalchemy
KerstenBreuer
commented
4 years ago
Currently, connections between database models are inferred via names (username, job_name, run_name, ...). To make querying more efficient names could be replaced by id (foreign keys).
Things to consider: