ALL (663354), страница 13
Текст из файла (страница 13)
Constraint FK_SuppPayAkkreditiveA FOREIGN KEY (AkkreditiveID) References Akkreditive ( RecID ),
Constraint FK_SuppPayAkkreditiveSP FOREIGN KEY (SuppPaymentID) References SuppPayment ( RecID ),
CONSTRAINT U_SuppPayAkkreditiveSPID UNIQUE ( SuppPaymentID, AkkreditiveID)
);
Alter Table SuppPayBooking Add (
Constraint FK_SuppPayBookingSP FOREIGN KEY (SuppPaymentID) References SuppPayment ( RecID ),
Constraint FK_SuppPayBookingBD FOREIGN KEY (BookkeepDocID) References BookkeepDoc ( RecID ),
CONSTRAINT U_SuppPayBookingBDID UNIQUE ( BookkeepDocID, SuppPaymentID)
);
Alter Table Tarife Add (
Constraint FK_TarifeOrders FOREIGN KEY (OrdersID) References Orders ( RecID )
);
Alter Table WorkersChild Add (
Constraint FK_WorkersChildhe_fatherS FOREIGN KEY (Staff_he_fatherID) References Staff ( RecID ),
Constraint FK_WorkersChildhe_motherS FOREIGN KEY (Staff_he_motherID) References Staff ( RecID ),
Constraint FK_WorkersChildisStaff FOREIGN KEY (Staff_isID) References Staff ( RecID ),
CONSTRAINT U_WorkersChildStaff_isID UNIQUE ( Staff_isID)
);