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