Главная | Обратная связь
МегаЛекции

СПИСОК ИСПОЛЬЗОВАННЫХ ИСТОЧНИКОВ





 

1. Атре Ш., Структурный подход к организации баз данных. – М.: Финансы и статистика, 1983. – 317 с.

2. Бобровски Ст., Oracle7 и вычисления клиент/сервер. – Alameda, CA, USA: SYBEX Inc., 1996. – 420с.

3. Ричардс Майкл и др. Oracle 7.3. Энциклопедия пользователя: Пер. с англ./Ричардс Майкл и др. – К.: Издательство «ДиаСофт», 1997. – 832с.

4. Сервер Oracle7ä. Основные концепции. – Belmont, CA, USA: Oracle Corporation, 1994. – 640с.

5. Сервер Oracle7ä. Сервер. Справочное руководство по языку SQL. – Belmont, CA, USA: Oracle Corporation, 1994. – 528с.

6. Сервер Oracle7ä. Сообщения и коды ошибок. – Belmont, CA, USA: Oracle Corporation, 1994. – 528с.

7. Методические указания по технико-экономическому обоснованию дипломных проектов. / Сост. Елецких Т.В., Афитов Э.А., Палицын В.А., Феденя А.К. -Мн.: БГУИР, 1996. - 123с.

8. Методические указания по дипломному проектированию для студентов специальности “Автоматизированные системы обработки информации”. / Сост. Птичкин В.А., Никульшин Б.В. -Мн.: БГУИР, 1997. - 33с.

9. ”Инженерные расчёты по защите от шума.” Методическое пособие по курсу Охрана труда» для студентов всех специальностей. - МРТИ, 1988.1 


ПРИЛОЖЕНИЕ

ЛИСТИНГ ПРОГРАММЫ

Create Table Addressee (

AdditionalTelNumbers Varchar2(16) NULL ,

AddrName Varchar2(256) NOT NULL ,

Address Varchar2(256) NULL ,

CityID Number(10, 0) NOT NULL ,

Code Varchar2(16) NULL ,

Comments Varchar2(256) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

EMail Varchar2(64) NULL ,

Fax Varchar2(16) NULL ,

NameAbbrev Varchar2(16) NULL ,

POBox Varchar2(64) NULL ,

RecID Number(10, 0) NOT NULL ,

Telephone Varchar2(16) NULL ,

Teletype Varchar2(64) NULL ,

TimeStamp Number(10, 0) NULL ,

WWW Varchar2(64) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

ZIPCode Varchar2(16) NULL ,

ZIPPOBox Varchar2(64) NULL ,

Constraint PK_Addressee PRIMARY KEY ( RecID ));

 

