In WordPress, “Revisions” and “Attachments” post types are stored in the wp_posts table
The wp_posts table stores all data related to the content of a WordPress website. This includes things such as posts, pages, and page revisions.
Also stored here are navigation menu items, media files, images, and attachments. Content data used by plugins also sit in this table.
post_type is a table column within wp_post that categorizes the above-mentioned data. It allows users to request specific types of data using a database query.