я этого там тоже не нашел

ROWIDs and the INTEGER PRIMARY KEY
Every row of every SQLite table has a 64-bit signed integer key that is unique within the same table.
This integer is usually called the "rowid".
The rowid is the actual key used in the B-Tree that implements an SQLite table.
Rows are stored in rowid order.
The rowid value can be accessed using one of the special names "ROWID", "OID", or "_ROWID_".

If a column is declared to be an INTEGER PRIMARY KEY, then that column is not a "real" database column but instead becomes an alias for the rowid.
Unlike normal SQLite columns, the rowid must be a non-NULL integer value.
The rowid is not able to hold floating point values, strings, BLOBs, or NULLs.

An INTEGER PRIMARY KEY column is an alias for the 64-bit signed integer rowid.