an unconstrained numeric column. Also, factor out some duplicate code into functions, to ease future maintenance.