Self-Adjoint Extension Schemes and Modern Applications to Quantum Hamiltonians