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 ,