Re: [GENERAL] self referencing table structure and constraints

2004-09-23 Thread Matthew Hixson
On Sep 23, 2004, at 6:36 PM, Stephan Szabo wrote: On Thu, 23 Sep 2004, Matthew Hixson wrote: I have a categories table that contains a FK to another category in the same table, creating a hierarchy. At the very top is this row: category_id | name | description | parent_id -

Re: [GENERAL] self referencing table structure and constraints

2004-09-23 Thread Stephan Szabo
On Thu, 23 Sep 2004, Matthew Hixson wrote: > I have a categories table that contains a FK to another category in the > same table, creating a hierarchy. At the very top is this row: > > category_id | name | description | parent_id > -+--+-+--

[GENERAL] self referencing table structure and constraints

2004-09-23 Thread Matthew Hixson
I have a categories table that contains a FK to another category in the same table, creating a hierarchy. At the very top is this row: category_id | name | description | parent_id -+--+-+--- 1 | ROOT | The top level category