This site is supported by the advertisements on it, please disable your AdBlocker so we can continue to provide you with the quality content you expect.
  1. 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!
    Dismiss Notice
  2. 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!
    Dismiss Notice

BP Stats/Content Engine Data Fields Document

Discussion in 'Administrative' started by Clarity, Jul 18, 2004.

  1. lvbuckeye

    lvbuckeye Silver Surfer

    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!
     
  2. OilerBuck

    OilerBuck Sweet Crude

    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.
     
  3. Buckeyeskickbuttocks

    Buckeyeskickbuttocks Z --> Z^2 + c Staff Member

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

    Probably just an issue with my home PC.
     
  4. Clarity

    Clarity Will Bryant Staff Member

    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.

    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.
     
  5. OilerBuck

    OilerBuck Sweet Crude

    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.
     

Share This Page