Is their a unique signature value for the state of of an sqlite3 DB (or table)?

I was looking for some single value that tracked the writes to either 开发者_如何学运维the DB or an individual table in the DB.

I would like to say "This data was extracted at this time, from this DB, in this state"

I am not bothered about future updates recreating the data of the table, just information equivalent to a simple count of the number of writes would do.

This would allow me to record the same info when I did other extracts from the DB and so could check to ensure consistency.

Thanks in advance :-)

Use the database file's modified date and time from the file system.