The proposal is to add a new table with the columns location_id, stage_id, charm_id, ar_flag, dr_flag
This table would be populated manually when we want to add AR or DR (or both) altering charms. For example, for Bristle Woods Rift we could add a row for every chamber (stage_id) with the Rift antiskele charm.
This table would then be used by the aggregating process which can do an outer join on it when building statistics. Grouping by the additional charm_id which will be null when it's not flagged for the process means we would get a row for the cheese/location/stage/charm for each charm (see toxic spill and rotten/super rotten) as well as a row for the null charm condition.
This would require the addition of a charm_id column into the aggregate table.
The ar_flag and dr_flag are to mark charms as interesting for one or the other operation - or both. Rift Vacuum Charms are only interesting for drop rate (of calcified rift mist). Artisan Charms are interesting for both cases. It is possible all AR-affecting charms are interesting for drop rates.
Discord conversation is long and rambling but I think distills to here: https://discord.com/channels/275500976662773761/355474934601875457/824375227240415252
The proposal is to add a new table with the columns location_id, stage_id, charm_id, ar_flag, dr_flag
This table would be populated manually when we want to add AR or DR (or both) altering charms. For example, for Bristle Woods Rift we could add a row for every chamber (stage_id) with the Rift antiskele charm.
This table would then be used by the aggregating process which can do an outer join on it when building statistics. Grouping by the additional charm_id which will be null when it's not flagged for the process means we would get a row for the cheese/location/stage/charm for each charm (see toxic spill and rotten/super rotten) as well as a row for the null charm condition.
This would require the addition of a charm_id column into the aggregate table.
The ar_flag and dr_flag are to mark charms as interesting for one or the other operation - or both. Rift Vacuum Charms are only interesting for drop rate (of calcified rift mist). Artisan Charms are interesting for both cases. It is possible all AR-affecting charms are interesting for drop rates.