DEVILofDARKNESS Posted June 5, 2009 Share Posted June 5, 2009 Okay, I started over completely with my idea of browsergame, because the mysql-tables sucked and it was terrible to make a code to generate the right value. So my question is: Are these good tables? NATIONS nation_id nation_name nation_capital nation_money leader_id PACTS user_id1 user_id2 pact_type WEAPONS weapon_id wepaon_name weapon_price TECHNOLOGIES technology_id technology_name technology_price REGIONS region_id region_name nation_name RESEARSHED technology_id nation_id REGION_WEAPONS region_id weapon_id ammount USERS user_id user_name user_pass nation_id leader <= "Yes" or "No" Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/ Share on other sites More sharing options...
Maq Posted June 5, 2009 Share Posted June 5, 2009 So my question is: Are these good tables? Good tables? That's a bit ambiguous. Your tables should be normalized to reduce space, eliminate redundant data, and for basic DB organization. Please read through this article - Database Normalization - and tell me what normal form you think your table is in and how you think you can improve. What made you question your tables in the first place? Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/#findComment-850020 Share on other sites More sharing options...
DEVILofDARKNESS Posted June 5, 2009 Author Share Posted June 5, 2009 I think it's normalized, although I can't use foreign keys because I used MyIsam as storage engine instead of InnoDB, which is the only one that can handle foreign keys in PhpMyadmin. I just ask this question, because In my previous projects I just started with the code and from time to time I had to change whole the databse. And I want to make it as much easy as it can. Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/#findComment-850047 Share on other sites More sharing options...
alco19357 Posted June 7, 2009 Share Posted June 7, 2009 So my question is: Are these good tables? Yes. But are they final? In order to have "good" tables, the programmer must go through and finalize all aspects of the integration, thus lessing the stress of changing up the table later on. Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/#findComment-850878 Share on other sites More sharing options...
Ken2k7 Posted June 7, 2009 Share Posted June 7, 2009 I don't think you can really "finalize" it. I'm sure as time progresses and a new idea pops up, there may be changes. Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/#findComment-850883 Share on other sites More sharing options...
DEVILofDARKNESS Posted June 7, 2009 Author Share Posted June 7, 2009 Yeah I agree with Ken2k7. But I think these tables are good enough right now. Thanks everybody Quote Link to comment https://forums.phpfreaks.com/topic/161074-good-table/#findComment-850923 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.