| is_deleted | boolean | If this record should be considered soft deleted |
| observation_id | varbinary | Unique identifier for the problem observation record |
| patient_id | varbinary | Unique identifier for the patient associated with this problem |
| consultation_id | varbinary | Identifier of the consultation during which the problem was recorded, if applicable |
| parent_problem_id | varbinary | Identifier of the parent problem, enabling hierarchical grouping of related problems |
| code_id | bigint | Identifier for the clinical code associated with this problem |
| consultation_source_code_id | bigint | Identifier for the consultation source code |
| snomed_concept_id | bigint | SNOMED CT concept identifier for the coded clinical problem |
| effective_datetime | timestamp(6) with time zone | The date on which the problem became clinically effective |
| problem_end_datetime | timestamp(6) with time zone | The date on which the problem was resolved or ended; NULL if still active |
| last_review_datetime | timestamp(6) with time zone | The date the problem was last reviewed by a clinician |
| problem_status_description | varchar | Description of the current clinical status of the problem (e.g. Active, Past) |
| problem_significance_description | varchar | Description of the clinical significance of the problem (e.g. Major, Minor) |
| parent_problem_relationship_description | varchar | Description of the relationship between this problem and its parent problem |
| expected_duration | bigint | Expected duration of the problem in days, if recorded |
| problem_event_type | varchar | The type of event associated with the problem record |
| organisation | varchar | An identifier for the source of data (an organisation) relating to a given GP practice |
| transform_datetime | timestamp(6) with time zone | The date that the data was made available in the model with a relevant change |
| model_updated_datetime | timestamp(6) with time zone | The date that the model record was last updated in the source system |
