his.sql

Delphi6开发的HIS程序

    REFERENCES Country(CountryID)
;

ALTER TABLE Inpatient ADD CONSTRAINT RefBloodType107 
    FOREIGN KEY (BloodTypeID)
    REFERENCES BloodType(BloodTypeID)
;

ALTER TABLE Inpatient ADD CONSTRAINT RefPersonRelation108 
    FOREIGN KEY (PersonRelationID)
    REFERENCES PersonRelation(PersonRelationID)
;

ALTER TABLE Inpatient ADD CONSTRAINT RefSick110 
    FOREIGN KEY (SickID)
    REFERENCES Sick(SickID)
;

ALTER TABLE Inpatient ADD CONSTRAINT RefReckoning111 
    FOREIGN KEY (ReckoningID)
    REFERENCES Reckoning(ReckoningID)
;

ALTER TABLE Inpatient ADD CONSTRAINT RefSectionOffice114 
    FOREIGN KEY (SectionOfficeID)
    REFERENCES SectionOffice(SectionOfficeID)
;


-- 
-- TABLE: Manufacturer 
--

ALTER TABLE Manufacturer ADD CONSTRAINT RefArea91 
    FOREIGN KEY (AreaID)
    REFERENCES Area(AreaID)
;


-- 
-- TABLE: Material 
--

ALTER TABLE Material ADD CONSTRAINT RefMaterialCatalog15 
    FOREIGN KEY (MaterialCatalogID)
    REFERENCES MaterialCatalog(MaterialCatalogID)
;

ALTER TABLE Material ADD CONSTRAINT RefDose45 
    FOREIGN KEY (DoseID)
    REFERENCES Dose(DoseID)
;

ALTER TABLE Material ADD CONSTRAINT RefUnits46 
    FOREIGN KEY (UnitsID)
    REFERENCES Units(UnitsID)
;


-- 
-- TABLE: MaterialCatalog 
--

ALTER TABLE MaterialCatalog ADD CONSTRAINT RefMaterialCatalog14 
    FOREIGN KEY (ParentID)
    REFERENCES MaterialCatalog(MaterialCatalogID)
;

ALTER TABLE MaterialCatalog ADD CONSTRAINT RefChargeCatalog16 
    FOREIGN KEY (ChargeCatalogCode)
    REFERENCES ChargeCatalog(ChargeCatalogCode)
;


-- 
-- TABLE: MaterialStock 
--

ALTER TABLE MaterialStock ADD CONSTRAINT RefMaterial139 
    FOREIGN KEY (MaterialID)
    REFERENCES Material(MaterialID)
;

ALTER TABLE MaterialStock ADD CONSTRAINT RefUnits140 
    FOREIGN KEY (MinUnitsCode)
    REFERENCES Units(UnitsID)
;


-- 
-- TABLE: MaterialStockDetail 
--

ALTER TABLE MaterialStockDetail ADD CONSTRAINT RefMaterialStock141 
    FOREIGN KEY (MaterialStockID)
    REFERENCES MaterialStock(MaterialStockID)
;

ALTER TABLE MaterialStockDetail ADD CONSTRAINT RefSIOMaterialDetail142 
    FOREIGN KEY (SIOMaterialDetailID)
    REFERENCES SIOMaterialDetail(SIOMaterialDetailID)
;


-- 
-- TABLE: Medicine 
--

ALTER TABLE Medicine ADD CONSTRAINT RefMedicineCatalog13 
    FOREIGN KEY (MedicineCatalogID)
    REFERENCES MedicineCatalog(MedicineCatalogID)
;

ALTER TABLE Medicine ADD CONSTRAINT RefDose42 
    FOREIGN KEY (DoseID)
    REFERENCES Dose(DoseID)
;

ALTER TABLE Medicine ADD CONSTRAINT RefUnits43 
    FOREIGN KEY (UnitsID)
    REFERENCES Units(UnitsID)
;

ALTER TABLE Medicine ADD CONSTRAINT RefUseMethod103 
    FOREIGN KEY (UseMethodID)
    REFERENCES UseMethod(UseMethodID)
;


-- 
-- TABLE: MedicineCatalog 
--

ALTER TABLE MedicineCatalog ADD CONSTRAINT RefChargeCatalog17 
    FOREIGN KEY (ChargeCatalogCode)
    REFERENCES ChargeCatalog(ChargeCatalogCode)
;

ALTER TABLE MedicineCatalog ADD CONSTRAINT RefMedicineCatalog104 
    FOREIGN KEY (ParentID)
    REFERENCES MedicineCatalog(MedicineCatalogID)
;


-- 
-- TABLE: MedicineStock 
--