Create Table Asessment (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DateAmnt date NULL ,

DateNextAmnt date NULL ,

Grade Varchar2(64) NULL ,

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

 

Create Table Assignment (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

PartID Number(10, 0) NOT NULL ,

PlanAssignItemID Number(10, 0) NULL ,

Quantity Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

TimeTableID Number(10, 0) NOT NULL ,

TimeTable_recipID Number(10, 0) NOT NULL ,



WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Assignment PRIMARY KEY ( RecID ));

 

Create Table CategTarife (

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

 

Create Table CategTarifeLinks (

CategTarifeID Number(10, 0) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

GroupProffesionID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_CategTarifeLinks PRIMARY KEY ( RecID ));

 

Create Table CategTarifItem (

AddValue Number(18, 2) NULL ,

CategTarifeID Number(10, 0) NOT NULL ,

Category Varchar2(16) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date 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_CategTarifItem PRIMARY KEY ( RecID ));

 

Create Table CContractItem (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

CustomerContractID Number(10, 0) NOT NULL ,

DeliveryDate date NULL ,

DeliveryTypeID Number(10, 0) NOT NULL ,

ItemNo Varchar2(16) NULL ,

Price Number(18, 2) NULL ,

PriceTypeID Number(10, 0) NOT NULL ,

ProductID Number(10, 0) NOT NULL ,

Quantity Number(18, 1) NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_CContractItem PRIMARY KEY ( RecID ));

 

Create Table City (

CName Varchar2(64) NOT NULL ,

CityType Varchar2(64) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

DefaultZIPCode Varchar2(16) NULL ,

DistrictID Number(10, 0) NOT 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_City PRIMARY KEY ( RecID ));

 

Create Table Coefficient (

ComputationID Number(10, 0) NOT NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Discriminator Varchar2(32) NULL ,

RecID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Coefficient PRIMARY KEY ( RecID ));

 

CREATE TABLE O_Coefficient (

CoefficientID Number(10, 0) NOT NULL UNIQUE);

 

Create Table Country (

Abbrev Varchar2(64) NOT NULL ,

CntrName Varchar2(64) NULL ,

CreatedBy Varchar2(31) NULL ,

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 (

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 ,

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 ,

GroundSalValue Number(18, 2) NOT NULL ,

OrdersID Number(10, 0) NOT NULL ,

RecID Number(10, 0) NOT NULL ,

TarifeName Varchar2(64) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_Tarife PRIMARY KEY ( RecID ));

 

CREATE TABLE O_Tarife (

TarifeID Number(10, 0) NOT NULL UNIQUE);

 

Create Table TarifeItem (

AdditCaeff Number(20, 10) NULL ,

Caefficient Number(20, 10) NULL ,

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

Discriminator Varchar2(32) NULL ,

RecID Number(10, 0) NOT NULL ,

 

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_TarifeItem PRIMARY KEY ( RecID ));

 

CREATE TABLE O_TarifeItem (

TarifeItemID Number(10, 0) NOT NULL UNIQUE);

 

Create Table WorkersChild (

CreatedBy Varchar2(31) NULL ,

CreatedWhen date NULL ,

RecID Number(10, 0) NOT NULL ,

Staff_he_fatherID Number(10, 0) NOT NULL ,

Staff_he_motherID Number(10, 0) NOT NULL ,

Staff_isID Number(10, 0) NOT NULL ,

TimeStamp Number(10, 0) NULL ,

WrittenBy Varchar2(31) NULL ,

WrittenWhen date NULL ,

Constraint PK_WorkersChild PRIMARY KEY ( RecID ));

 

 

Alter Table Akkreditive Add (

Constraint FK_AkkreditiveAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Bank Add (

Constraint FK_BankAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Carrier Add (

Constraint FK_CarrierAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CompanyAccount Add (

Constraint FK_CompanyAccountAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CreditContract Add (

Constraint FK_CreditContractAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Customer Add (

Constraint FK_CustomerAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table HSGradeShool Add (

Constraint FK_HSGradeShoolAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table OtherAddr Add (

Constraint FK_OtherAddrAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Payer Add (

Constraint FK_PayerAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Recipient Add (

Constraint FK_RecipientAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Supplier Add (

Constraint FK_SupplierAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table Wechsel Add (

Constraint FK_WechselAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID )

);

 

Alter Table CTIDepartmentAssoc Add (

Constraint FK_CTIDepartmentAssocCTL FOREIGN KEY (CategTarifeLinksID) References CategTarifeLinks ( RecID )

);

 

Alter Table COfferContrAssoc Add (

Constraint FK_COfferContrAssocCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table CustomerDelivery Add (

Constraint FK_CustomerDeliveryCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table ProdReservation Add (

Constraint FK_ProdReservationCCI FOREIGN KEY (CContractItemID) References CContractItem ( RecID )

);

 

Alter Table Akzis Add (

Constraint FK_AkzisCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table CoeffRef Add (

Constraint FK_CoeffRefCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table CommonCost Add (

Constraint FK_CommonCostCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table SelfCost Add (

Constraint FK_SelfCostCoefficient FOREIGN KEY (CoefficientID) References Coefficient ( RecID )

);

 

Alter Table District Add (

Constraint FK_DistrictCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table NationalAssoc Add (

Constraint FK_NationalAssocCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table OfficialTrip Add (

Constraint FK_OfficialTripCountry FOREIGN KEY (CountryID) References Country ( RecID )

);

 

Alter Table Document Add (

Constraint FK_DocumentDateWork FOREIGN KEY (DateWorkID) References DateWork ( RecID )

);

 

Alter Table TimeTable Add (

Constraint FK_TimeTableDateWork FOREIGN KEY (DateWorkID) References DateWork ( RecID )

);

 

Alter Table BasisEquipment Add (

Constraint FK_BasisEquipmentDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table CTIDepartmentAssoc Add (

Constraint FK_CTIDepartmentAssocD FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table DepToShop Add (

Constraint FK_DepToShopDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table Equipment Add (

Constraint FK_EquipmentDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table MatIssueAux Add (

Constraint FK_MatIssueAuxDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table NCTIDepAssoc Add (

Constraint FK_NCTIDepAssocDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table NeedPlan Add (

Constraint FK_NeedPlanfromDepartment FOREIGN KEY (Department_fromID) References Department ( RecID ),

Constraint FK_NeedPlantoDepartment FOREIGN KEY (Department_toID) References Department ( RecID )

);

 

Alter Table OrderPlan Add (

Constraint FK_OrderPlanfromDepartment FOREIGN KEY (Department_fromID) References Department ( RecID ),

Constraint FK_OrderPlantoDepartment FOREIGN KEY (Department_toID) References Department ( RecID )

);

 

Alter Table OrgStructure Add (

Constraint FK_OrgStructureis_subD FOREIGN KEY (Department_is_subID) References Department ( RecID ),

Constraint FK_OrgStructureis_superD FOREIGN KEY (Department_is_superID) References Department ( RecID )

);

 

Alter Table Part Add (

Constraint FK_PartDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table PartTechOper Add (

Constraint FK_PartTechOperDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table PartTechProc Add (

Constraint FK_PartTechProcDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table Perpetrators Add (

Constraint FK_PerpetratorsDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table ProdRecDept Add (

Constraint FK_ProdRecDeptDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table ProductionPlan Add (

Constraint FK_ProductionPlanfromD FOREIGN KEY (Department_fromID) References Department ( RecID ),

Constraint FK_ProductionPlantoD FOREIGN KEY (Department_toID) References Department ( RecID )

);

 

Alter Table RemainsInShop Add (

Constraint FK_RemainsInShopDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table SelfCostItem Add (

Constraint FK_SelfCostItemDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table ShopToDep Add (

Constraint FK_ShopToDepDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table Store Add (

Constraint FK_StoreDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table TimeTable Add (

Constraint FK_TimeTableDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table CustomerContract Add (

Constraint FK_CustomerContractsignsE FOREIGN KEY (Employee_signsID) References Employee ( RecID ),

Constraint FK_CustomerContractworks_onE FOREIGN KEY (Employee_works_onID) References Employee ( RecID )

);

 

Alter Table SupplierContract Add (

Constraint FK_SupplierContractsignsE FOREIGN KEY (Employee_signsID) References Employee ( RecID ),

Constraint FK_SupplierContractworks_onE FOREIGN KEY (Employee_works_onID) References Employee ( RecID )

);

 

Alter Table NCTIDepAssoc Add (

Constraint FK_NCTIDepAssocNCTI FOREIGN KEY (NonCategTarifItemID) References NonCategTarifItem ( RecID )

);

 

Alter Table Maternity Add (

Constraint FK_MaternityOrders FOREIGN KEY (OrdersID) References Orders ( RecID )

);

 

Alter Table CustomerContract Add (

Constraint FK_CustomerContractOS FOREIGN KEY (OrderStateID) References OrderState ( RecID )

);

 

Alter Table OrderPlanItem Add (

Constraint FK_OrderPlanItemOrderState FOREIGN KEY (OrderStateID) References OrderState ( RecID )

);

 

Alter Table ConditionsOfOType Add (

Constraint FK_ConditionsOfOTypeOT FOREIGN KEY (OrderTypeID) References OrderType ( RecID )

);

 

Alter Table CustomerContract Add (

Constraint FK_CustomerContractOT FOREIGN KEY (OrderTypeID) References OrderType ( RecID )

);

 

Alter Table AkzisItem Add (

Constraint FK_AkzisItemPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table CCostItem Add (

Constraint FK_CCostItemPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table CompItem Add (

Constraint FK_CompItemPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table Estimate Add (

Constraint FK_EstimatePeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table NeedPlanItem Add (

Constraint FK_NeedPlanItemPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table OrderPlanItem Add (

Constraint FK_OrderPlanItemPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table ProductionPlan Add (

Constraint FK_PPPlanningPeriodP FOREIGN KEY (Period_PlanningPeriodID) References Period ( RecID )

);

 

Alter Table Summary Add (

Constraint FK_SummaryPeriod FOREIGN KEY (PeriodID) References Period ( RecID )

);

 

Alter Table PartAssign Add (

Constraint FK_PartAssignPeriodAssign FOREIGN KEY (PeriodAssignID) References PeriodAssign ( RecID )

);

 

Alter Table Contract Add (

Constraint FK_ContractPlaceEmpAssoc FOREIGN KEY (PlaceEmpAssocID) References PlaceEmpAssoc ( RecID )

);

 

Alter Table Rubber Add (

Constraint FK_RubberReasonOfCreate FOREIGN KEY (ReasonOfCreateID) References ReasonOfCreate ( RecID )

);

 

Alter Table RubberGlue Add (

Constraint FK_RubberGlueReasonOfCreate FOREIGN KEY (ReasonOfCreateID) References ReasonOfCreate ( RecID )

);

 

Alter Table RubberImpregnant Add (

Constraint FK_RubberImpregnantROC FOREIGN KEY (ReasonOfCreateID) References ReasonOfCreate ( RecID )

);

 

Alter Table RubberLubricant Add (

Constraint FK_RubberLubricantROC FOREIGN KEY (ReasonOfCreateID) References ReasonOfCreate ( RecID )

);

 

Alter Table CustomerContract Add (

Constraint FK_CustomerContractsignsS FOREIGN KEY (Staff_signsID) References Staff ( RecID ),

Constraint FK_CustomerContractworks_onS FOREIGN KEY (Staff_works_onID) References Staff ( RecID )

);

 

Alter Table CustomerOffer Add (

Constraint FK_CustomerOfferStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table Document Add (

Constraint FK_DocumentInStaff FOREIGN KEY (Staff_InID) References Staff ( RecID ),

Constraint FK_DocumentOutStaff FOREIGN KEY (Staff_OutID) References Staff ( RecID ),

Constraint FK_DocumentOwnerStaff FOREIGN KEY (Staff_OwnerID) References Staff ( RecID )

);

 

Alter Table Maternity Add (

Constraint FK_MaternityStaff FOREIGN KEY (StaffID) References Staff ( RecID )

 

);

 

Alter Table NationalAssoc Add (

Constraint FK_NationalAssocStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table OutPutesItem Add (

Constraint FK_OutPutesItemStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table Perpetrators Add (

Constraint FK_PerpetratorsStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table PersonalCard Add (

Constraint FK_PersonalCardStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table PrivateAccount Add (

Constraint FK_PrivateAccountStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table StandingIdle Add (

Constraint FK_StandingIdleStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table SupplierContract Add (

Constraint FK_SupplierContractsignsS FOREIGN KEY (Staff_signsID) References Staff ( RecID ),

Constraint FK_SupplierContractworks_onS FOREIGN KEY (Staff_works_onID) References Staff ( RecID )

);

 

Alter Table SupplierInvoice Add (

Constraint FK_SupplierInvoiceStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table TimeTable Add (

Constraint FK_TimeTableStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table TransferOrder Add (

Constraint FK_TransferOrderStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table TripCurrency Add (

Constraint FK_TripCurrencyStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table RemainsInShop Add (

Constraint FK_RemainsInShopStock FOREIGN KEY (StockID) References Stock ( RecID )

);

 

Alter Table Reservation Add (

Constraint FK_ReservationStock FOREIGN KEY (StockID) References Stock ( RecID )

);

 

Alter Table Addressee Add (

Constraint FK_AddresseeCity FOREIGN KEY (CityID) References City ( RecID ),

CONSTRAINT U_AddresseeU1 UNIQUE ( AddrName, CityID)

);

 

Alter Table Asessment Add (

Constraint FK_AsessmentStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table Assignment Add (

Constraint FK_AssignmentPart FOREIGN KEY (PartID) References Part ( RecID ),

Constraint FK_AssignmentrecipientTT FOREIGN KEY (TimeTable_recipID) References TimeTable ( RecID ),

Constraint FK_AssignmentTimeTable FOREIGN KEY (TimeTableID) References TimeTable ( RecID ),

Constraint FK_AssignmentPlanAssignItem FOREIGN KEY (PlanAssignItemID) References PlanAssignItem ( RecID )

);

 

Alter Table CategTarife Add (

Constraint FK_CategTarifeTarife FOREIGN KEY (TarifeID) References Tarife ( RecID )

);

 

Alter Table CategTarifeLinks Add (

Constraint FK_CategTarifeLinksGP FOREIGN KEY (GroupProffesionID) References GroupProfession ( RecID ),

Constraint FK_CategTarifeLinksCT FOREIGN KEY (CategTarifeID) References CategTarife ( RecID )

);

 

Alter Table CategTarifItem Add (

Constraint FK_CategTarifItemTarifeItem FOREIGN KEY (TarifeItemID) References TarifeItem ( RecID ),

Constraint FK_CategTarifItemCT FOREIGN KEY (CategTarifeID) References CategTarife ( RecID )

);

 

Alter Table CContractItem Add (

Constraint FK_CContractItemCC FOREIGN KEY (CustomerContractID) References CustomerContract ( RecID ) ON DELETE CASCADE ,

Constraint FK_CContractItemPriceType FOREIGN KEY (PriceTypeID) References PriceType ( RecID ),

Constraint FK_CContractItemProduct FOREIGN KEY (ProductID) References Product ( RecID ),

Constraint FK_CContractItemDT FOREIGN KEY (DeliveryTypeID) References DeliveryType ( RecID ),

CONSTRAINT U_CContractItemU1 UNIQUE ( ItemNo, CustomerContractID)

);

 

Alter Table City Add (

Constraint FK_CityDistrict FOREIGN KEY (DistrictID) References District ( RecID ),

CONSTRAINT U_CityU1 UNIQUE ( CName, CityType, DistrictID)

);

 

Alter Table Coefficient Add (

Constraint FK_CoefficientComputation FOREIGN KEY (ComputationID) References Computation ( RecID )

);

 

Alter Table Country Add (

Constraint FK_CountryCurrency FOREIGN KEY (CurrencyID) References Currency ( RecID ),

CONSTRAINT U_CountryU1 UNIQUE ( Abbrev),

CONSTRAINT U_CountryCurrencyID UNIQUE ( CurrencyID)

);

 

Alter Table Covering Add (

Constraint FK_CoveringNeedPlanItem FOREIGN KEY (NeedPlanItemID) References NeedPlanItem ( RecID ),

Constraint FK_CoveringStock FOREIGN KEY (StockID) References Stock ( RecID ),

CONSTRAINT U_CoveringUL UNIQUE ( NeedPlanItemID, StockID)

);

 

Alter Table DAdepartment Add (

Constraint FK_DAdepartmentAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID ),

CONSTRAINT U_DAdepartmentAddresseeID UNIQUE ( )

);

 

Alter Table DateWork Add (

Constraint FK_DateWorkDispetcherStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_DateWorkOperatorStaff FOREIGN KEY (Staff_1ID) References Staff ( RecID ),

CONSTRAINT U_DateWorkU1 UNIQUE ( WorkDate)

);

 

Alter Table Department Add (

CONSTRAINT U_DepartmentU1 UNIQUE ( DepCode)

);

 

Alter Table Diploma Add (

Constraint FK_DiplomaStatusGrade FOREIGN KEY (StatusGradeID) References StatusGrade ( RecID ),

Constraint FK_DiplomaStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_DiplomaHSGradeShool FOREIGN KEY (HSGradeShoolID) References HSGradeShool ( RecID )

);

 

Alter Table DirtyWorks Add (

Constraint FK_DirtyWorksPlaceEmpAssoc FOREIGN KEY (PlaceEmpAssocID) References PlaceEmpAssoc ( RecID ),

Constraint FK_DirtyWorksDirtyType FOREIGN KEY (DirtyTypeID) References DirtyType ( RecID ),

Constraint FK_DirtyWorksOrders FOREIGN KEY (OrdersID) References Orders ( RecID )

);

 

Alter Table Dissmissed Add (

Constraint FK_DissmissedDissmissReason FOREIGN KEY (DissmissReasonID) References DissmissReason ( RecID ),

Constraint FK_DissmissedStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_DissmissedOrders FOREIGN KEY (OrdersID) References Orders ( RecID ),

CONSTRAINT U_DissmissedStaffID UNIQUE ( StaffID)

);

 

Alter Table Employee Add (

Constraint FK_EmployeeAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID ),

CONSTRAINT U_EmployeeU1 UNIQUE ( AddresseeID, FamilyName, FirstName, SecondName)

);

 

Alter Table GroupProfession Add (

CONSTRAINT U_GroupProfessionU1 UNIQUE ( GroupName)

);

 

Alter Table InPersonnel Add (

Constraint FK_InPersonnelStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_InPersonnelPersonStatus FOREIGN KEY (PersonStatusID) References PersonStatus ( RecID ),

CONSTRAINT U_InPersonnelStaffID UNIQUE ( StaffID)

);

 

Alter Table InquiryOfferAssoc Add (

Constraint FK_InquiryOfferAssocSII FOREIGN KEY (SuppInquiryItemID) References SuppInquiryItem ( RecID ),

Constraint FK_InquiryOfferAssocSOI FOREIGN KEY (SupplierOfferItemID) References SupplierOfferItem ( RecID ),

CONSTRAINT U_InquiryOfferAssocUL UNIQUE ( SuppInquiryItemID, SupplierOfferItemID)

);

 

Alter Table LostTime Add (

Constraint FK_LostTimeDirtyWorks FOREIGN KEY (DirtyWorksID) References DirtyWorks ( RecID ),

Constraint FK_LostTimeLostTimeType FOREIGN KEY (LostTimeTypeID) References LostTimeType ( RecID )

);

 

Alter Table Nationality Add (

CONSTRAINT U_NationalityU1 UNIQUE ( NationalCode)

);

 

Alter Table NonCategTarife Add (

Constraint FK_NonCategTarifeTarife FOREIGN KEY (TarifeID) References Tarife ( RecID )

);

 

Alter Table NonCategTarifItem Add (

Constraint FK_NonCategTarifItemP FOREIGN KEY (ProfessionID) References Profession ( RecID ),

Constraint FK_NonCategTarifItemTI FOREIGN KEY (TarifeItemID) References TarifeItem ( RecID ),

Constraint FK_NonCategTarifItemNCT FOREIGN KEY (NonCategTarifeID) References NonCategTarife ( RecID )

);

 

Alter Table Orders Add (

CONSTRAINT U_OrdersU1 UNIQUE ( OrderDate, OrderNumber)

);

 

Alter Table OrderType Add (

CONSTRAINT U_OrderTypeU1 UNIQUE ( Abbrev)

);

 

Alter Table OtherTarife Add (

Constraint FK_OtherTarifeTarife FOREIGN KEY (TarifeID) References Tarife ( RecID )

);

 

Alter Table OtherTarItem Add (

Constraint FK_OtherTarItemStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_OtherTarItemOtherTarife FOREIGN KEY (OtherTarifeID) References OtherTarife ( RecID )

);

 

Alter Table OutPersonnel Add (

Constraint FK_OutPersonnelStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

CONSTRAINT U_OutPersonnelStaffID UNIQUE ( StaffID)

);

 

Alter Table Passes Add (

Constraint FK_PassesCountry FOREIGN KEY (CountryID) References Country ( RecID ),

Constraint FK_PassesStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table Passport Add (

Constraint FK_PassportStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_PassportDAdepartment FOREIGN KEY (DAdepartmentID) References DAdepartment ( RecID ),

Constraint FK_PassportPassType FOREIGN KEY (PassTypeID) References PassType ( RecID )

);

 

 

Alter Table PassType Add (

CONSTRAINT U_PassTypeU1 UNIQUE ( PassTypeName)

);

 

Alter Table Pensioner Add (

Constraint FK_PensionerPensionType FOREIGN KEY (PensionTypeID) References PensionType ( RecID ),

Constraint FK_PensionerStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_PensionerOrders FOREIGN KEY (OrdersID) References Orders ( RecID ),

CONSTRAINT U_PensionerStaffID UNIQUE ( StaffID)

);

 

Alter Table PeriodAssign Add (

Constraint FK_PeriodAssignDepartment FOREIGN KEY (DepartmentID) References Department ( RecID )

);

 

Alter Table Place Add (

Constraint FK_PlaceProfession FOREIGN KEY (ProfessionID) References Profession ( RecID ),

Constraint FK_PlaceDepartment FOREIGN KEY (DepartmentID) References Department ( RecID ),

Constraint FK_PlaceTypeQuantity FOREIGN KEY (TypeQuantityID) References TypeQuantity ( RecID ),

Constraint FK_PlaceSalaryType FOREIGN KEY (SalaryTypeID) References SalaryType ( RecID )

);

 

Alter Table PlaceEmpAssoc Add (

Constraint FK_PlaceEmpAssocPlace FOREIGN KEY (PlaceID) References Place ( RecID ),

Constraint FK_PlaceEmpAssocAddressee FOREIGN KEY (AddresseeID) References Addressee ( RecID ),

Constraint FK_PlaceEmpAssocStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_PlaceEmpAssocOrders FOREIGN KEY (OrdersID) References Orders ( RecID ),

CONSTRAINT U_PlaceEmpAssocU1 UNIQUE ( DateStart, DateEnd, StaffID, PlaceID)

);

 

Alter Table Profession Add (

Constraint FK_ProfessionGP FOREIGN KEY (GroupProfessionID) References GroupProfession ( RecID ),

CONSTRAINT U_ProfessionU1 UNIQUE ( Code)

);

 

Alter Table QueueOfApartmentReceiver Add (

Constraint FK_QOARqueueingS FOREIGN KEY (Staff_queueingID) References Staff ( RecID ),

Constraint FK_QOARRDQ FOREIGN KEY (ReasonDissQueueID) References ReasonDissQueue ( RecID ),

CONSTRAINT U_QOARS_ID UNIQUE ( Staff_queueingID)

);

 

Alter Table Staff Add (

Constraint FK_StaffGrade FOREIGN KEY (GradeID) References Grade ( RecID ),

Constraint FK_StaffNationality FOREIGN KEY (NationalityID) References Nationality ( RecID ),

Constraint FK_Staffbirth_inCity FOREIGN KEY (City_birth_inID) References City ( RecID ),

Constraint FK_Stafflives_inCity FOREIGN KEY (City_lives_inID) References City ( RecID ),

Constraint FK_StaffMaritalStatus FOREIGN KEY (MaritalStatusID) References MaritalStatus ( RecID ),

CONSTRAINT U_StaffU1 UNIQUE ( FamilyName, FirstName, SecondName, LastPersonnellNo)

);

 

Alter Table StaffProfAssoc Add (

Constraint FK_StaffProfAssocProfession FOREIGN KEY (ProfessionID) References Profession ( RecID ),

Constraint FK_StaffProfAssocStaff FOREIGN KEY (StaffID) References Staff ( RecID )

);

 

Alter Table StaffQualAssoc Add (

Constraint FK_StaffQualAssocQ FOREIGN KEY (QualificacionID) References Qualificacion ( RecID ),

Constraint FK_StaffQualAssocStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

CONSTRAINT U_StaffQualAssocUL UNIQUE ( QualificacionID, StaffID)

);

 

Alter Table StaffTable Add (

Constraint FK_StaffTableLostTimeType FOREIGN KEY (LostTimeTypeID) References LostTimeType ( RecID ),

Constraint FK_StaffTableStaff FOREIGN KEY (StaffID) References Staff ( RecID ),

Constraint FK_StaffTableTimeTable FOREIGN KEY (TimeTableID) References TimeTable ( RecID ),

Constraint FK_StaffTableOutPutesItem FOREIGN KEY (OutPutesItemID) References OutPutesItem ( RecID )

);

 

Alter Table Stock Add (

Constraint FK_StockStore FOREIGN KEY (StoreID) References Store ( RecID ),

Constraint FK_StockPart FOREIGN KEY (PartID) References Part ( RecID ),

Constraint FK_StockAccountPlan FOREIGN KEY (AccountPlanID) References AccountPlan ( RecID ),

CONSTRAINT U_StockU1 UNIQUE ( CardNo)

);

 

Alter Table StockAttrAssoc Add (

Constraint FK_StockAttrAssocStock FOREIGN KEY (StockID) References Stock ( RecID ),

Constraint FK_StockAttrAssocPA FOREIGN KEY (PartAttributeID) References PartAttribute ( RecID )

);

 

Alter Table StockDocItem Add (

Constraint FK_StockDocItemStock FOREIGN KEY (StockID) References Stock ( RecID ),

Constraint FK_StockDocItemDocumentItem FOREIGN KEY (DocumentItemID) References DocumentItem ( RecID )

);

 

Alter Table SuppPayAkkreditive Add (

Constraint FK_SuppPayAkkreditiveA FOREIGN KEY (AkkreditiveID) References Akkreditive ( RecID ),

Constraint FK_SuppPayAkkreditiveSP FOREIGN KEY (SuppPaymentID) References SuppPayment ( RecID ),

CONSTRAINT U_SuppPayAkkreditiveSPID UNIQUE ( SuppPaymentID, AkkreditiveID)

);

 

Alter Table SuppPayBooking Add (

Constraint FK_SuppPayBookingSP FOREIGN KEY (SuppPaymentID) References SuppPayment ( RecID ),

Constraint FK_SuppPayBookingBD FOREIGN KEY (BookkeepDocID) References BookkeepDoc ( RecID ),

CONSTRAINT U_SuppPayBookingBDID UNIQUE ( BookkeepDocID, SuppPaymentID)

);

 

Alter Table Tarife Add (

Constraint FK_TarifeOrders FOREIGN KEY (OrdersID) References Orders ( RecID )

);

 

Alter Table WorkersChild Add (

Constraint FK_WorkersChildhe_fatherS FOREIGN KEY (Staff_he_fatherID) References Staff ( RecID ),

Constraint FK_WorkersChildhe_motherS FOREIGN KEY (Staff_he_motherID) References Staff ( RecID ),

Constraint FK_WorkersChildisStaff FOREIGN KEY (Staff_isID) References Staff ( RecID ),

CONSTRAINT U_WorkersChildStaff_isID UNIQUE ( Staff_isID)

);

 

 





Рекомендуемые страницы:

Воспользуйтесь поиском по сайту:
©2015- 2021 megalektsii.ru Все материалы представленные на сайте исключительно с целью ознакомления читателями и не преследуют коммерческих целей или нарушение авторских прав.