Support » Requests and Feedback » WordPress Database structure

WordPress Database structure

  • I did some searches, but perhaps I’m not searching with the right keywords since I’m not finding what I’m looking for.

    What I’m trying to find (if such a page exists somewhere) is a list of the WordPress database structure and an explanation as to their relation with other data in the database.

    Granted, most of the tables/column names are self-explanatory, post_title = the title of the post and so forth, but in the table wp_post2cat I’m not sure what the rel_id column is for.

    I need this since I’m trying to write a database converter script for a site I’m redesigning that uses a hand-rolled blog which I’d like to convert to WordPress. Knowing which tables relate to what data will make it easy to figure out which columns match which WordPress ones. Unfortunately the hand-rolled blog has many custom columns and it’s not based on any other CMS out there so it’s a bit of a nightmare mapping everything out — I have to basically go through the code of the site to see what gets put where at the moment.

    If anyone can point me in the right direction, I’d be much obliged. 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress Database structure’ is closed to new replies.