in reply to determining table structure in SQLite database

As well as using DBD::SQLite via DBI's methods, you can use the sqlite3 command line tool:
sqlite3 <your sqlite database> .schema

Just substitute the file you've used for the database.