Where is the user content stored in the database?

You really, really don’t want to put data into the database tables directly. Stick with using the ActiveRecord models, which take care of a whole pile of “bookkeeping” behind the scenes for you. That’s what (nearly) all of the existing importers do.