-- 主键索引
ALTER TABLE SPRING_SESSION ADD CONSTRAINT PK_SPRING_SESSION PRIMARY KEY (PRIMARY_ID);

-- 唯一索引
CREATE UNIQUE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (SESSION_ID);

-- 普通索引
CREATE INDEX SPRING_SESSION_IX2 ON SPRING_SESSION (EXPIRY_TIME);
CREATE INDEX SPRING_SESSION_IX3 ON SPRING_SESSION (PRINCIPAL_NAME);

-- 主键索引
ALTER TABLE SPRING_SESSION_ATTRIBUTES ADD CONSTRAINT PK_SPRING_SESSION_ATTRIBUTES PRIMARY KEY (SESSION_PRIMARY_ID, ATTRIBUTE_NAME);

-- 外键索引
ALTER TABLE SPRING_SESSION_ATTRIBUTES ADD CONSTRAINT FK_SPRING_SESSION_ATTRIBUTES FOREIGN KEY (SESSION_PRIMARY_ID) REFERENCES SPRING_SESSION (PRIMARY_ID) ON DELETE CASCADE;


-- 普通索引
CREATE INDEX IDX_CAS_TOKEN_TOKEN ON cas_token (token);

CREATE INDEX IDX_CASE_NO_PATIENT_ID ON case_allergic (case_no);

CREATE INDEX IDX_CASE_NO_PATIENT_ID ON case_diagnose (case_no);
CREATE INDEX IDX_CASE_NO_PATIENT_ID ON case_lis (case_no);
CREATE INDEX IDX_CASE_NO_PATIENT_ID ON case_ot (case_no);
CREATE INDEX IDX_DETECTION_NO ON case_diagnose_content (case_no, detection_no);

CREATE INDEX IDX_CASE_NO ON case_info (case_no);
CREATE INDEX IDX_DETECTION_NO ON case_info (detection_no);
CREATE INDEX IDX_DETECTION_NO ON case_info_audit_result (case_no, detection_no);

