Разработка программно-методического комплекса, предназначенного для хранения обработки и анализа информации о персонале БШК «Белшина»

PersonnelNo Varchar2(16) NULL ,

PlaceID Number(10, 0) NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WorkingPlace Varchar2(256) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

combinationwork Number(1) NULL ,

Constraint PK_PlaceEmpAssoc PRIMARY KEY ( RecID ));

 

Create Table Profession (

Classificator Varchar2(64) NULL ,

 

Code Varchar2(16) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

GroupProfessionID Number(10, 0) NOT NULL ,

InGroup Varchar2(16) NULL ,

ProfName Varchar2(256) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Profession PRIMARY KEY ( RecID ));

 

Create Table Qualificacion (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Description Varchar2(256) NULL ,

QualName Varchar2(64) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Qualificacion PRIMARY KEY ( RecID ));

 

Create Table QueueOfApartmentReceiver (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DataOfQueueStan date NULL ,

DissDataOfQueue date NULL ,

NumberInQueue Varchar2(16) NULL ,

NumberOfApplica Varchar2(16) NULL ,

NumberOfManInFa Number(18, 1) NULL ,

ReasonDissQueueID Number(10, 0) NULL ,

RecID Number(10, 0) NOT NULL ,

Staff_queueingID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_QueueOfApartmentReceiver PRIMARY KEY ( RecID ));

 

Create Table ReasonDissQueue (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

ReasonName Varchar2(64) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_ReasonDissQueue PRIMARY KEY ( RecID ));

 

Create Table ReasonOfCreate (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

ReasonCode Varchar2(16) NULL ,

ReasonName Varchar2(64) NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_ReasonOfCreate PRIMARY KEY ( RecID ));

 

Create Table SalaryType (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

SalaryTypeName Varchar2(64) NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_SalaryType PRIMARY KEY ( RecID ));

 

Create Table Staff (

AdditionalTelNumbers Varchar2(64) NULL ,

City_birth_inID Number(10, 0) NULL ,

City_lives_inID Number(10, 0) NOT NULL ,

Comments Varchar2(256) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DateBeginNormalWork date NULL ,

DateBeginWork date NULL ,

DateBirth date NULL ,

DateHired date NULL ,

EMail Varchar2(64) NULL ,

FamilyName Varchar2(64) NULL ,

Fax Varchar2(64) NULL ,

FirstName Varchar2(64) NULL ,

GradeID Number(10, 0) NOT NULL ,

HomeAddress Varchar2(256) NULL ,

LastPersonnellNo Varchar2(16) NULL ,

Location Varchar2(64) NULL ,

MaritalStatusID Number(10, 0) NOT NULL ,

NationalityID Number(10, 0) NOT NULL ,

NoChildren Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

ScienceDegree Varchar2(64) NULL ,

SecondName Varchar2(64) NULL ,

Sex Varchar2(16) NULL ,

Telephone Varchar2(64) NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Staff PRIMARY KEY ( RecID ));

 

Create Table StaffProfAssoc (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

ProfGrade Varchar2(16) NULL ,

ProfessionID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StaffProfAssoc PRIMARY KEY ( RecID ));

 

Create Table StaffQualAssoc (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Grade Varchar2(64) NULL ,

QualificacionID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StaffQualAssoc PRIMARY KEY ( RecID ));

 

Create Table StaffTable (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

LostTimeTypeID Number(10, 0) NULL ,

OutPutesItemID Number(10, 0) NULL ,

QtyHour Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

TimeTableID Number(10, 0) NOT NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StaffTable PRIMARY KEY ( RecID ));

 

Create Table StatusGrade (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

StatusName Varchar2(64) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StatusGrade PRIMARY KEY ( RecID ));

 

Create Table Stock (

AccountPlanID Number(10, 0) NULL ,

CardNo Varchar2(16) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

PartID Number(10, 0) NOT NULL ,

Price Number(18, 2) NULL ,

Qty Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

StoreID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Stock PRIMARY KEY ( RecID ));

 

