In our database we have separate Address table, Person table and a Link table. Link table also has a type of the address field.

Right, as I said, there are plenty of variations out there, and that's one of them. In some circles, with geospatial data, you see one of the address tables as more of an outrigger type table. But in any case, no need for NULLs.