history_data


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of history_data.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains patient eating,sleeping,drinking,drug habits as well as other patient health history information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
uuid BINARY 16 √ null
coffee LONGTEXT 2147483647 √ null
tobacco LONGTEXT 2147483647 √ null
alcohol LONGTEXT 2147483647 √ null
sleep_patterns LONGTEXT 2147483647 √ null
exercise_patterns LONGTEXT 2147483647 √ null
seatbelt_use LONGTEXT 2147483647 √ null
counseling LONGTEXT 2147483647 √ null
hazardous_activities LONGTEXT 2147483647 √ null
recreational_drugs LONGTEXT 2147483647 √ null
last_breast_exam VARCHAR 255 √ null
last_mammogram VARCHAR 255 √ null
last_gynocological_exam VARCHAR 255 √ null
last_rectal_exam VARCHAR 255 √ null
last_prostate_exam VARCHAR 255 √ null
last_physical_exam VARCHAR 255 √ null
last_sigmoidoscopy_colonoscopy VARCHAR 255 √ null
last_ecg VARCHAR 255 √ null
last_cardiac_echo VARCHAR 255 √ null
last_retinal VARCHAR 255 √ null
last_fluvax VARCHAR 255 √ null
last_pneuvax VARCHAR 255 √ null
last_ldl VARCHAR 255 √ null
last_hemoglobin VARCHAR 255 √ null
last_psa VARCHAR 255 √ null
last_exam_results VARCHAR 255 √ null
history_mother LONGTEXT 2147483647 √ null
dc_mother TEXT 65535 √ null
history_father LONGTEXT 2147483647 √ null
dc_father TEXT 65535 √ null
history_siblings LONGTEXT 2147483647 √ null
dc_siblings TEXT 65535 √ null
history_offspring LONGTEXT 2147483647 √ null
dc_offspring TEXT 65535 √ null
history_spouse LONGTEXT 2147483647 √ null
dc_spouse TEXT 65535 √ null
relatives_cancer LONGTEXT 2147483647 √ null
relatives_tuberculosis LONGTEXT 2147483647 √ null
relatives_diabetes LONGTEXT 2147483647 √ null
relatives_high_blood_pressure LONGTEXT 2147483647 √ null
relatives_heart_problems LONGTEXT 2147483647 √ null
relatives_stroke LONGTEXT 2147483647 √ null
relatives_epilepsy LONGTEXT 2147483647 √ null
relatives_mental_illness LONGTEXT 2147483647 √ null
relatives_suicide LONGTEXT 2147483647 √ null
cataract_surgery DATETIME 19 √ null
tonsillectomy DATETIME 19 √ null
cholecystestomy DATETIME 19 √ null
heart_surgery DATETIME 19 √ null
hysterectomy DATETIME 19 √ null
hernia_repair DATETIME 19 √ null
hip_replacement DATETIME 19 √ null
knee_replacement DATETIME 19 √ null
appendectomy DATETIME 19 √ null
date DATETIME 19 √ null
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
name_1 VARCHAR 255 √ null
value_1 VARCHAR 255 √ null
name_2 VARCHAR 255 √ null
value_2 VARCHAR 255 √ null
additional_history TEXT 65535 √ null
exams TEXT 65535 √ null
usertext11 TEXT 65535 √ null
usertext12 VARCHAR 255
usertext13 VARCHAR 255
usertext14 VARCHAR 255
usertext15 VARCHAR 255
usertext16 VARCHAR 255
usertext17 VARCHAR 255
usertext18 VARCHAR 255
usertext19 VARCHAR 255
usertext20 VARCHAR 255
usertext21 VARCHAR 255
usertext22 VARCHAR 255
usertext23 VARCHAR 255
usertext24 VARCHAR 255
usertext25 VARCHAR 255
usertext26 VARCHAR 255
usertext27 VARCHAR 255
usertext28 VARCHAR 255
usertext29 VARCHAR 255
usertext30 VARCHAR 255
userdate11 DATE 10 √ null
userdate12 DATE 10 √ null
userdate13 DATE 10 √ null
userdate14 DATE 10 √ null
userdate15 DATE 10 √ null
userarea11 TEXT 65535 √ null
userarea12 TEXT 65535 √ null
created_by BIGINT 19 √ null
users.id Defined in XML R

The user that created this record

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid Performance Asc pid
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation