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

2007-05-31 Thread Igor Tandetnik
P Kishor [EMAIL PROTECTED] wrote: 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 organization, and, of course, an organization may

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

2007-05-31 Thread P Kishor
On 5/31/07, Igor Tandetnik [EMAIL PROTECTED] wrote: P Kishor [EMAIL PROTECTED] wrote: 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)

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

2007-05-31 Thread Andrew Finkenstadt
On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: I realize that I didn't explain the problem well enough (thus is the peril of being too close to it for a long time). I can have an (org -- org) relationship or an (org -- person) relationship as well as a (person -- person) relationship. To make

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

2007-05-31 Thread P Kishor
On 5/31/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote: On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: I realize that I didn't explain the problem well enough (thus is the peril of being too close to it for a long time). I can have an (org -- org) relationship or an (org -- person)

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

2007-05-31 Thread Andrew Finkenstadt
On 6/1/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote: On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: On 5/31/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote: On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: I realize that I didn't explain the problem well enough (thus is the peril of

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

2007-05-31 Thread Andrew Finkenstadt
On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: On 5/31/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote: On 5/31/07, P Kishor [EMAIL PROTECTED] wrote: I realize that I didn't explain the problem well enough (thus is the peril of being too close to it for a long time). I can have an (org