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

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

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 <-->

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.

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 >

[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