Normally a primary key ID column is set to be an integer. the rule of thumb is to set it to Auto Increment, this will start at 1 and automatically increment to the next value each time a new record is added. the value of an integer can be up to 2,147,483,647.