Goal.extension[] property on the Goal FHIR resource.
Primary Keys:
- goal_extension_id
- goal_id - links to the goal table
† Metriport Platform added
| Column | Data Type | Description |
|---|---|---|
| goal_extension_id | varchar | Unique identifier for the extension row |
| goal_id | varchar | FK to the parent goal 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 |