Database Design Done!
I’m glad to report that the database schema has now been designed! I’ve written, tested and optimised the SQL queries and put the whole thing into PHP. I’ve taken care to make sure that the database will be manageable. Once we get up and running, it needs to be able to automatically maintain itself as much as possible. So there are fields in there like negativeVotes etc. which will all be available via the API. There will be the ability to flag suspect numbers and remove and update numbers as they change.
Before launching it on a public page, I’m going to let it settle for a few days, see if I can break it and once that’s done the “Add Number” page will go live so that we can begin to fill up the numbers.