Standardise table.sql file

Created by: james-monkeyshines

Description and Use case

The new datacheck for validating a db schema uses the table.sql file. This is mostly consistent already, both within the file and between instances of the files in different repositories. But there are a few simple changes to terminology and formatting that would further standardise the files. These sorts of things can be handled in the datacheck code, but having fewer, and less complicated, exceptions makes the code more robust and easier to understand.

Benefits

Datacheck is simpler. Standardisation and consistency are generally good things to aim for.

Possible Drawbacks

None I can think of.

Testing

Unit tests not relevant. I created databases before and after the changes, and the results were identical.