Re: Database design and foreign keys

[David Fells]

You can only use foreign keys with the InnoDB engine at this point. Of course you can use logical foreign keys to relate the tables but this doesn't enforce referential integrity at the database level. In your situation you would simply have a field in the customer table containing the id of the appropriate record in the sales table (if not an id, then whatever your primary key is).