Why not also add the minimum required version?

I suppose that needs more explenation. I would do my schema like this:

• modules -- contains information about the module, such as version, package name and so forth
• dependancies -- a cross ref that maps dependancies. Yes, this circles back to modules. This is where you put minimum required version, if set.

In this set up, you don't need to record if something is pragma or not as your modules table should contain that data.

You may also want to explore the fact that a file may contain many modules and that there are pl (perl libraries) that get loaded as well.

I also recommend writing it with a DBD::CSV backend as it could eventually replace perllocal.