I couldn’t figure out why my battery kept dying overnight, but after some testing, I found out the
alternator drain battery issue was the cause. Even with the car off, the alternator was consuming power due to a faulty diode.
If the battery is constantly discharging, don't neglect the alternator: it can drain the battery even with the engine off.