Tag Info

Hot answers tagged

7

My perspective about your list of questions If i want to add a column in Club that describes the owner, who will also be a member, what is the best approach without having the same member listed twice? If, as you stated in your specifications, a Person can be a member of only one Club, one option is adding a column called IsClubOwner to the Person ...


1

If an owner is always a member of his club. Add ownerId to the Club-table, and put the personId in there of the member that is owner. Autoincrement an Id is good. You could add another field 'code', there you put the members code on the club-card in there. Should be automatically ok (i think) Put personId in Phone numbers and email table. ... You can't be ...


1

It seems that you have run into the reason why NULLs exist in relational databases. Choosing an arbitrary value from somewhere is a little crazy as you describe. Options: Create the needed key (PK or other Unique value) prior to doing the update of the data. This would require you to pre-decide how to fill each Not NULL FK. Obviously you want the FK to ...


1

Take a look at the InnoDB Internals (Picture from Percona CTO Vadim Tkachenko) Please note the data dictionary inside ibdata1 (the system tablespace) It sounds like you have a broken data dictionary entry on the task table when it existed The only way around would be move all the tables into another database. For starters, suppose you have database ...



Only top voted, non community-wiki answers of a minimum length are eligible