Single address table for company, company_branch, users I'm a database noob and i'm asking this simple question because i found no answer to my question. I'm using MySQL.
I have 3 tables Company, Company Branches, Users and these 3 tables have similar fields like address. So i want to store address information of company, company branch and user in a separate table "address_information". 
Can i achieve this?
I would suggest something like this.


The tool used to data modeling is SQL Developer Data Modeler