Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: vehicle to autoparts relationships

Re: vehicle to autoparts relationships

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 26 Nov 2006 12:25:54 -0800
Message-ID: <1164572754.053809.295460@j44g2000cwa.googlegroups.com>


>> 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 - 14:25:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US