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