Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29 | Следующая страница реферата

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

Рекомендуем скачать другие рефераты по теме: 11 контрольная работа, решебник класс по математике.





Предыдущая страница реферата | 19  20  21  22  23  24  25  26  27  28  29 | Следующая страница реферата