
SELECT setval('cda_doc_id_seq', 1);

-- eDispensation
DELETE FROM cda_generation;
SELECT setval('cda_generation_id_seq', 1);
-- Delete CDAFile ? Patient ? Organization ?
DELETE FROM cdagen_organization;
SELECT setval('cdagen_organization_id_seq', 1);
DELETE FROM pat_patient WHERE dtype = 'cda_patient';
SELECT setval('pat_patient_id_seq', 1);
DELETE FROM cda_file;
SELECT setval('cda_file_id_seq', 1);

--HL7 Templates Validation
DELETE FROM hl7temp_validation;
SELECT setval('hl7temp_validation_id_seq', 1);
