innoTUgrid / backend

backend services for a microgrid data API
0 stars 0 forks source link

Specify ON_DELETE behavior for foreign key relations #50

Closed nymphbox closed 6 months ago

nymphbox commented 7 months ago

Affects tables meta, ts, emission factor. Appropriate constraint will depend on specific table

tomijange commented 7 months ago

current on delete behaviours seem fine for me, emission_factor and energy_carrier are mostly static anyway. ts has no dependency, when deleting from meta we could delete the entire timeseries, but would do it in backend for readability reasons