CreatedWhen date NULL ,

CurrencyID Number(10, 0) NOT NULL ,

National Varchar2(64) NULL ,

RecID Number(10, 0) NOT NULL ,

Telephone Varchar2(16) NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Country PRIMARY KEY ( RecID ));

Create Table Covering (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

NeedPlanItemID Number(10, 0) NOT NULL ,

Quantity Number(18, 1) 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_Covering PRIMARY KEY ( RecID ));

Create Table DAdepartment (

AddresseeID Number(10, 0) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_DAdepartment PRIMARY KEY ( RecID ));

Create Table DateWork (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

Staff_1ID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WorkDate date NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_DateWork PRIMARY KEY ( RecID ));

Create Table Department (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DateEnd date NULL ,

DateStart date NULL ,

DepCode Varchar2(16) NULL ,

DepName Varchar2(256) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

isnp Number(1) NOT NULL ,

Constraint PK_Department PRIMARY KEY ( RecID ));

Create Table Diploma (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DateDistribution date NULL ,

DateEnd date NULL ,

DipNumber Varchar2(16) NULL ,

HSGradeShoolID Number(10, 0) NOT NULL ,

ProffessionName Varchar2(256) NULL ,

QualificationName Varchar2(256) NULL ,

RecID Number(10, 0) NOT NULL ,

StaffID Number(10, 0) NOT NULL ,

StatusGradeID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Diploma PRIMARY KEY ( RecID ));

Create Table DirtyType (

CodeDirty Varchar2(16) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Description Varchar2(256) NULL ,

NameDirty Varchar2(64) NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_DirtyType PRIMARY KEY ( RecID ));

Create Table DirtyWorks (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DirtyTypeID Number(10, 0) NOT NULL ,

OrdersID Number(10, 0) NOT NULL ,

PlaceEmpAssocID Number(10, 0) NOT NULL ,

QuantityDay Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

TimePeriod Varchar2(64) NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_DirtyWorks PRIMARY KEY ( RecID ));

Create Table Dissmissed (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DismissDate date NULL ,

DissmissReasonID Number(10, 0) NOT NULL ,

OrdersID 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_Dissmissed PRIMARY KEY ( RecID ));

Create Table DissmissReason (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

LawArticle Varchar2(64) 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_DissmissReason PRIMARY KEY ( RecID ));

Create Table Employee (

AdditionalTelNumbers Varchar2(16) NULL ,

AddresseeID Number(10, 0) NOT NULL ,

Comments Varchar2(256) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

EMail Varchar2(64) NULL ,

EmpPosition Varchar2(64) NULL ,

FamilyName Varchar2(64) NOT NULL ,

Fax Varchar2(16) NULL ,

FirstName Varchar2(64) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

SecondName Varchar2(64) NOT NULL ,

Telephone Varchar2(16) NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Employee PRIMARY KEY ( RecID ));

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 (