Working on a project where the database will be migrated from MS SQL Server to MySQL. All fine, however the client
is requesting that the schema remains the same. This means that table names are not pluralized and id is not just ‘id’ but
the table name and id (i.e. table_id)
All in all it’s not a huge database, I’m looking at 30 tables total, but want to consider first the extra work I’ll have to do to make
it all play together nicely. Any opinions ?
and if I remember correctly from AWDWR the id column is probably not a big deal, but the singular table names disturb me.