Re: Portal Database design help

[Rick James]

Yes and no.
You have moved toward "normalization", which is (usually) good.

However, I wanted you to change the phone number from columns to rows:
Instead of:
contact_numbers table
company_id | phone1 | phone2 | mobile1 | mobile2 | fax1 | fax2

contact_numbers table
company_id | type_of_number | number

A small company with just one phone would have 1 row; a huge company might have 6, or even more, rows.

Another approach (assuming you never need to search on numbers):
contact_numbers table
company_id | numbers
where 'number' is a string looking like (say):
"phones: 321-432-2300, 321-432-2301; fax: [phone]"
In other words, human readable, but otherwise an arbitrarily formatted string.

Any of the above will "work". You will find out later which works best in your situation.