 | | 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)
|
