Working on a project where the database will be migrated from MS SQL
to MySQL. All fine, however the client
is requesting that the schema remains the same. This means that table
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
deal, but the singular table names disturb me.