Tables in SQLite

Wherever you define a column of type integer primary key, SQLite will apply an function for the column to create and apply monotonically increasing values. That is, if no value is provided for the column in an INSERT statement, SQLite will automatically generate one by finding the next integer value specific to that column.