Create Table StockAttrAssoc (

AttrValue  Number(20, 10) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

PartAttributeID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

StockID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StockAttrAssoc PRIMARY KEY ( RecID ));

 

Create Table StockDocItem (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DocumentItemID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

StockID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_StockDocItem PRIMARY KEY ( RecID ));

 

Create Table SuppPayAkkreditive (

AkkreditiveID Number(10, 0) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

SuppPaymentID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_SuppPayAkkreditive PRIMARY KEY ( RecID ));

 

Create Table SuppPayBooking (

BookkeepDocID Number(10, 0) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

SuppPaymentID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_SuppPayBooking PRIMARY KEY ( RecID ));

 

Create Table Tarife (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DateBegin date NULL ,

DateEnd date NULL ,

Discriminator Varchar2(32) NULL ,

GroundSalValue Number(18, 2) NOT NULL ,

OrdersID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TarifeName Varchar2(64) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Tarife PRIMARY KEY ( RecID ));

 

CREATE TABLE O_Tarife (

TarifeID Number(10, 0) NOT NULL UNIQUE);

 

Create Table TarifeItem (

AdditCaeff Number(20, 10) NULL ,

Caefficient Number(20, 10) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Discriminator Varchar2(32) NULL ,

RecID Number(10, 0) NOT NULL ,

 

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_TarifeItem PRIMARY KEY ( RecID ));

 

CREATE TABLE O_TarifeItem (

TarifeItemID Number(10, 0) NOT NULL UNIQUE);

 

Create Table WorkersChild (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

Staff_he_fatherID Number(10, 0) NOT NULL ,

Staff_he_motherID Number(10, 0) NOT NULL ,

Staff_isID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_WorkersChild PRIMARY KEY ( RecID ));

 

 

Alter Table Akkreditive Add (

Constraint FK_AkkreditiveAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Bank Add (

Constraint FK_BankAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Carrier Add (

Constraint FK_CarrierAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CompanyAccount Add (

Constraint FK_CompanyAccountAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CreditContract Add (

Constraint FK_CreditContractAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Customer Add (

Constraint FK_CustomerAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table HSGradeShool Add (

Constraint FK_HSGradeShoolAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table OtherAddr Add (

Constraint FK_OtherAddrAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Payer Add (

Constraint FK_PayerAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Recipient Add (

Constraint FK_RecipientAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Supplier Add (

Constraint FK_SupplierAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Wechsel Add (

Constraint FK_WechselAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CTIDepartmentAssoc Add (

Constraint FK_CTIDepartmentAssocCTL FOREIGN KEY (CategTarifeLinksID) References CategTarifeLinks ( RecID )

);

 

Alter Table COfferContrAssoc Add (

Constraint FK_COfferContrAssocCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table CustomerDelivery Add (

Constraint FK_CustomerDeliveryCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table ProdReservation Add (

Constraint FK_ProdReservationCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table Akzis Add (

Constraint FK_AkzisCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table CoeffRef Add (

Constraint FK_CoeffRefCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table CommonCost Add (

Constraint FK_CommonCostCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table SelfCost Add (

Constraint FK_SelfCostCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table District Add (

Constraint FK_DistrictCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table NationalAssoc Add (

Constraint FK_NationalAssocCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table OfficialTrip Add (

Constraint FK_OfficialTripCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table Document Add (

Constraint FK_DocumentDateWork FOREIGN KEY (DateWorkID) References DateWork ( RecID )

);

 

Alter Table TimeTable Add (

Constraint FK_TimeTableDateWork FOREIGN KEY (DateWorkID) References DateWork ( RecID )

);

 

Alter Table BasisEquipment Add (

Constraint FK_BasisEquipmentDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table CTIDepartmentAssoc Add (

Constraint FK_CTIDepartmentAssocD FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

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