Results 1 to 2 of 2
Thread: file structure questions
Mar 16, 2011, 21:10 #1
file structure questionsCode:
id int(10) auto_increment primary key team_id int(10) year varchar(4) team ??? mascot ??? sport int(11) state int(11) conference ??? classification ???
I have these questions:
#1 - Should team be an integer linking it to a team table or just put the team name within it.
#2 - The same question as number one, but pertains to mascot table.
#3 - Conference would most likely be something similiar "East", "Central", etc. Would it just be best to put that in it, or make a table and put the descriptions in, linking them with a foreign key
#4 - Same as the above, but would hold information akin to "AAAAA" or "AA", etc..
Which would be faster and more friendly when trying to extract data/compare things?
The thing is that each team would have to have conference and classification put together too, like: AAAA East, AA Southwest Things of that nature
id, team_id, year, school, mascot, sport, state, conference, classification