Re: help with nested set
From: lawpoop <lawpoop_at_gmail.com>
Date: Mon, 20 Apr 2009 10:20:40 -0700 (PDT)
Message-ID: <3a3d2c98-69b3-4ae2-8c2d-1f834b854b85_at_r13g2000vbr.googlegroups.com>
Date: Mon, 20 Apr 2009 10:20:40 -0700 (PDT)
Message-ID: <3a3d2c98-69b3-4ae2-8c2d-1f834b854b85_at_r13g2000vbr.googlegroups.com>
On Apr 16, 4:13 pm, Gene Wirchenko <ge..._at_ocis.net> wrote:
>
> Entity
> id client_id level
> 1 1 Corporate
> 2 1 Franchise 1
> 4 1 Eastern Region
> 5 1 New York District
>
> ParentEntity
> id parent_id
> 2 1
> 4 1
> 5 4
>
> Since Corporate does not have a parent, it does not have a row
> in the ParentEntity table.
;) Clever. Received on Mon Apr 20 2009 - 19:20:40 CEST