Where is the code for added user registration fields?
In the field settings, tick "display on user registration form". 

All of the database stuff is taken care of automatically in drupal so you'll rarely have to worry about that stuff unless you are adding your own custom modules that require tables.

What are you trying to accomplish with these tables? Views etc. will have access to them.