• Follow us on Twitter @buckeyeplanet and @bp_recruiting, like us on Facebook! Enjoy a post or article, recommend it to others! BP is only as strong as its community, and we only promote by word of mouth, so share away!
  • Consider registering! Fewer and higher quality ads, no emails you don't want, access to all the forums, download game torrents, private messages, polls, Sportsbook, etc. Even if you just want to lurk, there are a lot of good reasons to register!

BP Stats/Content Engine Data Fields Document

Jump to latest Follow Reply
Sort by date Sort by votes
wow... every time i'm vainly searching for something that i can't find (such as the article that was written by a gentleman for a Chicago newspaper in which he recalls the last time he talked w/ Woody- the story ends w/ the Emerson line... but anyway), i find myself wishing for a database such as this... but the breadth and scope is mindboggling... this is a very ambitious undertaking... i struggle to see how it can be done with out ending up a PDA, but then again, i'm not the most computer savvy...

mucho props on the project!
 
Upvote 0
Clarity,

I just assumed you were already finished because the layout actually looked good. If you haven't set up the tables yet, I would be glad to help you out in any way.

You mentioned table and field naming conventions...I would always recommend naming everything so that it is easy to identify and use in your applications or in reports. If you get too technical in the names, the data becomes very hard to put together or to design around.

I really like the theoretical structure that you have set up. I would recommend taking fields that have the potential unlimited rows (such as kids, because players can have multiple kids) and set them up in an alternate table. This table would be small and not contain much information...but it will cause a lot less administrative headache than having Kid1, Kid2, Kid3 all the way up to 12 (if they are amish). There may be other fields like that as well, but I didn't notice them right off hand.

If your table needs relationships set up, I wouldn't mind mapping a visual representation of the data you've shown. From that, we could set up the primary and foreign keys to make the relationships between tables.

You may have all this done, I guess what I'm saying is...I don't mind helping with anything that has yet to be finished. But as far as concept...I think the database is set up pretty efficiently.

On another totally seperate note...

What software is used to run this site? I was thinking of looking into it for another page.
 
Upvote 0
OilerBuck said:
What software is used to run this site? I was thinking of looking into it for another page.
Click to expand...

A very customized version of vBulletin 3.01 (3.03 is current) from JelSoft. You can find them at http://www.vbulletin.com.

The programmer has done or is doing all the programming and dbase structuring and development.

Mostly I posted my doc here so that people could make suggestions about the content.

The biggest hurdles I see right now with the content system are finding more historical stats (we're talking with both the university and an archival group there), and the other is how the server will handle the strain of both the forum and the stats handling.

thebkb said:
Clarity - BKB computer problem update... I'm at work and everything works just fine...

Probably just an issue with my home PC.
Click to expand...

I just had MS Word spit that out from the document I had been working with, so I bet there's something in their awful HTML that caused problem with some setting on your home PC.
 
Upvote 0
The biggest hurdles I see right now with the content system are finding more historical stats (we're talking with both the university and an archival group there), and the other is how the server will handle the strain of both the forum and the stats handling.
Click to expand...
I'm pretty good at web research...feel free to PM me assignments for info and I'll try to take at least a small part of the burden off of you.
 
Upvote 0
You must log in or register to reply here.
Back
Top