It's often useful to peek around a sqlite database file from the command line,
especially those that applications use for storing their own internal data. In
this case, I was interested in looking at how Firefox stores a user's browsing history (which happens to be in the file called
places.sqlite inside the Firefox profile directory). Anyway, here are some commands you can run:
$ sqlite places.sqlite
sqlite> PRAGMA table_info(moz_places)
moz_places is the name of the specific table I was interested in.