CODE EXAMPLE FOR SQL

sqlite create integer column with limit

create table . . .
    check (phonenum between 0 and 99999);