-Original Message-
From: Donald Tyler [mailto:[EMAIL PROTECTED]
Sent: 30 July 2003 16:42
To: [EMAIL PROTECTED]
Subject: Advice wanted on Data Structure
I have a question that I hope I can explain well enough:
I am trying to figure out a data structure for an inventory
system.
I try a solution like this. It's kind of a tree [so your warned that this
structure will be a waste of time if you have a subkit to a subkit to a... ]
KITS
kt_id int
kt_things.
parent_kt_id_fk int
constraint fk_KITS foreign key (parent_kt_id_fk) references kits(kt_id)
For details consult
Donald,
I've done this before - it wasn't nice. The best solution I came up with
was to store the kits in the item table as though they were items. So
the structure is: (Lets call a 'Product' an Item or a Kit depending on
the 'prod_type')
PRODUCT KIT CONTENTSPRODUCT