Test page: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
ErgoSoftUK (talk | contribs) No edit summary |
||
Line 1: | Line 1: | ||
This is a link to an [[Navigation side menu|image]] with a preview on tooltip | |||
<div class="line"><span>THIS IS A TEST</span></div> | <div class="line"><span>THIS IS A TEST</span></div> | ||
Line 32: | Line 32: | ||
|- | |- | ||
|H33.. | |H33.. | ||
!<span class="line">|Asthma | ! <span class="line"> |Asthma | ||
|- | |- | ||
|G33.. | |G33.. | ||
Line 45: | Line 45: | ||
=Syntax Highlight= | =Syntax Highlight= | ||
==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 59: | Line 59: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
== Java == | ==Java== | ||
<syntaxhighlight lang="java"> | <syntaxhighlight lang="java"> | ||
public class Test { | public class Test { | ||
Line 97: | Line 97: | ||
|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 | ||
Line 116: | Line 116: | ||
|- | |- | ||
|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 | ||
Line 123: | Line 123: | ||
|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 | ||
| | | | ||
Line 147: | Line 147: | ||
|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 | ||
| | | | ||
Line 179: | Line 179: | ||
</syntaxhighlight></div> <div class="mw-collapsible-content"> </div> | </syntaxhighlight></div> <div class="mw-collapsible-content"> </div> | ||
</div> | </div> | ||
[[Image:Family relationships.jpg|right|thumb|Example of a family tree. Reading left to right Lucas Grey is the father of three children, the grandfather of five grandchildren and the great-grandfather of three siblings Joseph, John and Laura Wetter.]] | [[Image:Family relationships.jpg|right|thumb|Example of a family tree. Reading left to right Lucas Grey is the father of three children, the grandfather of five grandchildren and the great-grandfather of three siblings Joseph, John and Laura Wetter.]] |
Revision as of 15:06, 15 June 2020
This is a link to an image with a preview on tooltip
THIS IS A TEST
this is some content other
This is a warning. |
This is a note. |
This is some info. |
This is a tip. |
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"
}
Java
public class Test {
private int _id;
public String name;
}
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) | ||||
This text is not collapsible; but the next is collapsible and hidden by default:
{
"iri" : ":DM_RecordModel",
"status" : "Active"
}