The type affinity of a sqlite column is the recommended type for data in that column

Sqlite columns can have one of 5 type affinities - TEXT, NUMERIC, INTEGER, REAL or BLOB. This is related but not the same as storage classes, which refer to individual values.

The default type affinity is numeric unless you give some data that doesn’t fit it.

Sources

• the sqlite docs on type affinity