Re: vehicle to autoparts relationships

>> How does nested sets handle the part that is a part of multiple assemblies? <<

The tree structure is in one table which has nodes like this:

CREATE TABLE Assemblies
(part_nbr INTEGER NOT NULL

   REFERENCES Inventory(part_nbr)
   ON UPDATE CASCADE,
 part_qty INTEGER NOT NULL
  CHECK (part_qty > 0)
 ft INTEGER NOT NULL,
 rgt NTEGER NOT NULL,
  PRIMARY KEY (lft, rgt)
 << constraints >>);

The Inventory is keyed on part_nbr. Received on Sun Nov 26 2006 - 21:25:54 CET