Skip to main content

Advertisement

Table 1 Archetype basic data types and mapping rules

From: Archetype relational mapping - a practical openEHR persistence solution

Data type Field Field data type SQL type
CodePhrase codeString String NVARCHAR
DvBoolean value Boolean INTEGER
DvCodedText definingCode CodePhrase #
DvCount magnitude Integer INTEGER
DvDateTime value String NVARCHAR
DvEHRURI value URI NVARCHAR
DvIdentifier id String NVARCHAR
DvMultimedia uri DvURI #
DvProportion precision Integer INTEGER
DvQuantity magnitude Double FLOAT
units String NVARCHAR
DvText value String NVARCHAR
DvURI value URI NVARCHAR
GenericID value String NVARCHAR
name String NVARCHAR
Link target DvEHRURI #