View Full Version : My First Table
03-29-2007, 07:44 PM
I'm doing my first MySQL table and wanted some opinions on the best and cleanest way to do it. It's a table which is going to have information about competitions. So I have named the following columns, is my naming ok? Would any of you have done it differently?
comp_id INT PRIMARY KEY
Any opions/ideas would be much appreciated!
03-31-2007, 03:18 PM
I just all depends on what it is you are using the above for. I like keeping my column names simple (and easy for me to remember), but also to where I still know what they are going to be used for. Very similar to what you have above is probably the way I would go about creating the database. The only thing that I see above that would be a problem (and I assume you editted these out for easier readability), VARCHAR would need to have the value/length value. And also the comp_id (unless you will be manually updating the id everytime you add info to the db), you may want to set it to auto_increment.
comp_id INT(5) auto_increment PRIMARY KEY
Other than that; as said above, it all depends on the use for the database that the structure should be based upon.
Hope this helps.
03-31-2007, 03:29 PM
I use the TEXT keyword for long arguments as well.
04-01-2007, 12:48 PM
If anyone can give me an opinion as I've never made my own table before...
So basically the competition would have a Name, Description, Main Prizes, Consellation Prizes, Start Date and End Date. Also their might be 10 Main Prizes and 20 Consellation prizes, so there would be numerous codes, that could mean a competition entrant is a winner... Could someone have a look at the tables I've planned out, they don't seem 100% correct... I can't work out the linkage...
04-02-2007, 07:17 AM
Hey tomyknoker can you explain what you are trying to achieve with these tables then can offer you more help anyway your latest table structures looks non optimized ones.
04-02-2007, 09:05 AM
Hey tomyknoker can you explain what you are trying to achieve with these tables then can offer you more help anyway your latest table structures looks non optimized ones.Ok well basically I want to be able through a php page which I'll set up be shown competitions that I am running at any given time. From the start say I am beginning my first ever competition the key elements would be:
> Competition Name
> Competition Description
> Prizes For The Competition & Their Respective Prize Codes
> Competition Start & End Date
There would usually be maybe 5 major prizes (different for each comp) and then a whole lot of consellation prizes (also different for each comp). People would enter a prize code they received, and it would relate to one of the prize codes in the db... They could be a winner of a major prize, consellation prize or simply not a winner... So this is where I get confused about how many tables I should have and what links to make... Any help/opinions would be greatly appreciated! :D
Powered by vBulletin® Version 4.2.2 Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.