 | | Re: A Technic set DB outline
|
|
(...) Eh, whenever did I invent that term? And what have I done to popularize it? The weird term I made up for the FLG was "series." I don't like subtheme either, unless there is also the concept of supertheme -- as in subcategory and supercategory. (...) (26 years ago, 1-Dec-98, to lugnet.admin.database)
|
| |
| | Re: A Technic set DB outline
|
|
(...) In case accuracy WRT TLG is important here, the actual hierarchy looks like the following (I may never forgive Todd for his invention of the term "subtheme" :-P) Product Programme +- Product Line +- Product Theme "Race" is a theme in the "Town (...) (26 years ago, 1-Dec-98, to lugnet.admin.database)
|
| |
| | Re: A Technic set DB outline
|
|
First off, let me state that were I designing this from scratch I'd do an object model not a data model but... (...) You need a hierarchy table. Model it like this (not legit SQL) Table Theme ThemeID integer PRIMARY KEY NOT NIL ThemeType Code /* (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A Technic set DB outline
|
|
Larry: Thanks for your comments, this is exactly the type of discussion I hoped posting this would generate: (...) Yes. (...) It is. I am still trying to figure out how to put themes and subthemes into a table. (...) This makes alot more sense than (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
| |
| | Re: A Technic set DB outline
|
|
Jim Hughes wrote: Disclaimer: I am not a DBA but I do know enough SQL to be dangerous. Interesting. I comment on this as if it were a logical DB design. Do you have a downloadable schema (for erwin or whatever?) Some comments: Is recno designed to (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
| |
| | A Technic set DB outline
|
|
Hi: First, thanks for everyone's help with my earlier database question. Here is a new one: does anyone have a Lego database in a true relational format (with all of the normalization, etc)? I have come up with an outline that will hold all of the (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) Right, that's why the :) -- it seemed like an obviously good idea at first, but then I couldn't really think of many practical uses. (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) Is that a real :) or mostly a ;) ? I agree that a PerlRE would be cool (and not really difficult to add), but can you give some concrete examples of search queries which would benefit in a major way from a feature like that? I can see a bit of (...) (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Three Suggestions
|
|
(...) How about this?... (URL) least for the time being... --Todd (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
| |
| | Re: Updatezilla
|
|
What I tell people when they ask is that I can't give or revoke permission to use the images on my site because I don't own them in the first place. I agree it's a nettequette issue rather than a legal one. KL (...) (26 years ago, 29-Nov-98, to lugnet.admin.database)
|
