Basically, I want to follow the author by other WordPress users. Whenever an author posts new post subscribed users need to get notification by email.

If it's not already there, I can create a plugin for this. But I need an idea to store the data. Should I go for custom table or is there a better way to store default table structure.