I am new to WP. I tried reading up as much as I possibly can online, and via browsing through the files. As far as I can tell, no physical pages/links are stored on the disk, so when a page is created, the data is stored in the wp_posts table, and the post metadata is in the wp_postmeta table. My questions are:
I am assuming that nothing is stored to disk, with the exception of uploads that go into the wp-contents/uploads directory. Is this correct?
Are there any other tables involved in the posts? as in, if I delete the post from the wp_posts and all relevant data from the wp_postmeta, does that get rid of the post?
How does WP know if this is a page or a post? which table is that info stored in?
Are the wp_comments and wp_commentmeta tables the only tables involved in comments. As in, if I write as script to delete a comment from this table, along with its metadata, will that completely eliminate the post?