MySQL Forums
Forum List  »  InnoDB

Does InnoDB run bugless if PK is FK of same table relating to PK of an other table ?
Posted by: Baron Muenchhausen
Date: April 12, 2012 02:53PM

Question: Will the following Part of my DataBase run bugless with InnoDB of MySQL?? Please consider all PK-FK relations!!

PK:PrimaryKey FK:ForeignKey PKa belongs to FKa

table BorrowingProcesses:
PK[ FKBarcode, DateOfIssue ], FKCustomerID, DesiredDateOfRefund, DateOfRefund, FKaBorrowerStaffID, FKaTakeBackStaffID, Paid

table Customers:
PKCustomerID, FKFirstName, LastName, Email, PhoneNumber, FK[ FKCountryID,Zipcode ], Street, HouseNumber

table Companies:
PKCompany, POBox, FKCustomerID

table AcademicDegrees:
PK&FKCustomerID, AcademicDegree

table Staff:
PKaStaffID, StaffFirstName, StaffLastName, Password[encrypted]

all other relations between tables are unproblematic 1:mc-relations

Options: ReplyQuote


Subject
Views
Written By
Posted
Does InnoDB run bugless if PK is FK of same table relating to PK of an other table ?
2052
April 12, 2012 02:53PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.