I am not 100%, or even 83%, sure what you are asking. The project seems complex and a lot a specifics are missing from the question. However,
- I am fairly sure that you don’t need to duplicate the entire post
table or post type set of tables. - I am also not even sure if you need a custom table at all. The
postmeta table performs very well depending on the query. - If you do end up needing a custom table, just create a table to hold
the particular “Extra” bits of information that you need and merge
that information into your queries where necessary.
If you try to do what I think you are thinking about doing, you are going to be hooking into many, many hooks– dozens maybe. It is going to be complicated and difficult to maintain.
Without more information, that is all I’ve got.