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

Create Table ReasonDissQueue (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

ReasonName Varchar2(64) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_ReasonDissQueue PRIMARY KEY ( RecID ));

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 ,