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 ),