mySQL question party

[R.H.]

Look up Google for the party entity relationships diagram or schema.

A "party" is either a "person" or a "organisation" (company, org) The party
is an entity ( table) that has an id. The org or person tables have a
foreign key to the party id. It is a mutual exclusive relationship. A party
must never be both.

Through the party id you have access to org and person.

The party interacts through a role and relationship table. So party "Smith"
with the role "employee" is employed by employer party "My company Ltd."
with the role "employer".

If you need the "role" entity is something you must decide. But the
relationship table is essential. Any relationship can be created with this
many-to-many table.

These are starting steps... )

Roland