How to import posts from a csv file to WordPress blog Database

I have a csv file with the following columns

Title | Content | Image | Category

I want to import this csv file to WordPress database. I know a csv file can be imported via phpmyadmin. But when i opened the table 'wp_posts' i couldn't find any columns that says image or category.

Are those in another tables? If so how can i import it?

via Chebli Mohamed