Alert Composer: Message text stored in which table

Summary:

I want to get the message text of an alert composer. where it will be stored,

Only message body was able to found-. which is in HTML format. most of the alerts the body is empty also

All other information was able to capture from the following tables:

HRC_ALERTS_B HRCAB,
HRC_ALERTS_TL HRCATL,
HRC_ALERT_RECIPIENTS HRCAR,
HRC_ALERT_TEMPLATES_B HRCAT,
HRC_ALERT_TEMPLATES_TL HRCATTL

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):