ALTER TABLE MedicineStock ADD CONSTRAINT RefMedicine135 
    FOREIGN KEY (MedicineID)
    REFERENCES Medicine(MedicineID)
;

ALTER TABLE MedicineStock ADD CONSTRAINT RefUnits136 
    FOREIGN KEY (MinUnitsCode)
    REFERENCES Units(UnitsID)
;


-- 
-- TABLE: MedicineStockDetail 
--

ALTER TABLE MedicineStockDetail ADD CONSTRAINT RefMedicineStock137 
    FOREIGN KEY (MedicineStockID)
    REFERENCES MedicineStock(MedicineStockID)
;

ALTER TABLE MedicineStockDetail ADD CONSTRAINT RefSIOMedicineDetail138 
    FOREIGN KEY (SIOMedicineDetailID)
    REFERENCES SIOMedicineDetail(SIOMedicineDetailID)
;


-- 
-- TABLE: NativePlace 
--

ALTER TABLE NativePlace ADD CONSTRAINT RefNativePlace63 
    FOREIGN KEY (ParentID)
    REFERENCES NativePlace(NativePlaceID)
;


-- 
-- TABLE: Operation 
--

ALTER TABLE Operation ADD CONSTRAINT RefOperationCatalog180 
    FOREIGN KEY (OperationCatalogID)
    REFERENCES OperationCatalog(OperationCatalogID)
;


-- 
-- TABLE: OperationCatalog 
--

ALTER TABLE OperationCatalog ADD CONSTRAINT RefOperationCatalog185 
    FOREIGN KEY (ParentID)
    REFERENCES OperationCatalog(OperationCatalogID)
;

ALTER TABLE OperationCatalog ADD CONSTRAINT RefChargeCatalog18 
    FOREIGN KEY (ChargeCatalogCode)
    REFERENCES ChargeCatalog(ChargeCatalogCode)
;


-- 
-- TABLE: PCOMaterial 
--

ALTER TABLE PCOMaterial ADD CONSTRAINT RefEmployee147 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PCOMaterial ADD CONSTRAINT RefEmployee148 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PCOMaterial ADD CONSTRAINT RefEmployee149 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PCOMaterial ADD CONSTRAINT RefMaterialStockDetail154 
    FOREIGN KEY (MaterialStockDetailID)
    REFERENCES MaterialStockDetail(MaterialStockDetailID)
;


-- 
-- TABLE: PCOMedicine 
--

ALTER TABLE PCOMedicine ADD CONSTRAINT RefMedicineStockDetail143 
    FOREIGN KEY (MedicineStockDetailID)
    REFERENCES MedicineStockDetail(MedicineStockDetailID)
;

ALTER TABLE PCOMedicine ADD CONSTRAINT RefEmployee144 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PCOMedicine ADD CONSTRAINT RefEmployee145 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PCOMedicine ADD CONSTRAINT RefEmployee146 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: POMaterialDetail 
--

ALTER TABLE POMaterialDetail ADD CONSTRAINT RefPurchaseOrder99 
    FOREIGN KEY (PurchaseOrderID)
    REFERENCES PurchaseOrder(PurchaseOrderID)
;

ALTER TABLE POMaterialDetail ADD CONSTRAINT RefMaterial100 
    FOREIGN KEY (MaterialID)
    REFERENCES Material(MaterialID)
;

ALTER TABLE POMaterialDetail ADD CONSTRAINT RefProvider116 
    FOREIGN KEY (ProviderID)
    REFERENCES Provider(ProviderID)
;


-- 
-- TABLE: POMedicineDetail 
--

ALTER TABLE POMedicineDetail ADD CONSTRAINT RefPurchaseOrder51 
    FOREIGN KEY (PurchaseOrderID)
    REFERENCES PurchaseOrder(PurchaseOrderID)
;

ALTER TABLE POMedicineDetail ADD CONSTRAINT RefMedicine98 
    FOREIGN KEY (MedicineID)
    REFERENCES Medicine(MedicineID)
;

ALTER TABLE POMedicineDetail ADD CONSTRAINT RefProvider115 
    FOREIGN KEY (ProviderID)
    REFERENCES Provider(ProviderID)
;


-- 
-- TABLE: PrepayHistory 
--

ALTER TABLE PrepayHistory ADD CONSTRAINT RefInpatient77 
    FOREIGN KEY (InpatientID)
    REFERENCES Inpatient(InpatientID)
;

ALTER TABLE PrepayHistory ADD CONSTRAINT RefPrepayMethod78 
    FOREIGN KEY (PrepayMethodID)
    REFERENCES PrepayMethod(PrepayMethodID)
;

