Database table school - Kosudo/nextSIS GitHub Wiki

##The fields

###id (primary) I've made this an unsigned MEDIUMINT which gives us over over 16 million records - [16,777,215 specifically] (http://dev.mysql.com/doc/refman/5.5/en/numeric-types.html). Again, this is just being over-cautious, but just in case an unsigned SMALLINT (65,535) isn't enough - there's always that vague distant future prospect of a large rollout(!)