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 13, 2012 08:09AM

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 ?
1769
April 13, 2012 08:09AM


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.