ALTER TABLE PrepayHistory ADD CONSTRAINT RefEmployee79 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PrepayHistory ADD CONSTRAINT RefEmployee80 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: Provider 
--

ALTER TABLE Provider ADD CONSTRAINT RefArea94 
    FOREIGN KEY (AreaID)
    REFERENCES Area(AreaID)
;


-- 
-- TABLE: PSCOMedicine 
--

ALTER TABLE PSCOMedicine ADD CONSTRAINT RefPStockMedicine159 
    FOREIGN KEY (PStockMedicineID)
    REFERENCES PStockMedicine(PStockMedicineID)
;

ALTER TABLE PSCOMedicine ADD CONSTRAINT RefEmployee161 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PSCOMedicine ADD CONSTRAINT RefEmployee162 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PSCOMedicine ADD CONSTRAINT RefEmployee163 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: PSIODetail 
--

ALTER TABLE PSIODetail ADD CONSTRAINT RefPStockInOrder169 
    FOREIGN KEY (PStockInOrderID)
    REFERENCES PStockInOrder(PStockInOrderID)
;


-- 
-- TABLE: PSOODetail 
--

ALTER TABLE PSOODetail ADD CONSTRAINT RefPStockOutOrder174 
    FOREIGN KEY (PStockOutOrderID)
    REFERENCES PStockOutOrder(PStockOutOrderID)
;


-- 
-- TABLE: PStockInOrder 
--

ALTER TABLE PStockInOrder ADD CONSTRAINT RefStockOutOrder89 
    FOREIGN KEY (StockOutOrderID)
    REFERENCES StockOutOrder(StockOutOrderID)
;

ALTER TABLE PStockInOrder ADD CONSTRAINT RefPStockMedicine164 
    FOREIGN KEY (PStockMedicineID)
    REFERENCES PStockMedicine(PStockMedicineID)
;

ALTER TABLE PStockInOrder ADD CONSTRAINT RefMedicineStock165 
    FOREIGN KEY (MedicineStockID)
    REFERENCES MedicineStock(MedicineStockID)
;

ALTER TABLE PStockInOrder ADD CONSTRAINT RefEmployee166 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PStockInOrder ADD CONSTRAINT RefEmployee167 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PStockInOrder ADD CONSTRAINT RefEmployee168 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: PStockMedicine 
--

ALTER TABLE PStockMedicine ADD CONSTRAINT RefMedicineStock160 
    FOREIGN KEY (MedicineStockID)
    REFERENCES MedicineStock(MedicineStockID)
;


-- 
-- TABLE: PStockOutOrder 
--

ALTER TABLE PStockOutOrder ADD CONSTRAINT RefPStockMedicine170 
    FOREIGN KEY (PStockMedicineID)
    REFERENCES PStockMedicine(PStockMedicineID)
;

ALTER TABLE PStockOutOrder ADD CONSTRAINT RefEmployee171 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PStockOutOrder ADD CONSTRAINT RefEmployee172 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PStockOutOrder ADD CONSTRAINT RefEmployee173 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: PurchaseOrder 
--

ALTER TABLE PurchaseOrder ADD CONSTRAINT RefEmployee47 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PurchaseOrder ADD CONSTRAINT RefEmployee48 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE PurchaseOrder ADD CONSTRAINT RefPurchaseMethod49 
    FOREIGN KEY (PurchaseMethodID)
    REFERENCES PurchaseMethod(PurchaseMethodID)
;

ALTER TABLE PurchaseOrder ADD CONSTRAINT RefEmployee50 
    FOREIGN KEY (ApproveBy)
    REFERENCES Employee(EmployeeID)
;


-- 
-- TABLE: Recipe 
--

ALTER TABLE Recipe ADD CONSTRAINT RefDoctor2 
    FOREIGN KEY (DoctorID)
    REFERENCES Doctor(DoctorID)
;

ALTER TABLE Recipe ADD CONSTRAINT RefReckoning3 
    FOREIGN KEY (ReckoningID)
    REFERENCES Reckoning(ReckoningID)
;

ALTER TABLE Recipe ADD CONSTRAINT RefEmployee11 
    FOREIGN KEY (CreateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE Recipe ADD CONSTRAINT RefEmployee12 
    FOREIGN KEY (UpdateBy)
    REFERENCES Employee(EmployeeID)
;

ALTER TABLE Recipe ADD CONSTRAINT RefSick113 
    FOREIGN KEY (SickID)
    REFERENCES Sick(SickID)
;


-- 
-- TABLE: Reckoning 
--

ALTER TABLE Reckoning ADD CONSTRAINT RefSick97 
    FOREIGN KEY (SickID)
    REFERENCES Sick(SickID)
;


-- 
-- TAB