Subject:
|
Re: Online LEGO Inventory Database
|
Newsgroups:
|
lugnet.db.brictionary
|
Date:
|
Thu, 10 Feb 2000 19:33:02 GMT
|
Viewed:
|
2746 times
|
| |
|
|
In lugnet.db.brictionary, Steve Hodge wrote:
> In lugnet.db.brictionary, Steve Bliss writes:
> > Yep. A better approach may be modeling a set of properties. So a plate with
> > holes in it could have both the Technic and Plate properties. This would • avoid
> > requiring a hierarchical classification (is that redundant?) system.
>
> Yeah, I agree. One of the other threads had come to the same conclusion and
> are curently trying to decide exactly which properties would be necessary.
Having a good list of properties at the start is a good idea, but don't
hard-code specific properties into the schema. It's just a many-to-many
relation between parts and properties. Assuming a relational approach.
Steve
|
|
Message has 2 Replies:
 | | Re: Online LEGO Inventory Database
|
| Steve Bliss wrote in message ... (...) with (...) and (...) It will be a relational database, and I tend to remove all hard codings possible. I will be designing the schema later today, and posting it for everyone to rip apart =) --Eric (24 years ago, 10-Feb-00, to lugnet.db.brictionary)
| | | Re: Online LEGO Inventory Database
|
| Steve Bliss wrote in message ... (...) with (...) and (...) Here is the current scema. I have decided to concentrate on the parts section, and themn move onto creating a set inventory section (which I think will be the easy part)... Total of 6 (...) (24 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
Message is in Reply To:
| | Re: Online LEGO Inventory Database
|
| (...) have (...) I'd thought about this earlier, but forgot to mention it. (...) based (...) Once (...) avoid (...) Yeah, I agree. One of the other threads had come to the same conclusion and are curently trying to decide exactly which properties (...) (24 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
9 Messages in This Thread:
  
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
