SQLite – AUTOINCREMENT

The AUTOINCREMENT keyword can be used to automatically insert IDs as you insert records into a database table. Every record in a database table should have a unique ID. Instead of keeping track of that yourself you can let SQLite do that in your database table for you.