You can encode base 2 as base 10, I don’t think anyone is saying it exists in binary form.

Regardless of what the remote access test says about it being available, I had to manually port forward to fix this same issue.

Seriously, can’t get those 15 minutes back.

All three should be one table, at least based on the diagram and your description. Read this https://martin.kleppmann.com/2011/03/07/accounting-for-computer-scientists.html.

Look into the concept of sub-ledgers if you’re wanting some additional tables along with the general ledger.

Past that, historical balances being rolled up by various dimensions is another thing I’ve done. No point in continuously summarizing the GL from the beginning of time when those values should never change and people only care to see summary values for a period.

Whenever you do get it clean, treat it with RainX or similar. We do that every few years and squeegee after each shower, our glass is spotless after 10 years. Our water is super hard too, saw the house next to ours which was built at the same time, disgustingly opaque with scale.

I came back to my office after the new year’s break and a stray bullet, from I’m assuming celebratory gunfire, was shot through the wall and hit my screen. Admittedly it wasn’t a hole and the screen was totally unusable after, but I’ll be a close n=1.