Create Table GroupProfession ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , GroupCode Varchar2(16) NULL , GroupName Varchar2(64) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_GroupProfession PRIMARY KEY ( RecID ));
Create Table InPersonnel ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , PersonStatusID Number(10, 0) 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_InPersonnel PRIMARY KEY ( RecID ));
Create Table InquiryOfferAssoc ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , RecID Number(10, 0) NOT NULL , SuppInquiryItemID Number(10, 0) NOT NULL , SupplierOfferItemID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_InquiryOfferAssoc PRIMARY KEY ( RecID ));
Create Table LostTime ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DirtyWorksID Number(10, 0) NOT NULL , LostTimeTypeID Number(10, 0) NOT NULL , ReasonLostTime Varchar2(64) NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_LostTime PRIMARY KEY ( RecID ));
Create Table LostTimeType ( Abbrev Varchar2(16) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , TypeName Varchar2(64) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_LostTimeType PRIMARY KEY ( RecID ));
Create Table Nationality ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , NationalCode Varchar2(16) NOT NULL , NationalFemale Varchar2(64) NULL , NationalMale Varchar2(64) NULL , NationalityName Varchar2(64) NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_Nationality PRIMARY KEY ( RecID ));
Create Table NonCategTarife ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , RecID Number(10, 0) NOT NULL , TarifeID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_NonCategTarife PRIMARY KEY ( RecID ));
Create Table NonCategTarifItem ( AddValue Number(18, 2) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , NonCategTarifeID Number(10, 0) NOT NULL , ProfessionID Number(10, 0) NOT NULL , RecID Number(10, 0) NOT NULL , TarifeItemID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_NonCategTarifItem PRIMARY KEY ( RecID ));
Create Table Orders ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , Descriptions Varchar2(256) NOT NULL , OrderDate date NOT NULL , OrderNumber Varchar2(16) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_Orders PRIMARY KEY ( RecID ));
Create Table OrderState ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , OStateName Varchar2(64) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_OrderState PRIMARY KEY ( RecID ));
Create Table OrderType ( Abbrev Varchar2(16) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , Description Varchar2(64) NULL , OTypeName Varchar2(64) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , freetransport Number(1) NULL , Constraint PK_OrderType PRIMARY KEY ( RecID ));
Create Table OtherTarife ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , RecID Number(10, 0) NOT NULL , TarifeID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_OtherTarife PRIMARY KEY ( RecID ));
Create Table OtherTarItem ( AddValue Number(18, 2) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , OtherTarifeID 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_OtherTarItem PRIMARY KEY ( RecID ));
Create Table OutPersonnel ( CreatedBy Varchar2(31) NULL , CreatedWhen date 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_OutPersonnel PRIMARY KEY ( RecID ));
Create Table Passes ( CountryID Number(10, 0) NOT NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DateTrip date 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_Passes PRIMARY KEY ( RecID ));
Create Table Passport ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DAdepartmentID Number(10, 0) NOT NULL , DateDistribution date NULL , DateValid date NULL , PassNumber Varchar2(64) NULL , PassTypeID Number(10, 0) NOT NULL , RecID Number(10, 0) NOT NULL , Serial Varchar2(16) NULL , StaffID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_Passport PRIMARY KEY ( RecID ));
Create Table PassType ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , PassTypeName Varchar2(64) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_PassType PRIMARY KEY ( RecID ));
Create Table Pensioner ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , OrdersID Number(10, 0) NOT NULL , PensionTypeID 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_Pensioner PRIMARY KEY ( RecID ));
Create Table PensionType ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , TypeName Varchar2(64) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_PensionType PRIMARY KEY ( RecID ));
Create Table Period ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , Date_Begin date NULL , Date_End date NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_Period PRIMARY KEY ( RecID ));
Create Table PeriodAssign ( CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DateBegin date NOT NULL , DateEnd date NOT NULL , DepartmentID Number(10, 0) NOT NULL , NoAssign Varchar2(16) NOT NULL , RecID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_PeriodAssign PRIMARY KEY ( RecID ));
Create Table Place ( Category Varchar2(64) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DateEnd date NULL , DateStart date NULL , DepartmentID Number(10, 0) NOT NULL , Description Varchar2(256) NULL , PlName Varchar2(256) NOT NULL , ProfessionID Number(10, 0) NOT NULL , Quantity Number(18, 1) NULL , QuantityFree Number(18, 1) NULL , RecID Number(10, 0) NOT NULL , Salary Number(18, 1) NULL , SalaryTypeID Number(10, 0) NOT NULL , TimeStamp Number(10, 0) NULL , TypeQuantityID Number(10, 0) NOT NULL , WrittenBy Varchar2(31) NULL , WrittenWhen date NULL , Constraint PK_Place PRIMARY KEY ( RecID ));
Create Table PlaceEmpAssoc ( AddresseeID Number(10, 0) NULL , CreatedBy Varchar2(31) NULL , CreatedWhen date NULL , DateEnd date NULL , DateStart date NULL , OrdersID Number(10, 0) NULL , 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 ));
Страницы: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13