Test page: Difference between revisions
Jump to navigation
Jump to search
ErgoSoftUK (talk | contribs) No edit summary |
ErgoSoftUK (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
| | ||
| |||
= Tables = | =Tables= | ||
{| border="1" cellpadding="1" cellspacing="1 | {| class="mw-collapsible" border="1" cellpadding="1" cellspacing="1" style="width: 500px;" summary="Summary" | ||
|+ xxxzxxz--David Stables 11:18, 5 May 2020 (UTC)Caption | |+xxxzxxz--David Stables 11:18, 5 May 2020 (UTC)Caption | ||
|- | |- | ||
! scope="col" | Code | ! scope="col" |Code | ||
! scope="col" | Term | ! scope="col" |Term | ||
|- | |- | ||
| H33.. | |H33.. | ||
| Asthma | |Asthma | ||
|- | |- | ||
| G33.. | |G33.. | ||
| Diabetes | |Diabetes | ||
|} | |} | ||
Line 25: | Line 23: | ||
| | ||
{| border="1" cellpadding="1" cellspacing="1 | {| class="mw-collapsible mw-collapsed" border="1" cellpadding="1" cellspacing="1" style="width: 500px;" summary="Summary" | ||
|- | |- | ||
! scope="col" | Code | ! scope="col" |Code | ||
! scope="col" | Term | ! scope="col" |Term | ||
|- | |- | ||
| H33.. | |H33.. | ||
| Asthma | |Asthma | ||
|- | |- | ||
| G33.. | |G33.. | ||
| Diabetes | |Diabetes | ||
|} | |} | ||
Line 41: | Line 39: | ||
This text is not collapsible; but the next is collapsible and hidden by default: | This text is not collapsible; but the next is collapsible and hidden by default: | ||
<div class="mw-collapsible-content">This is additional hidden text</div> <div class="mw-collapsible-content"> </div> | <div class="mw-collapsible-content">This is additional hidden text</div> <div class="mw-collapsible-content"> </div> | ||
= Syntax Highlight = | =Syntax Highlight= | ||
</div> | |||
== SQL == | == SQL == | ||
This section should be highlighted source code (SQL) | This section should be highlighted source code (SQL) | ||
<syntaxhighlight lang="SQL">SELECT * | <syntaxhighlight lang="SQL">SELECT * | ||
Line 50: | Line 48: | ||
WHERE patient_id = 1234 </syntaxhighlight> | WHERE patient_id = 1234 </syntaxhighlight> | ||
== JSON == | ==JSON== | ||
<syntaxhighlight lang="JSON"> | <syntaxhighlight lang="JSON"> | ||
{ | { | ||
Line 64: | Line 62: | ||
PRIMARY KEY (organization_id,person_id,id) | PRIMARY KEY (organization_id,person_id,id) | ||
{| | {| class="wikitable" border="1" | ||
|- | |- | ||
! scope="col" | Column name | ! scope="col" |Column name | ||
! scope="col" | Data type | ! scope="col" |Data type | ||
! scope="col" | Constraint | ! scope="col" |Constraint | ||
! scope="col" | Comments | ! scope="col" |Comments | ||
! scope="col" | References | ! scope="col" |References | ||
|- | |- | ||
| id | |id | ||
| bigint(20) | |bigint(20) | ||
| NOT NULL | |NOT NULL | ||
| | | | ||
| | ||
| | | | ||
| | ||
|- | |- | ||
| organization_id | |organization_id | ||
| bigint(20) | |bigint(20) | ||
| NOT NULL | |NOT NULL | ||
| Owning organisation (i.e. publisher) | |Owning organisation (i.e. publisher) | ||
| organization.id | |organization.id | ||
|- | |- | ||
| patient_id | |patient_id | ||
| bigint(20) | |bigint(20) | ||
| NOT NULL | |NOT NULL | ||
| The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times | |The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times | ||
| patient.id | |patient.id | ||
|- | |- | ||
| person_id | |person_id | ||
| bigint(20) | |bigint(20) | ||
| NOT NULL | |NOT NULL | ||
| Unique individual across all organisations | |Unique individual across all organisations | ||
| person.id | |person.id | ||
|- | |- | ||
| encounter_id | |encounter_id | ||
| bigint(20) | |bigint(20) | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| | | | ||
| | ||
| encounter.id | |encounter.id | ||
|- | |- | ||
| practitioner_id | |practitioner_id | ||
| bigint(20) | |bigint(20) | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| The clinician the activity is recorded against | |The clinician the activity is recorded against | ||
| practitioner.id | |practitioner.id | ||
|- | |- | ||
| clinical_effective_date | |clinical_effective_date | ||
| date | |date | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| The date the clinical code is recorded for | |The date the clinical code is recorded for | ||
| | | | ||
|- | |- | ||
| date_precision_id | |date_precision_id | ||
| smallint(6) | |smallint(6) | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14) | |Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14) | ||
| | | | ||
|- | |- | ||
| snomed_concept_id | |snomed_concept_id | ||
| bigint(20) | |bigint(20) | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| The SNOMED code | |The SNOMED code | ||
| | | | ||
|- | |- | ||
| original_code | |original_code | ||
| varchar(100) CHARACTER SET utf8 COLLATE utf8_bin | |varchar(100) CHARACTER SET utf8 COLLATE utf8_bin | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| The original code from the source system | |The original code from the source system | ||
| | | | ||
|- | |- | ||
| original_term | |original_term | ||
| varchar(1000) | |varchar(1000) | ||
| DEFAULT NULL | |DEFAULT NULL | ||
| The original code term from the source system | |The original code term from the source system | ||
| | | | ||
|- | |- | ||
| is_review | |is_review | ||
| tinyint(1) | |tinyint(1) | ||
| NOT NULL | |NOT NULL | ||
| Is this instance of the code a review of a previous encounter | |Is this instance of the code a review of a previous encounter | ||
| | | | ||
|- | |- | ||
| colspan="5" | PRIMARY KEY (organization_id,person_id,id), | | colspan="5" |PRIMARY KEY (organization_id,person_id,id), | ||
|- | |- | ||
| colspan="5" | UNIQUE KEY allergy_intolerance_id (id), | | colspan="5" |UNIQUE KEY allergy_intolerance_id (id), | ||
|- | |- | ||
| colspan="5" | KEY allergy_intolerance_patient_id (patient_id), | | colspan="5" |KEY allergy_intolerance_patient_id (patient_id), | ||
|- | |- | ||
| colspan="5" | KEY allergy_intolerance_snomed_concept_id (snomed_concept_id) | | colspan="5" |KEY allergy_intolerance_snomed_concept_id (snomed_concept_id) | ||
|- | |- | ||
| colspan="5" | | | colspan="5" | | ||
|} | |} | ||
| |
Revision as of 09:49, 14 May 2020
Tables
Code | Term |
---|---|
H33.. | Asthma |
G33.. | Diabetes |
Code | Term |
---|---|
H33.. | Asthma |
G33.. | Diabetes |
This text is not collapsible; but the next is collapsible and hidden by default:
This is additional hidden text
Syntax Highlight
SQL
This section should be highlighted source code (SQL)
SELECT *
FROM observation
WHERE patient_id = 1234
JSON
{
"iri" : ":DM_RecordModel",
"status" : "Active"
}
this is Jo's test open office to mediawiki:
1. Table: allergy_intolerance
PRIMARY KEY (organization_id,person_id,id)
Column name | Data type | Constraint | Comments | References |
---|---|---|---|---|
id | bigint(20) | NOT NULL |
|
|
organization_id | bigint(20) | NOT NULL | Owning organisation (i.e. publisher) | organization.id |
patient_id | bigint(20) | NOT NULL | The organisations record for this person’s registration. Patients may have multiple records across clinical systems and may have registered at an organisation multiple times | patient.id |
person_id | bigint(20) | NOT NULL | Unique individual across all organisations | person.id |
encounter_id | bigint(20) | DEFAULT NULL |
|
encounter.id |
practitioner_id | bigint(20) | DEFAULT NULL | The clinician the activity is recorded against | practitioner.id |
clinical_effective_date | date | DEFAULT NULL | The date the clinical code is recorded for | |
date_precision_id | smallint(6) | DEFAULT NULL | Identifies the precision of the clinical effectiveness date to either year (1) month (2) day (5) minute (12) second (13) millisecond (14) | |
snomed_concept_id | bigint(20) | DEFAULT NULL | The SNOMED code | |
original_code | varchar(100) CHARACTER SET utf8 COLLATE utf8_bin | DEFAULT NULL | The original code from the source system | |
original_term | varchar(1000) | DEFAULT NULL | The original code term from the source system | |
is_review | tinyint(1) | NOT NULL | Is this instance of the code a review of a previous encounter | |
PRIMARY KEY (organization_id,person_id,id), | ||||
UNIQUE KEY allergy_intolerance_id (id), | ||||
KEY allergy_intolerance_patient_id (patient_id), | ||||
KEY allergy_intolerance_snomed_concept_id (snomed_concept_id) | ||||