Where is custom template file chosen for a post stored in the DB?

Where is the custom template file that has been selected through the wordpress edit screen (for a post or page) stored in the wordpress database?

It’s in the post meta table (usually wp_postmeta), with the page id in post_id, meta_key with _wp_page_template and meta_value with the template file name.