device_extension

Normalized Device.extension[] property on the Device FHIR resource.

Primary Keys:

• device_extension_id

Foreign Keys:

• device_id - links to the device table

_{† Metriport Platform added}

Column	Data Type	Description
device_extension_id	varchar	Unique identifier for the extension row
device_id	varchar	FK to the parent device record
extension_rank†	int	1-based position of this extension in the source array
url	varchar	Extension URL identifying the extension type
valuestring	varchar	String value
valueboolean	bool	Boolean value
valuecode	varchar	Code value
valuedatetime	datetime	Datetime value
valueinteger	int	Integer value
valuedecimal	numeric	Decimal value
valuecoding_code	varchar	Coding code value
valuecoding_display	varchar	Coding display text
valuecoding_system	varchar	Coding system URI
valuecodeableconcept_text	varchar	CodeableConcept text
valuereference_reference	varchar	Reference value

Related Tables:

Parent:

• device

Child:

• device_extension_vcc_coding