Subject:
|
Technic DB outline
|
Newsgroups:
|
lugnet.publish
|
Date:
|
Tue, 7 Mar 2000 00:30:02 GMT
|
Viewed:
|
1008 times
|
| |
|
|
I have been working on putting the information from my
Technic set index into a database using all of the information I currently
record on my web site. Because I don't know relational DB theory very well it
has been an interesting project!
Because many of you do know RDB theory I would appreciate any input.
Here is part of the first try at fields/tables. Please comment as necessary.
The example is based somewhat on:
http://w3.one.net/~hughesj/technica/index/8200/8229.html
NAME TABLE
This table allows for multiple set names and set numbers to be associated with
1 set. It also allows for multiple set names over a period of years from a
given country.
set_no Lego set number
set_name Set name
iso2_code 2 letter code for the set name country
name_date date of the set name for a particular country
name_source source of the set name for a specific country
name_id | set_id | set_no | set_name | iso2_code | name_date | name_source
1 8229-01 8229 Tread Trekker US 1997 NA retail
2 8229-01 8229 Warthog UK 1997 European
3 8229-01 8229 Red Grease Band AU 1997 Australian
SET TABLE
This table is general set information
set_type Type of model (car, helicopter, crane, etc)
date_rel release date
date_dis discontinue date (N.B.: Lego sets are discontinued, not retired!)
date_note notes about release/discontinue dates
element_cnt element count
element_source source of element count
set_id | set_type | date_rel | date_dis | date_notes
8229-01 vehicle 1997 1998 released in US in 1998
element_cnt | element_source
186 NA retail box
INSTRUCTION TABLE
This table is general instruction book information. Allows for multiple
instruction books/other media to be associated with a single set.
inst_pages No of pages in instruction book
inst_size Size of instruction book
inst_note Instruction book notes
set_id |inst_pages | inst_size | inst_note
8229-01 32 A5 Instructions for the main model
8229-01 32 A5 Instructions for all-terrain forklift.
Well there is still alot more table building to go but this at least gets
me started on the project
|
|
1 Message in This Thread:
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
