I'm developing a system where multiple entities will have address.
Example: the school has an address, the student has an address, the teacher has an address, the providers have an address, etc.
I am trying to use a table to store every address used in the system. And then, every time I need an address, I'll refer to it by its id in the address table.
Since the system is not very large, would this be a good way to work with addresses?
What was sounding bad, it was all these entities having the fields: city, neighborhood, state and etc.
Is there any better implementation of the entity address in this case?