Where is Author Data Stored?
The PublishPress Authors plugin uses the taxonomy system in WordPress. Each author is stored as a taxonomy term. This is the most flexible way to add and remove multiple authors from each post.
You can find the author taxonomy in the wp_term_taxonomy table in your site’s database:
Each author is stored as a term. You will find each author as a single entry in the wp_terms table.
The information on each author is stored as term meta. You will find the term meta in the wp_termmeta table. The image below shows multiple rows for a single author.
The authors are connected to posts using the post_meta table. Each author connection to a post is a new row in this table. In the image below, the author “Steve Burge” is connected to the post with the ID 44152 using the meta_key of ppma_authors_name.