• Home
• org.bahmni.module
• bahmnicore-omod
• 1.2.0
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

dule.bahmnicore-omod.1.2.0.source-code.V1_81__DeleteConcept.sql Maven / Gradle / Ivy

CREATE  PROCEDURE delete_concept (name_concept VARCHAR(255))
BEGIN
    DECLARE conceptId INT default 0;

    select concept_id INTO conceptId from concept_name where name = name_concept and locale_preferred = 1;
    delete from concept_set where concept_set = conceptId;
    delete from concept_name where concept_id = conceptId;
    delete from concept_numeric where concept_id = conceptId;
    delete from concept_answer where concept_id = conceptId;
    delete from concept where concept_id = conceptId;
END;