dule.medication-administration-api.1.0.0.source-code.AddConceptReferenceMapProcedure.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of medication-administration-api Show documentation
Show all versions of medication-administration-api Show documentation
Medication Administration API contains DB model and FHIR translation layers for medication administration
The newest version!
CREATE PROCEDURE add_concept_reference_map (concept_id INT,
concept_source_id INT,
reference_term_name VARCHAR(255),
reference_term_code VARCHAR(255),
reference_type_id INT)
BEGIN
DECLARE reference_term_id INT;
INSERT INTO concept_reference_term (concept_source_id, name, code, creator, date_created, uuid)
VALUES (concept_source_id, reference_term_name, reference_term_code, 1, now(), uuid());
SELECT MAX(concept_reference_term_id) INTO reference_term_id FROM concept_reference_term;
INSERT INTO concept_reference_map(concept_reference_term_id, concept_map_type_id, creator, date_created, concept_id, uuid)
VALUES(reference_term_id, reference_type_id, 1, now(), concept_id, uuid());
END;