Creating and Using Tables in the Wordpress Database

Question

I plan on having over 2,000 pages per subject on my WordPress website and since each subject will require custom page types I would like to create tables for each subject in the WordPress Database. Each page will also require lat/long and alternate title's for each page created.

Can someone explain how you would go about making and using a dedicated table for each custom Page Type?

I assume that you could use an exact copy of wp_post table?

Answer 1

The requirements you've specified don't indicate any need for a custom post table. Just register a custom post type using register_post_type(), and then manipulate its entries using the standard WordPress API.

Example from the codex, registering a 'book' custom post type with a label of "Books":

function my_init() {
    $args = array( 'public' => true, 'label' => 'Books' );
    register_post_type( 'book', $args );
}
add_action( 'init', 'my_init' );

You can save your latitude, longitude and alternate title values as post meta.