How do i create node directly from my own module with data of my tables
From the information you provided I would handle this the following way:


Create a custom content type via the GUI with all the fields that you need.
Create a custom module and register a path via hook_menu(). I would set 'page callback' =&gt; 'drupal_get_form', 'page arguments' =&gt; array('mymodule_create_content_form') and 'access callback' =&gt; 'mymodule_admin_restriction'. mymodule_admin_restriction would be a function to allow access to user 1 only. mymodule_create_content_form would be a custom form builder function with just a submit button.
In the form submit handler I would then write code to extract data from the database and create new nodes from it. The easiest way to get data out of your database would probably be with db_query().
For programmatically creating nodes you could use either node_save() or drupal_execute(). The first one is a quicker option while the second one more closely mimics normal node creation by invoking additional hooks. You should be able to find a solid amount of information about them on the web (for example here, here and here).


This approach should be fairly good to get started with. Once you get the whole thing working without errors (in your development environment) you could move the code to your module's install file's hook_install() and maybe even programmatically create the new content type there if needed.