Test page: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
Line 41: Line 41:
this is Jo's test open office to mediawiki:
this is Jo's test open office to mediawiki:


1.    Table: allergy_intolerance
1.    Table: allergy_intolerance


PRIMARY KEY (organization_id,person_id,id)
PRIMARY KEY (organization_id,person_id,id)


{| border="1"
{| border="1" class="wikitable"
|Column name
|Data type
|Constraint
|Comments
|References
|-
|-
| Column name
| Data type
| Constraint
| Comments
| References
|-
| id
| bigint(20)
| NOT NULL
|
 


|id
|  
|bigint(20)
 
|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
| bigint(20)
| DEFAULT NULL
|
 


|encounter_id
| encounter.id
|bigint(20)
|DEFAULT NULL
|
 
 
|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 15:54, 7 May 2020

xxxzxxz--David Stables 11:18, 5 May 2020 (UTC)Caption
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

This section should be highlighted source code (SQL) 

SELECT * FROM observation WHERE patient_id = 1234

 

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)
 

 

Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=Test_page&oldid=436’