Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29

Alter Table Place Add (
Constraint FK_PlaceProfession FOREIGN KEY (ProfessionID) References
Profession ( RecID ),
Constraint FK_PlaceDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID ),
Constraint FK_PlaceTypeQuantity FOREIGN KEY (TypeQuantityID) References
TypeQuantity ( RecID ),
Constraint FK_PlaceSalaryType FOREIGN KEY (SalaryTypeID) References
SalaryType ( RecID )
);

Alter Table PlaceEmpAssoc Add (
Constraint FK_PlaceEmpAssocPlace FOREIGN KEY (PlaceID) References Place (
RecID ),
Constraint FK_PlaceEmpAssocAddressee FOREIGN KEY (AddresseeID) References
Addressee ( RecID ),
Constraint FK_PlaceEmpAssocStaff FOREIGN KEY (StaffID) References Staff (
RecID ),
Constraint FK_PlaceEmpAssocOrders FOREIGN KEY (OrdersID) References Orders
( RecID ),
CONSTRAINT U_PlaceEmpAssocU1 UNIQUE ( DateStart, DateEnd, StaffID,
PlaceID)
);

Alter Table Profession Add (
Constraint FK_ProfessionGP FOREIGN KEY (GroupProfessionID) References
GroupProfession ( RecID ),
CONSTRAINT U_ProfessionU1 UNIQUE ( Code)
);

Alter Table QueueOfApartmentReceiver Add (
Constraint FK_QOARqueueingS FOREIGN KEY (Staff_queueingID) References Staff
( RecID ),
Constraint FK_QOARRDQ FOREIGN KEY (ReasonDissQueueID) References
ReasonDissQueue ( RecID ),
CONSTRAINT U_QOARS_ID UNIQUE ( Staff_queueingID)
);

Alter Table Staff Add (
Constraint FK_StaffGrade FOREIGN KEY (GradeID) References Grade ( RecID ),
Constraint FK_StaffNationality FOREIGN KEY (NationalityID) References
Nationality ( RecID ),
Constraint FK_Staffbirth_inCity FOREIGN KEY (City_birth_inID) References
City ( RecID ),
Constraint FK_Stafflives_inCity FOREIGN KEY (City_lives_inID) References
City ( RecID ),
Constraint FK_StaffMaritalStatus FOREIGN KEY (MaritalStatusID) References
MaritalStatus ( RecID ),
CONSTRAINT U_StaffU1 UNIQUE ( FamilyName, FirstName, SecondName,
LastPersonnellNo)
);

Alter Table StaffProfAssoc Add (
Constraint FK_StaffProfAssocProfession FOREIGN KEY (ProfessionID)
References Profession ( RecID ),
Constraint FK_StaffProfAssocStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table StaffQualAssoc Add (
Constraint FK_StaffQualAssocQ FOREIGN KEY (QualificacionID) References
Qualificacion ( RecID ),
Constraint FK_StaffQualAssocStaff FOREIGN KEY (StaffID) References Staff (
RecID ),
CONSTRAINT U_StaffQualAssocUL UNIQUE ( QualificacionID, StaffID)
);

Alter Table StaffTable Add (
Constraint FK_StaffTableLostTimeType FOREIGN KEY (LostTimeTypeID)
References LostTimeType ( RecID ),
Constraint FK_StaffTableStaff FOREIGN KEY (StaffID) References Staff (
RecID ),
Constraint FK_StaffTableTimeTable FOREIGN KEY (TimeTableID) References
TimeTable ( RecID ),
Constraint FK_StaffTableOutPutesItem FOREIGN KEY (OutPutesItemID)
References OutPutesItem ( RecID )
);

Alter Table Stock Add (
Constraint FK_StockStore FOREIGN KEY (StoreID) References Store ( RecID ),
Constraint FK_StockPart FOREIGN KEY (PartID) References Part ( RecID ),
Constraint FK_StockAccountPlan FOREIGN KEY (AccountPlanID) References
AccountPlan ( RecID ),
CONSTRAINT U_StockU1 UNIQUE ( CardNo)
);

Alter Table StockAttrAssoc Add (
Constraint FK_StockAttrAssocStock FOREIGN KEY (StockID) References Stock (
RecID ),
Constraint FK_StockAttrAssocPA FOREIGN KEY (PartAttributeID) References
PartAttribute ( RecID )
);

Alter Table StockDocItem Add (
Constraint FK_StockDocItemStock FOREIGN KEY (StockID) References Stock (
RecID ),
Constraint FK_StockDocItemDocumentItem FOREIGN KEY (DocumentItemID)
References DocumentItem ( RecID )
);

Alter Table SuppPayAkkreditive Add (
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)
);

Скачали данный реферат: Косыгин, Jakusik, Makrina, Матрона, Pudin, Janushevskij, Елена.
Последние просмотренные рефераты на тему: 7 ответов, ресурсы реферат, дипломы бесплатно, анализ темы курсовой работы.



Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29

Поделитесь этой записью или добавьте в закладки