Advice on how to structure a custom plugin

The number in the above example are not indicative of a need for a custom database table solution, the database will be fine with just using the users table for the users, posts table for the posts and usermeta table for the link between users and posts.

Its hard to offer a more definitive answer without knowing a little more about what the needs of the business / plugin are to be.