• Home
• org.ehrbase.openehr
• base
• 0.31.0
• source code
• V23__ehr_status_history_fix.sql

×

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.

db.migration.V23__ehr_status_history_fix.sql Maven / Gradle / Ivy

ALTER TABLE ehr.status_history
  ADD COLUMN archetype_node_id TEXT NOT NULL DEFAULT 'openEHR-EHR-EHR_STATUS.generic.v1',
  ADD COLUMN name ehr.dv_coded_text NOT NULL DEFAULT ('EHR Status',NULL,NULL,NULL,NULL)::ehr.dv_coded_text;