I have a couple of custom post types (course and assignment) for an custom LMS plugin that I’m building. The course CPT represents content that is produced internally by the company. The assignment CPT represents content produced by students. Both have the potential for representing a lot of data. Because the assignment CPT is being externally produced by students, I felt that it would be better practice to have it stored in a separate database table.
Is this possible to do and still have access to all the WP_Post class functionality that would come with using a CPT. Now, I’ve learned that WordPress MultiSite will create a full set of tables for a second or third blog, what I’m looking for is perhaps an in between hack so that I can just create a separate set of Post tables (ex. wp_2_post & wp_2_postmeta) and still access it from the first blog with all the Post class functionality. Like calling the WP_Post class and assigning it to look at a different table for its data.
Can it be done? And if it can be done, any thoughts on if this would be advisable or if there was a better solution. Thank you!