index.sql

Delphi6开发的HIS程序

-- AccessObject
create unique index ui_accessobject_1 on accessobject(caption);
create unique index ui_accessobject_2 on accessobject(objectname);

-- Approach
create unique index ui_approach_1 on approach(caption);

-- Area
create unique index ui_area_1 on area(caption);
create unique index ui_area_2 on area(parentid, areaid);

-- Bed
create unique index ui_bed_1 on bed(caption);

-- BedCatalog
create unique index ui_bedcatalog_1 on bedcatalog(caption);

-- BloodType
create unique index ui_bloodtype_1 on bloodtype(caption);

-- ChargeCatalog
create unique index ui_chargecatalog_1 on chargecatalog(caption);
create unique index ui_chargecatalog_2 on chargecatalog(chargecatalogcode, parentcode);

-- ChargeItem
create unique index ui_chargeitem_1 on chargeitem(caption);

-- CheckInMethod
create unique index ui_checkinmethod_1 on checkinmethod(caption);

-- CheckOutMethod
create unique index ui_checkoutmethod_1 on checkoutmethod(caption);

-- Country
create unique index ui_country_1 on country(caption);

-- DATemplate
create unique index ui_datemplate_1 on datemplate(caption);

-- Department
create unique index ui_department_1 on department(caption);

-- Diagnose
create unique index ui_diagnose_1 on diagnose(caption);

-- Doctor
create unique index ui_doctor_1 on doctor(sectionofficeid, employeeid);

-- DoctorAdviceType
create unique index ui_doctoradvicetype_1 on doctoradvicetype(caption);

-- DoctorCatalog
create unique index ui_doctorcatalog_1 on doctorcatalog(caption);

-- Dose
create unique index ui_dose_1 on dose(caption);

-- Food
create unique index ui_food_1 on food(caption);

-- FrequencyWeek
create unique index ui_frequencyweek_1 on frequencyweek(caption);

-- Job
create unique index ui_job_1 on job(caption);

-- Manufacturer
create unique index ui_manufacturer_1 on manufacturer(caption);

-- MaterialCatalog
create unique index ui_materialcatalog_1 on materialcatalog(caption);
create unique index ui_materialcatalog_2 on materialcatalog(code);

-- MedicineCatalog
create unique index ui_medicinecatalog_1 on medicinecatalog(caption);
create unique index ui_medicinecatalog_2 on medicinecatalog(code);

-- MaterialStock
create unique index ui_materialstock_1 on materialstock(materialid);

-- MedicineStock
create unique index ui_medicinestock_1 on medicinestock(medicineid);

-- Nation
create unique index ui_nation_1 on nation(caption);

-- NativePlace
create unique index ui_nativeplace_1 on nativeplace(caption);

-- OperationCatalog
create unique index ui_OperationCatalog_1 on OperationCatalog(caption);
create unique index ui_operationcatalog_2 on operationcatalog(code);

-- PaymentMethod
create unique index ui_paymentmethod_1 on paymentmethod(caption);

-- PersonRelation
create unique index ui_personrelation_1 on personrelation(caption);

-- PrepayMethod
create unique index ui_prepaymethod_1 on prepaymethod(caption);

-- Profession
create unique index ui_profession_1 on profession(caption);

-- Provider
create unique index ui_provider_1 on provider(caption);

-- PurchaseMethod
create unique index ui_purchasemethod_1 on purchasemethod(caption);

-- Purview
create unique index ui_purview_1 on purview(caption);

-- SectionOffice
create unique index ui_sectionoffice_1 on sectionoffice(caption);

-- ServiceCatalog
create unique index ui_servicecatalog_1 on servicecatalog(caption);
create unique index ui_servicecatalog_2 on servicecatalog(code);

-- SicknessCatalog
create unique index ui_sicknesscatalog_1 on sicknesscatalog(caption);
create unique index ui_sicknesscatalog_2 on sicknesscatalog(sicknesscatalogcode, parentcode);

-- SicknessLevel
create unique index ui_sicknesslevel_1 on sicknesslevel(caption);

-- SicknessState
create unique index ui_sicknessstate_1 on sicknessstate(caption);

-- Sickroom
create unique index ui_sickroom_1 on sickroom(caption, sectionofficeid);

-- SickType
create unique index ui_sicktype_1 on sicktype(caption);

-- TendLevel
create unique index ui_tendlevel_1 on tendlevel(caption);

-- Times
create unique index ui_times_1 on times(caption);

-- TollStation
create unique index ui_tollstation_1 on tollstation(caption);

-- Units
create unique index ui_units_1 on units(caption);

-- UseMethod
create unique index ui_usemethod_1 on usemethod(caption);

-- Wedlock
create unique index ui_wedlock_1 on wedlock(caption);

-- Medicine
create unique index ui_medicine_1 on medicine(code);

-- Service
create unique index ui_service_1 on service(code);

-- Operation
create unique index ui_operation_1 on operation(code);

-- Sick
create unique index ui_sick_1 on sick(code);

-- Param
create unique index ui_param_1 on param(paramname);

-- Employee
create unique index ui_employee_1 on employee(loginname);