thanks! tell your 软件, never...

delete any inactive records!

 

to achieve the goal mentioned in Q2, discuss rules and plans with your users: DA, BA and your boss, if there is any, don't just talk to yourself at night.

 

have fun!