Where is the post featured image link stored in the WordPress database?

Question

Where is the featured image link stored in the WordPress Database? I searched in the wp_postmetatable but I cannot find out the exact post_id and links.

Is this correct? Could anyone please explain to me how it works?

Answer 1

The post featured image link stored in the WordPress database is stored in wp_postmeta with a meta_key called _thumbnail_id.

You can see the example below:

Meta_id   post_id   meta_key   meta_value

200         4 _thumbnail_id    48

And, the actual thumbnail link is then contained in wp_posts with a post_type of attachment. 

Example:

ID   post_type    guide

48   attachment   Link