Great article on Smashing Magazine that offers more details on and insight into the “mechanics” (and possibilities 😉 ) of custom post types than most other resources. VERRRRY much worth the read!
WordPress has been gaining a foothold in the general CMS game for a few years now but the real breakthrough was the custom post type mechanism which allows for the creation of a wide variety of content. Let’s take a look at how this came to be and all the options that this great functionality offers.
A custom post type is nothing more than a regular post with a different post_type value in the database. The post type of regular posts is post, pages use page, attachments use attachment and so on. You can now create your own to indicate the type of content created. You could create custom post types for books, movies, reviews, products and so on.
— Continue reading at www.smashingmagazine.com/2012/11/complete-guide-custom-post-types/