[FEAT] Simplify Message -> Status relationship

[nivemaham]

Is your feature request related to a problem? Please describe.
Current implementation has explicit message status event entities per message type.

Describe the solution you'd like
this could be simplified and a general message status can be used in the parent class.

Priority
1 (The sooner, the better since this will avoid migration and reduce code complexity)

Difficulty
10

Additional context

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.