To merge address or not to merge addresses?
<p>Working on a sqlalchemy python flask postgresql project but not sure if I should merge my tables together. I first started off with company address in early development stages now I have another address table. </p>

<p>Should I keep these separate or should these be merged to a global Address table?</p>

<pre><code>UserAddress
CompanyAddress
</code></pre>

<p>If I do merge them together to an Address Table it would be something like the following... however in the long run I still have more user_id than company_id and would mostly be blank. </p>

<pre><code>Address
-user_id
-company_id
</code></pre>

<p>Companies and user can have multiple addresses... so this is why I'm thinking of using this approach but in the long run. Also I'm not sure if it is a good idea as for maintaining this. Or should I leave them as is and maintain them separately?</p>

<p>Thanks! And if possible, share your experience in dealing with similar situations?</p>