All Comments
TopTalkedBooks posted at August 20, 2017

I find the Data Model Resource book to be a good source of inspiration for modeling business structures. Apache Ofbiz ERP was built around the concepts in this book.

TopTalkedBooks posted at August 20, 2017
TopTalkedBooks posted at August 20, 2017

This is not a great design.

You should read up on the Party Model, and Table Inheritance to see a design built to last. A skeleton:

PARTY
id

ORGANIZATION : PARTY
name
doing_business_as

INDIVIDUAL : PARTY
first_name
last_name

PARTY_RELATIONSHIP
from_party_id references party(id)
to_party_id references party(id)
from_date
to_date

ORGANIZATION_CONTACT_RELATIONSHIP : PARTY_RELATIONSHIP
Top Books
We collected top books from hacker news, stack overflow, Reddit, which are recommended by amazing people.