Mini-Z, Kyosho Mini-Z Racer, MR-03, MR-02, MA-010, Forums, News, Pictures, Parts, and Shop - Mini-ZRacer.com
Forums, Mini-Z, MiniZ, Kyosho Mini-Z, Kyosho MiniZ, Kyosho Mini-Z Racer
Mini-Z Hop-Ups, Mini-Z Parts, MiniZ Hop-Ups, MiniZ Parts, Kyosho Mini-Z Hop-Ups, Kyosho Mini-Z Parts, Kyosho MiniZ Hop-Ups, Kyosho MiniZ Parts, Kyosho Mini-Z Racer Hop-Ups, Racer Kyosho Mini-Z Parts
Old 2013.05.23, 01:03 PM   #1
TheStig
Addicted to RC and Racing
 
Join Date: May 2013
Location: KS, USA
Posts: 22
Entity Relationship Diagram for DB?

Hey guys,

There may be a way to generate this from RealStudio (do you use a free IDE by the way?) but I've not found it yet.

I'm adding "Car Setup Sheets" to the program as I use the software a lot in my basement (great work by the way). This will allow me not only to track the car setup but also to see the statistical differences in times through each setup.

I've already added a page and starting to look at the back end code (took me an hour or so to get used to RealBasic!). I've started to look at the DB relationships but wondered if anyone had a diagram (sketch or other) to short cut this. For example. I've already seen that the summary_table is a junction table creating the many to many relationship between racer_table and race_table (using the event_id and racer_id).

Any other info would be great. I'll probably end up creating a new table called car_setup_table and use another joining table to link to the race_table. Any info would be handy though.

It's been a few years since I looked into db relationships but it's all starting to come back

Cheers,

Adam
TheStig is offline   Reply With Quote
Old 2013.05.23, 08:52 PM   #2
pinwc4
Registered User
 
pinwc4's Avatar
 
Join Date: Aug 2005
Posts: 913
RealStudio (soon to be renamed to Xojo) does not have a tool for this as far as I know. Though with the rename to Xojo they are releasing a completely new IDE so maybe it will have this feature, I can hope at least. When Xojo is released the IDE will finally be free. It is supposed to be released on June 4th last I read.

Not surprised it took a while to get used to the code. I (along with another person that helped early on) did not have any idea what we were doing when this project started so we learned along the way, some ugly code in there still....

I do not have a diagram but I can generate something. There may be tools out there to do it automatically even. The database is just a standard SQLite database. Though because it is SQLite the relationships between tables are not enforced by the database. SQLite in the version I used does not have any true understanding of a foreign key. SQLite has since added that capability but I have not converted things as it is already working so why introduce bugs.

I would definitely recommend using a different table. This way any changes I make to the database would not impact what you are doing. At times I have added columns, renamed columns etc. so this would minimize conflicts.

If you have not already figured out what you need I should be able to create a diagram and post it tomorrow.

Maybe the work you are doing should be included in the main project? Something to think about at least.
pinwc4 is offline   Reply With Quote
Old 2013.05.24, 06:23 PM   #3
pinwc4
Registered User
 
pinwc4's Avatar
 
Join Date: Aug 2005
Posts: 913
OK, I made a quick diagram of the database. I excluded a few fields and tables that are no longer used for simplicity sake, and it does not include the newest tables in the source code as I may still change that structure but that should not impact what you are doing.

As you can see the database is pretty basic. You are just concerned about the 4 main tables, race_table, racer_table, summary_table and laps_table

pinwc4 is offline   Reply With Quote
Old 2013.06.04, 06:46 PM   #4
TheStig
Addicted to RC and Racing
 
Join Date: May 2013
Location: KS, USA
Posts: 22
Perfect thank you. I'll make my mods and check in the changes. Sorry I'm only getting to do this sporadically
TheStig is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Aney one have a color Wireing Diagram For the AWD min-z racerxcali Mini-Z AWD MA-010, MA-015 1 2006.12.03 02:07 AM


All times are GMT -5. The time now is 06:09 PM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2011 Mini-ZRacer.com
Mini Inferno Sale - Up to $85 Instant Savings!
Micro-T Hop-Ups
RC18R, M18, Micro RS4, Mini-LST, TamTech-Gear, Minizilla, RC18T, RC18B, RC18MT
shop.tinyrc.com Products

more»
Tiny RC Community News
[03/22/17] MZR was on vacation, didn't... : All kidding aside, the host experienced a bit of a server meltdown last week and efforts to restore the site to a new server took longer than anticipated. The current server is temporary until - more»
[11/25/15] Did You Hear? Our Black... : Hey Racers,
We're getting started a bit early with our Black Friday sale this year.  Generally we're not supporters of retailers opening early on Thanksgiving, but in our case, we're - more»
[06/30/15] shop.tinyrc.com: Have You... : Hey All! Just a quick reminder to everyone that we post all of our shop.tinyrc.com Newletters here on the MZR Forum. If for some reason you miss them in your email inbox, you can always see the - more»
Mini-Z, Mini-Z Racer, MR-02, MA-010
M18, M18T, RC18T, Mini-LST, Mini-T, Micro RS4, XRay, 1/18, 18th scale
XMODS, XMOD, Micro Flight, ZipZaps, ZipZaps SE, Bit Char-G, MicroSizers, TTTT, Plantraco Desktop Rover, SuperSlicks, Digi Q
Mini Inferno, Mini Inferno ST, half EIGHT, 1/16, 16th scale
Epoch, Indoor Racer, 1/43, 43rd scale
E-Savage, eSavage, eZilla, e-Zilla, HPI
Robots, Bots, Bipeds, Wheeled, Manoi, Roomba, NXT, Lego, Hacking
Crawling, Crawlers, Micro, RC, Losi Mini-Rock Crawler, Duratrax Cliff Climber
Kyosho Minium, Caliber 120, Minium Forums
Mini-Z Hop-Ups, Mini-Z Parts, Mini Inferno Hop-Ups, Mini Inferno Parts, M18 Hop-Ups, M18 Parts