Hello there, I'm putting the below design in to phpmyadmin. At the moment I've created new tables and datatypes for fields for customer,invoice and Cakedesign.I am now about to do the same for table order but notice that there are foreign keys. Can anyone tell me how I implement these in phpmyadmin. Do i have to link them to the other tables somehow? tblCustomer (cID, cFName, cSName, cAdd1, cAdd2, cPostCode, cTelNo)tblInvoice (invID, invDate)tblCakeDesign (cDesID, cDName, cDType, cDSize, cDImage, cost)tblOrder (orID, orderDate, dateRequired, cID, cDesID, invID, inscription, depositPaid, completed) FK cID?tblCustomer Update Cascade, Delete Restrict FK CDesID?tblCakeDesign Update Cascade, Delete Restrict FK InvID?tblInvoice Update Cascade, Delete Restrict
Physical Design question
Posted - 2011-04-24 : 21:59:22
