 | | Lego classification system
|
|
Here is an outline of the first levels of the classification system I'm implementing. It's derived from Auczilla categories to some degree, but I limited the number of categories to nine. Each category can have 9 sub-categories, with a further 9 (...) (25 years ago, 11-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 (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | 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 (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) 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 (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | 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 (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Gryphon Bricks (Mac) -> LDraw database
|
|
I've put together a few pages with an inventory of the Gryphon Bricks parts, and attempted to cross-reference them with LDraw pieces from Steve Bliss' site. Take a look at: (URL) is a first pass: there are some mistakes here and there, and quite a (...) (25 years ago, 9-Feb-00, to lugnet.cad, lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) Yep. (...) Oh, and each description should probably be tagged with a source. That way, when we change the description of some part in LDraw, the cross-reference database can be updated. (...) Yep. A better approach may be modeling a set of (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) collate. (...) Yep. The difficulty is in matching up the descriptions from the various sources (e.g. which LDraw part is this Technica part?). Sometimes it's easy, somethimes it's not. (...) Yep. (...) part (...) a (...) and (...) That's the (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) went in and updated the description parameters to include a count of holes in the piece. So if you see the page before I've updated the page with a new image, just pretend there's a hole-count category, OK? Thanks again. Billb. (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) From the discussion so far, I can tell that some of us may be confusing a classification system with being able to identify a Lego element. In the perfect database, the inquiry about a piece would not need to know *anything* about how the data (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | 6445 Emergency Evac
|
|
Set 6445 - Emergency Evac Manual Piece Count: 99 Piece Count on Box: 97 Distinct elements: 63 * indicates part does not count toward total Qty Color PartID Description 1 Black 3006 Brick 2 x 10 2 Yellow 4211 Car Base 4 x 5 1 Yellow 3788 Car Mudguard (...) (25 years ago, 7-Feb-00, to lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) 'The database' should allow multiple descriptions per piece. And should have the major descriptions pre-loaded. The core element table should have an abstract key value, and a pointer to a graphic image for each part. A second table, call it (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: does anyone have...
|
|
(...) I've got the box scanned for #7851: (URL) hesitant to open the box, since I'm waiting to see if anyone wants to buy/ trade for it. It sounds like the pieces are polybaged inside, though, so there's probably some kind of insert (maybe just a (...) (25 years ago, 7-Feb-00, to lugnet.trains, lugnet.general, lugnet.db.scans)
|
| |
| | Re: The Lepanadat Project (update 1)
|
|
(...) Of course you can use the database I'm working on now for a set inventory. Creating a set inventory was also one of my goals when I started with the Lepanadat project, but it takes a lot of time, so it would probably take many, many years (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) One problem we have at the moment is that the various sources of parts lists (LDraw, Tim Vattima's set inventories, Auczilla, Technica, etc) all contain different subsets of the full parts list and use different descriptions. We need to (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) I (...) to (...) Perhaps (...) be (...) Sounds good to me! I'm going to begin by designing the database to hold the data, and deciding on the best method to catalog the parts, or the best existing database to use for the parts. Any suggestions (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) It was... 2 letters off is less than 10% margin of error, which is good enough when you're estimating. :-) Are you sure there isn't an umlaut or AE joined or something in his last name? :-) (25 years ago, 5-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) Nope, "Linnaeus" is spelled correctly. However if the "A" above refers to his first name that's wrong, his first name is Carolus. If not, nevermind. -Chris (25 years ago, 5-Feb-00, to lugnet.db.brictionary)
|
| |
| | 8448 Super Street Sensation Inventory per box
|
|
Set #8448 Super Street Sensation Year: 1999 MSRP: US$129.99 Pieces: 1408 Figures: 0 Inventoried by: John Creek (Snake Plissken) E-Mail: crow@technologist.com Parts Reference Taken From Lego Elements Image Catalog Reference URL: (URL) #1 - Chassis (...) (25 years ago, 5-Feb-00, to lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) There seems to be a fair number of people interested. I think we should try to combine our efforts as far as possible, to avoid duplication of work. Perhaps this thread should be taken to lugnet.db.brictionary where there appears to be a fair (...) (25 years ago, 5-Feb-00, to lugnet.db.inv)
|
