...
Design and Implementation
Drawio | ||||
---|---|---|---|---|
|
The starting point of the design was the fact, that a subscription bundle has to work in two contexts:
...
Code Block | ||
---|---|---|
| ||
update subscription_bundle set value4=case when value2 > (value1-value3) then value2 - (value1-value3) else 0 end where exists (select * from bundle b where b.id = subscription_bundle.bundle_id and b.parameters like '%UPDATE_MANAGER=ROLLOVER%'); |