Resource types

I need to load 700 or 800 webpages as Moodle resources from a legacy system.

I was thinking of creating ..._resource table inserts in php using data extracted from the webpages: filename; subject from the <h4>...</h4> heading; snippet from the N words after the </h4> stripping out html tabs; etc. Then I could run these inserts to update ..._resource from their moodledata/<course> directory (in batches, taking all due database updating precautions of course).

Questions: Will this work? Has anyone else tried this? What other tables need updating at the same time, i.e. what tables need to be kept in referential integrity with the ..._resource table?
Where is documentation of what tables, fields (columns), indexes and so on are on the Moodle database?

I'd really appreciate some help with this...

(We're using Moodle 1.9 Beta 4/MySQL 4.1.22-standard/php 5.2.2)