Alter Table DepToShop Add (
Constraint FK_DepToShopDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table Equipment Add (
Constraint FK_EquipmentDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table MatIssueAux Add (
Constraint FK_MatIssueAuxDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table NCTIDepAssoc Add (
Constraint FK_NCTIDepAssocDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table NeedPlan Add (
Constraint FK_NeedPlanfromDepartment FOREIGN KEY (Department_fromID)
References Department ( RecID ),
Constraint FK_NeedPlantoDepartment FOREIGN KEY (Department_toID) References
Department ( RecID )
);

Alter Table OrderPlan Add (
Constraint FK_OrderPlanfromDepartment FOREIGN KEY (Department_fromID)
References Department ( RecID ),
Constraint FK_OrderPlantoDepartment FOREIGN KEY (Department_toID)
References Department ( RecID )
);

Alter Table OrgStructure Add (
Constraint FK_OrgStructureis_subD FOREIGN KEY (Department_is_subID)
References Department ( RecID ),
Constraint FK_OrgStructureis_superD FOREIGN KEY (Department_is_superID)
References Department ( RecID )
);

Alter Table Part Add (
Constraint FK_PartDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table PartTechOper Add (
Constraint FK_PartTechOperDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table PartTechProc Add (
Constraint FK_PartTechProcDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table Perpetrators Add (
Constraint FK_PerpetratorsDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table ProdRecDept Add (
Constraint FK_ProdRecDeptDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table ProductionPlan Add (
Constraint FK_ProductionPlanfromD FOREIGN KEY (Department_fromID)
References Department ( RecID ),
Constraint FK_ProductionPlantoD FOREIGN KEY (Department_toID) References
Department ( RecID )
);

Alter Table RemainsInShop Add (
Constraint FK_RemainsInShopDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table SelfCostItem Add (
Constraint FK_SelfCostItemDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table ShopToDep Add (
Constraint FK_ShopToDepDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table Store Add (
Constraint FK_StoreDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table TimeTable Add (
Constraint FK_TimeTableDepartment FOREIGN KEY (DepartmentID) References
Department ( RecID )
);

Alter Table CustomerContract Add (
Constraint FK_CustomerContractsignsE FOREIGN KEY (Employee_signsID)
References Employee ( RecID ),
Constraint FK_CustomerContractworks_onE FOREIGN KEY (Employee_works_onID)
References Employee ( RecID )
);

Alter Table SupplierContract Add (
Constraint FK_SupplierContractsignsE FOREIGN KEY (Employee_signsID)
References Employee ( RecID ),
Constraint FK_SupplierContractworks_onE FOREIGN KEY (Employee_works_onID)
References Employee ( RecID )
);

Alter Table NCTIDepAssoc Add (
Constraint FK_NCTIDepAssocNCTI FOREIGN KEY (NonCategTarifItemID) References
NonCategTarifItem ( RecID )
);

Alter Table Maternity Add (
Constraint FK_MaternityOrders FOREIGN KEY (OrdersID) References Orders (
RecID )
);

Alter Table CustomerContract Add (
Constraint FK_CustomerContractOS FOREIGN KEY (OrderStateID) References
OrderState ( RecID )
);

Alter Table OrderPlanItem Add (
Constraint FK_OrderPlanItemOrderState FOREIGN KEY (OrderStateID) References
OrderState ( RecID )
);

Alter Table ConditionsOfOType Add (
Constraint FK_ConditionsOfOTypeOT FOREIGN KEY (OrderTypeID) References
OrderType ( RecID )
);

Alter Table CustomerContract Add (
Constraint FK_CustomerContractOT FOREIGN KEY (OrderTypeID) References
OrderType ( RecID )
);

Alter Table AkzisItem Add (
Constraint FK_AkzisItemPeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table CCostItem Add (
Constraint FK_CCostItemPeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table CompItem Add (
Constraint FK_CompItemPeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table Estimate Add (
Constraint FK_EstimatePeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table NeedPlanItem Add (
Constraint FK_NeedPlanItemPeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table OrderPlanItem Add (
Constraint FK_OrderPlanItemPeriod FOREIGN KEY (PeriodID) References Period
( RecID )
);

Alter Table ProductionPlan Add (
Constraint FK_PPPlanningPeriodP FOREIGN KEY (Period_PlanningPeriodID)
References Period ( RecID )
);

Alter Table Summary Add (
Constraint FK_SummaryPeriod FOREIGN KEY (PeriodID) References Period (
RecID )
);

Alter Table PartAssign Add (
Constraint FK_PartAssignPeriodAssign FOREIGN KEY (PeriodAssignID)
References PeriodAssign ( RecID )
);

Alter Table Contract Add (
Constraint FK_ContractPlaceEmpAssoc FOREIGN KEY (PlaceEmpAssocID)
References PlaceEmpAssoc ( RecID )
);

Alter Table Rubber Add (
Constraint FK_RubberReasonOfCreate FOREIGN KEY (ReasonOfCreateID)
References ReasonOfCreate ( RecID )
);

Alter Table RubberGlue Add (
Constraint FK_RubberGlueReasonOfCreate FOREIGN KEY (ReasonOfCreateID)
References ReasonOfCreate ( RecID )
);

Alter Table RubberImpregnant Add (
Constraint FK_RubberImpregnantROC FOREIGN KEY (ReasonOfCreateID) References
ReasonOfCreate ( RecID )
);

Alter Table RubberLubricant Add (
Constraint FK_RubberLubricantROC FOREIGN KEY (ReasonOfCreateID) References
ReasonOfCreate ( RecID )
);

Alter Table CustomerContract Add (
Constraint FK_CustomerContractsignsS FOREIGN KEY (Staff_signsID) References
Staff ( RecID ),
Constraint FK_CustomerContractworks_onS FOREIGN KEY (Staff_works_onID)
References Staff ( RecID )
);

Alter Table CustomerOffer Add (
Constraint FK_CustomerOfferStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table Document Add (
Constraint FK_DocumentInStaff FOREIGN KEY (Staff_InID) References Staff (
RecID ),
Constraint FK_DocumentOutStaff FOREIGN KEY (Staff_OutID) References Staff (
RecID ),
Constraint FK_DocumentOwnerStaff FOREIGN KEY (Staff_OwnerID) References
Staff ( RecID )
);

Alter Table Maternity Add (
Constraint FK_MaternityStaff FOREIGN KEY (StaffID) References Staff ( RecID
)

);

Alter Table NationalAssoc Add (
Constraint FK_NationalAssocStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table OutPutesItem Add (
Constraint FK_OutPutesItemStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table Perpetrators Add (
Constraint FK_PerpetratorsStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table PersonalCard Add (
Constraint FK_PersonalCardStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table PrivateAccount Add (
Constraint FK_PrivateAccountStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table StandingIdle Add (
Constraint FK_StandingIdleStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table SupplierContract Add (
Constraint FK_SupplierContractsignsS FOREIGN KEY (Staff_signsID) References
Staff ( RecID ),
Constraint FK_SupplierContractworks_onS FOREIGN KEY (Staff_works_onID)
References Staff ( RecID )
);

Alter Table SupplierInvoice Add (
Constraint FK_SupplierInvoiceStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table TimeTable Add (
Constraint FK_TimeTableStaff FOREIGN KEY (StaffID) References Staff ( RecID
)
);

Alter Table TransferOrder Add (
Constraint FK_TransferOrderStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table TripCurrency Add (
Constraint FK_TripCurrencyStaff FOREIGN KEY (StaffID) References Staff (
RecID )
);

Alter Table RemainsInShop Add (
Constraint FK_RemainsInShopStock FOREIGN KEY (StockID) References Stock (
RecID )
);

Alter Table Reservation Add (
Constraint FK_ReservationStock FOREIGN KEY (StockID) References Stock (
RecID )
);

Alter Table Addressee Add (
Constraint FK_AddresseeCity FOREIGN KEY (CityID) References City ( RecID ),

CONSTRAINT U_AddresseeU1 UNIQUE ( AddrName, CityID)
);

Alter Table Asessment Add (
Constraint FK_AsessmentStaff FOREIGN KEY (StaffID) References Staff ( RecID
)
);

Alter Table Assignment Add (
Constraint FK_AssignmentPart FOREIGN KEY (PartID) References Part ( RecID
),
Constraint FK_AssignmentrecipientTT FOREIGN KEY (TimeTable_recipID)
References TimeTable ( RecID ),
Constraint FK_AssignmentTimeTable FOREIGN KEY (TimeTableID) References
TimeTable ( RecID ),
Constraint FK_AssignmentPlanAssignItem FOREIGN KEY (PlanAssignItemID)
References PlanAssignItem ( RecID )
);

Alter Table CategTarife Add (
Constraint FK_CategTarifeTarife FOREIGN KEY (TarifeID) References Tarife (
RecID )
);

Alter Table CategTarifeLinks Add (
Constraint FK_CategTarifeLinksGP FOREIGN KEY (GroupProffesionID) References
GroupProfession ( RecID ),
Constraint FK_CategTarifeLinksCT FOREIGN KEY (CategTarifeID) References
CategTarife ( RecID )
);

Alter Table CategTarifItem Add (
Constraint FK_CategTarifItemTarifeItem FOREIGN KEY (TarifeItemID)
References TarifeItem ( RecID ),
Constraint FK_CategTarifItemCT FOREIGN KEY (CategTarifeID) References
CategTarife ( RecID )
);

Alter Table CContractItem Add (
Constraint FK_CContractItemCC FOREIGN KEY (CustomerContractID) References
CustomerContract ( RecID ) ON DELETE CASCADE ,
Constraint FK_CContractItemPriceType FOREIGN KEY (PriceTypeID) References
PriceType ( RecID ),
Constraint FK_CContractItemProduct FOREIGN KEY (ProductID) References
Product ( RecID ),
Constraint FK_CContractItemDT FOREIGN KEY (DeliveryTypeID) References
DeliveryType ( RecID ),
CONSTRAINT U_CContractItemU1 UNIQUE ( ItemNo, CustomerContractID)
);

Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13