To get a table in drupal 7 same as content_type_[your_field_name] in drupal 6?
That depends what fields you have defined in your content type.

An easier way is to load the node object and fetch your data from it.

$node = node_load($nid);

If you install the Devel module you can do dpm($node); and find how to access all data attached to your node.