Re: [sqlite] db design mixing different entities in the same table

Does a person ever belong to more than one organization? If so then use the following: Create table orgs ( org_id integer, org stuff); Create table Persons(person_id, person stuff); Create table persons_orgs(person_id, orig_id); The persons_orgs is a mapping table that allows one

[sqlite] db design mixing different entities in the same table

Not a SQLite-specific question per se, but a (SQLite) db design question. I am modeling entities and their relationships to each other. A classic network digraph kind of stuff. The entities are organizations or persons. A person may be associated with none (org type "unassigned") or one organiza