CREATE INDEX IDX_HMC ON r_dose (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_composition (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_age (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_allergic (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_classify (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_edible (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_gestation (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_usage (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_ast (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_black_white (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_freq (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_lis (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_lis_check (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_ot (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_resistance (hospital_medicine_code);
CREATE INDEX IDX_HMC ON hospital_medicine_rule_audit (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_solvent (hospital_medicine_code);
CREATE INDEX IDX_HMC ON r_administration (hospital_medicine_code);
CREATE INDEX IDX_CODE ON hospital_ot (code);

CREATE INDEX IDX_HU ON r_usage_condition (hk_usage_id);
CREATE INDEX HDA_IDX ON r_diagnose (hospital_icd_code);
CREATE INDEX IDX_HMC_HIC ON r_diagnose (hospital_medicine_code, hospital_icd_code);

CREATE INDEX IDX_H_C ON r_interaction (hospital_medicine_code_a, sug_flag);
CREATE INDEX IDX_H_C_2 ON r_interaction (hospital_medicine_code_b);

CREATE INDEX IDX_KNOW_CODE ON hospital_diagnose (knowledge_diagnose_code);
CREATE INDEX IDX_ICD_CODE ON hospital_diagnose (icd_code);
-- 创建主键索引
ALTER TABLE hospital_diagnose_category ADD CONSTRAINT PK_HOSPITAL_DIAGNOSE_CATEGORY PRIMARY KEY (hospital_id, diagnose_category, icd_code);

-- 创建唯一索引
CREATE UNIQUE INDEX UNQ_HOSPITAL_DIAGNOSTIC_CATEGORY_ID ON hospital_diagnose_category (id);
CREATE UNIQUE INDEX UNQ_HOSPITAL_ID_CODE ON hospital_employee (hospital_id, code);
CREATE INDEX IDX_HOSPITAL_EMPLOYEE_CODE ON hospital_employee_passport (hospital_id, employee_code);
-- 创建唯一索引
CREATE UNIQUE INDEX UNQ_HOSPITAL_MEDICINE_CODE ON hospital_medicine (hospital_id, code);

-- 创建普通索引
CREATE INDEX IDX_KM_ID ON hospital_medicine (knowledge_medicine_id);
CREATE UNIQUE INDEX UNQ_MEDICINE_CODE ON medicine_sync_record (hospital_id, code);
CREATE INDEX IDX_ZYID ON ip_emr (zyid);
CREATE INDEX IDX_CODE ON k_classify (classify_code);
CREATE INDEX IDX_NAME ON k_classify (classify_name);
CREATE INDEX IDX_MMA ON k_compatibility (medicine_main_id_a);
CREATE INDEX IDX_MMB ON k_compatibility (medicine_main_id_b);
CREATE INDEX IDX_CODE ON k_diagnose (code);
CREATE INDEX IDX_ICD_CODE ON k_diagnose (icd_code);
CREATE INDEX KNOWLEDGE_DRUG_MAIN_ID_INDEX ON k_medicine (medicine_main_id);
CREATE INDEX IDX_NSG ON k_medicine (name, spell, general_name);
CREATE INDEX IDX_SG ON k_medicine (spell, general_name);
CREATE INDEX IDX_GENERAL ON k_medicine (general_name);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_age (medicine_id);
CREATE INDEX KNOWLEDGE_DRUG_ALLERGIC_DRUG_ID ON k_medicine_allergic (medicine_id);
CREATE INDEX DRUG_COMPOSITION_DRUG_ID ON k_medicine_composition (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_diagnose (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_dose (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_duality (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_edible (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_gestation (medicine_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_usage (medicine_id);
CREATE INDEX MEDICINE_ID_A_IDX ON k_medicine_interaction (medicine_id_a);
CREATE INDEX MEDICINE_ID_B_IDX ON k_medicine_interaction (medicine_id_b);
CREATE INDEX MEDICINE_USAGE_ID_IDX ON k_medicine_usage_condition (medicine_usage_id);
CREATE INDEX MEDICINE_ID_IDX ON k_medicine_usage_relation (medicine_id);
CREATE INDEX OID_IDX ON knowledge_search (oid);
CREATE INDEX IX_TOKEN ON login_record (token);
CREATE INDEX IX_CREATE_TIME ON menu (create_time);
CREATE INDEX IX_UPDATE_TIME ON menu (update_time);
CREATE INDEX IDX_TREAT_CODE ON patient (treat_code);
CREATE INDEX IDX_TREAT_CODE ON prescription (treat_code);
CREATE INDEX IDX_CASE_DETECTION ON prescription (case_no, detection_no);
CREATE INDEX IDX_DETECTION ON prescription (detection_no);
CREATE INDEX IDX_CASE_PRESC ON prescription (case_no, prescription_id);
CREATE INDEX IDX_CASE_NO ON pm_audit_result (case_no, detection_no, prescription_id);
CREATE INDEX IDX_CDP ON pm_audit_result (case_no, detection_no, prescription_id);
CREATE INDEX IDX_DETECTION_NO ON pm_audit_result (detection_no);
CREATE INDEX IDX_DETECTION_NO ON pm_white_rule (detection_no);
CREATE INDEX IX_SERIES ON remember_token (series);
CREATE INDEX IX_HOSPITAL_ID ON role (hospital_id);
CREATE INDEX IX_ROLE_NAME ON role (role_name);
CREATE INDEX IX_CREATE_TIME ON role (create_time);
CREATE INDEX IX_UPDATE_TIME ON role (update_time);
CREATE INDEX IX_HOSPITAL_ID ON role_menu (hospital_id);
CREATE INDEX IX_ROLE_ID ON role_menu (role_id);
CREATE INDEX IX_MENU_ID ON role_menu (menu_id);
CREATE INDEX IX_CREATE_TIME ON role_menu (create_time);
CREATE INDEX IX_UPDATE_TIME ON role_menu (update_time);
-- 创建唯一索引
CREATE UNIQUE INDEX UX_EID ON socket_message (eid);

-- 创建普通索引
CREATE INDEX IX_RETRY ON socket_message (to_user_code, status);
CREATE INDEX IX_CREATE_TIME ON socket_message (create_time);
CREATE INDEX IX_UPDATE_TIME ON socket_message (update_time);
CREATE INDEX IX_SESSION_ID ON socket_online (session_id);
CREATE INDEX IX_SERVER_IP ON socket_online (server_ip);
CREATE INDEX IX_HOSPITAL_ID ON socket_online (hospital_id);
CREATE INDEX IX_USER_CODE ON socket_online (user_code);
CREATE INDEX IX_CREATE_TIME ON socket_online (create_time);
CREATE INDEX IX_UPDATE_TIME ON socket_online (update_time);
CREATE INDEX IX_HOSPITAL_ID ON user_role (hospital_id);
CREATE INDEX IX_USER_ID ON user_role (user_id);
CREATE INDEX IX_CREATE_TIME ON user_role (create_time);
CREATE INDEX IX_UPDATE_TIME ON user_role (update_time);
CREATE INDEX IDX_H_C ON hospital_medicine_rule_setting (medicine_code);
CREATE INDEX IDX_CODE ON r_concomitant_drugs (medicine_code);
CREATE INDEX IDX_HMC ON r_prescribe_limit (medicine_code);