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 | # |