Tighten/Audit Schema Definitions

[DarkPurple141]

1. Schema has unnecessary VARCHAR(8000)s.. etc
2. Schema is more or less translation from old schema, maybe it can be better (fresh eyes and all that)