Skip to main content

Advertisement

Springer Nature is making SARS-CoV-2 and COVID-19 research free. View research | View latest news | Sign up for updates

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 #