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 ) );
Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13