Currently DIRAC(X) defines and use several databases. Some of these have clear relations one to the other, i.e.:
JobDB
JobLoggingDB
PilotAgentsDB
SandboxMetadataDB
TaskQueueDB
TransformationDB
ProductionDB
We should consider merging these databases together, as this would give us, at a minimum, the possibility to actually define the FOREIGN KEYS (JobID is a clearly "everywhere" in the WMS DBs), with all the consequences of it (consistency, at a minimum)
Currently DIRAC(X) defines and use several databases. Some of these have clear relations one to the other, i.e.:
JobDB
JobLoggingDB
PilotAgentsDB
SandboxMetadataDB
TaskQueueDB
TransformationDB
ProductionDB
We should consider merging these databases together, as this would give us, at a minimum, the possibility to actually define the FOREIGN KEYS (
JobIDis a clearly "everywhere" in the WMS DBs), with all the consequences of it (consistency, at a minimum)