|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Database Tools Do you need to take a dump? SQL gurus welcome |
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
06-25-2006, 02:21 PM
|
#1 (permalink) |
|
Minors (Triple A)
Join Date: Apr 2006
Location: London, On
Posts: 204
|
A couple fields I'm not clear on....
Hello,
I'm wondering if someone can help me figure out what some of the fields in the database mean. In players table: "status" field (integer, values 0 through 6) Is this something to do with retirement, injuries, roster status, something else? team_roster table: "list_id" field (integer, values 1 through 4) Something to do with 25-man, 40-man roster?? I'm guessing 3 = 40-man roster 2 = 25 man roster 1,4 = DL?? Waivers?? players_contract table: "team_id", presumably the team the player is signed for. Yet, each team only has about 12 to 18 players signed (the dump was done just before the June draft, so rosters should be full.) Does this only list players with major league contracts? in a bunch of tables: split_id - I think I get this, but just to confirm: 1 = Total 2 = vs LHP/LHB 3 = vs RHP/RHB level_id - Again, just confirming: 1 = Major League 2 = AAA 3 = AA 4 = A 5 = Short A 6 = Rookie Thanks for any help you can provide.
__________________
"Man can now fly in the air like a bird, swim under the ocean like a fish, he can burrow into the ground like a mole. Now if only he could walk the earth like a man, this would be paradise." -Tommy Douglas www.DevinJohnston.ca |
|
|
|
06-25-2006, 02:22 PM
|
#2 (permalink) | |
|
Hall Of Famer
Join Date: Mar 2002
Location: Gainesville, FL USA
Posts: 3,308
|
Quote:
Hmm, I'm playing with the status fields as well but mine are all listed as 0.
__________________
If not perfection, when is good enough, good enough? |
|
|
|
|
|
06-25-2006, 03:25 PM
|
#3 (permalink) |
|
Hall Of Famer
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,059
|
I have a 0-6 in the status field as well, I havent figured out what it means yet.
__________________
A crude version of what I would like to see in-game: http://fantom1979.homeip.net/ootp/streaks.php "I'm not out here to win a beauty contest." |
|
|
|
|
06-25-2006, 10:56 PM
|
#5 (permalink) |
|
Hall Of Famer
Join Date: Jul 2002
Location: Detroit, MI
Posts: 3,059
|
i am using the Mysql dump
__________________
A crude version of what I would like to see in-game: http://fantom1979.homeip.net/ootp/streaks.php "I'm not out here to win a beauty contest." |
|
|
|
|
06-26-2006, 12:11 AM
|
#6 (permalink) |
|
Minors (Triple A)
Join Date: Apr 2006
Location: London, On
Posts: 204
|
Csv
__________________
"Man can now fly in the air like a bird, swim under the ocean like a fish, he can burrow into the ground like a mole. Now if only he could walk the earth like a man, this would be paradise." -Tommy Douglas www.DevinJohnston.ca |
|
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
