CamCOPS
CamCOPS – Detailed table structure
Back to Documentation
www.camcops.org/documentation/tables_detailed.html

Detailed list of CamCOPS columns found on the server

Table type Table Column Column type May be NULL Comment
BASE TABLE _dirty_tables device varchar(255) YES Source tablet device ID
BASE TABLE _dirty_tables tablename text YES Table in the process of being preserved
BASE TABLE _security_audit id int(11) NO Arbitrary primary key
BASE TABLE _security_audit when_access_utc datetime NO Date/time of access (UTC)
BASE TABLE _security_audit source varchar(20) NO Source (e.g. tablet, webviewer)
BASE TABLE _security_audit user varchar(255) YES User name, where applicable
BASE TABLE _security_audit device varchar(255) YES Device, where applicable
BASE TABLE _security_audit table_name varchar(255) YES Table involved, where applicable
BASE TABLE _security_audit server_pk int(11) YES Server PK (table._pk), where applicable
BASE TABLE _security_audit patient_server_pk int(11) YES Server PK of the patient (patient._pk) concerned, or NULL if not applicable
BASE TABLE _security_audit details text YES Details of the access
BASE TABLE _security_devices device varchar(255) NO ID of the source tablet device
BASE TABLE _security_devices registered_by_user varchar(255) YES User that registered the device
BASE TABLE _security_devices when_registered_utc datetime YES Date/time when the device was registered (UTC)
BASE TABLE _security_devices friendly_name text YES Friendly name of the device
BASE TABLE _security_devices camcops_version double YES CamCOPS version number on the tablet device
BASE TABLE _security_devices last_upload_batch_utc datetime YES Date/time when the device's last upload batch started (UTC)
BASE TABLE _security_devices ongoing_upload_batch_utc datetime YES Date/time when the device's ongoing upload batch started (UTC)
BASE TABLE _security_devices uploading_user varchar(255) YES User in the process of uploading right now
BASE TABLE _security_devices currently_preserving tinyint(1) YES Preservation currently in progress
BASE TABLE _security_users user varchar(255) NO User name
BASE TABLE _security_users hashedpw varchar(255) NO Password hash
BASE TABLE _security_users last_password_change_utc datetime YES Date/time this user last changed their password (UTC)
BASE TABLE _security_users may_upload tinyint(1) NO May the user upload data from a tablet device?
BASE TABLE _security_users may_register_devices tinyint(1) NO May the user register tablet devices?
BASE TABLE _security_users may_use_webstorage tinyint(1) NO May the user use the mobileweb database to run CamCOPS tasks via a web browser?
BASE TABLE _security_users may_use_webviewer tinyint(1) NO May the user use the web front end to view CamCOPS data?
BASE TABLE _security_users may_view_other_users_records tinyint(1) NO May the user see records uploaded by another user?
BASE TABLE _security_users view_all_patients_when_unfiltered tinyint(1) NO When no record filters are applied, can the user see all records? (If not, then none are shown.)
BASE TABLE _security_users may_alter_users tinyint(1) NO Is the user an administrator authorized to alter other users' permissions?
BASE TABLE _security_webviewer_sessions id varchar(50) NO Session ID (base 64 encoded random number)
BASE TABLE _security_webviewer_sessions user varchar(255) YES User name
BASE TABLE _security_webviewer_sessions ip_address varchar(40) YES IP address of user
BASE TABLE _security_webviewer_sessions last_activity_utc datetime YES Date/time of last activity (UTC)
BASE TABLE _security_webviewer_sessions filter_surname text YES Task filter in use: surname
BASE TABLE _security_webviewer_sessions filter_forename text YES Task filter in use: forename
BASE TABLE _security_webviewer_sessions filter_sex varchar(1) YES Task filter in use: sex
BASE TABLE _security_webviewer_sessions filter_task text YES Task filter in use: task type
BASE TABLE _security_webviewer_sessions filter_complete tinyint(1) YES Task filter in use: task complete?
BASE TABLE _security_webviewer_sessions filter_device varchar(255) YES Task filter in use: source device
BASE TABLE _security_webviewer_sessions filter_user varchar(255) YES Task filter in use: adding user
BASE TABLE _security_webviewer_sessions filter_start_datetime_iso8601 varchar(32) YES Task filter in use: start date/time
BASE TABLE _security_webviewer_sessions filter_end_datetime_iso8601 varchar(32) YES Task filter in use: end date/time
BASE TABLE _security_webviewer_sessions filter_text text YES Task filter in use: filter text fields
BASE TABLE _security_webviewer_sessions number_to_view int(11) YES Number of records to view
BASE TABLE _security_webviewer_sessions first_task_to_view int(11) YES First record number to view
BASE TABLE _security_webviewer_sessions filter_idnum1 int(11) YES Task filter in use: ID#1 number
BASE TABLE _security_webviewer_sessions filter_idnum2 int(11) YES Task filter in use: ID#2 number
BASE TABLE _security_webviewer_sessions filter_idnum3 int(11) YES Task filter in use: ID#3 number
BASE TABLE _security_webviewer_sessions filter_idnum4 int(11) YES Task filter in use: ID#4 number
BASE TABLE _security_webviewer_sessions filter_idnum5 int(11) YES Task filter in use: ID#5 number
BASE TABLE _security_webviewer_sessions filter_idnum6 int(11) YES Task filter in use: ID#6 number
BASE TABLE _security_webviewer_sessions filter_idnum7 int(11) YES Task filter in use: ID#7 number
BASE TABLE _security_webviewer_sessions filter_idnum8 int(11) YES Task filter in use: ID#8 number
BASE TABLE _security_webviewer_sessions filter_dob_iso8601 varchar(32) YES Task filter in use: DOB
BASE TABLE _server_storedvars name varchar(255) NO Variable name
BASE TABLE _server_storedvars type varchar(255) NO Variable type ('integer', 'real', 'text')
BASE TABLE _server_storedvars valueInteger int(11) YES Value of an integer variable
BASE TABLE _server_storedvars valueText text YES Value of a text variable
BASE TABLE _server_storedvars valueReal double YES Value of a real (floating-point) variable
BASE TABLE ace3 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE ace3 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE ace3 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE ace3 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE ace3 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE ace3 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE ace3 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE ace3 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE ace3 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE ace3 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE ace3 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE ace3 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE ace3 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE ace3 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE ace3 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE ace3 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE ace3 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE ace3 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE ace3 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE ace3 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE ace3 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE ace3 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE ace3 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE ace3 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE ace3 clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE ace3 clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE ace3 clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE ace3 clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE ace3 clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE ace3 age_at_leaving_full_time_education int(11) YES
BASE TABLE ace3 occupation text YES
BASE TABLE ace3 handedness text YES
BASE TABLE ace3 attn_time1 int(11) YES
BASE TABLE ace3 attn_time2 int(11) YES
BASE TABLE ace3 attn_time3 int(11) YES
BASE TABLE ace3 attn_time4 int(11) YES
BASE TABLE ace3 attn_time5 int(11) YES
BASE TABLE ace3 attn_place1 int(11) YES
BASE TABLE ace3 attn_place2 int(11) YES
BASE TABLE ace3 attn_place3 int(11) YES
BASE TABLE ace3 attn_place4 int(11) YES
BASE TABLE ace3 attn_place5 int(11) YES
BASE TABLE ace3 attn_repeat_word1 int(11) YES
BASE TABLE ace3 attn_repeat_word2 int(11) YES
BASE TABLE ace3 attn_repeat_word3 int(11) YES
BASE TABLE ace3 attn_num_registration_trials int(11) YES
BASE TABLE ace3 attn_serial7_subtraction1 int(11) YES
BASE TABLE ace3 attn_serial7_subtraction2 int(11) YES
BASE TABLE ace3 attn_serial7_subtraction3 int(11) YES
BASE TABLE ace3 attn_serial7_subtraction4 int(11) YES
BASE TABLE ace3 attn_serial7_subtraction5 int(11) YES
BASE TABLE ace3 mem_recall_word1 int(11) YES
BASE TABLE ace3 mem_recall_word2 int(11) YES
BASE TABLE ace3 mem_recall_word3 int(11) YES
BASE TABLE ace3 fluency_letters_score int(11) YES
BASE TABLE ace3 fluency_animals_score int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_1 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_2 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_3 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_4 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_5 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_6 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial1_7 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_1 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_2 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_3 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_4 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_5 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_6 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial2_7 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_1 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_2 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_3 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_4 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_5 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_6 int(11) YES
BASE TABLE ace3 mem_repeat_address_trial3_7 int(11) YES
BASE TABLE ace3 mem_famous1 int(11) YES
BASE TABLE ace3 mem_famous2 int(11) YES
BASE TABLE ace3 mem_famous3 int(11) YES
BASE TABLE ace3 mem_famous4 int(11) YES
BASE TABLE ace3 lang_follow_command_practice int(11) YES
BASE TABLE ace3 lang_follow_command1 int(11) YES
BASE TABLE ace3 lang_follow_command2 int(11) YES
BASE TABLE ace3 lang_follow_command3 int(11) YES
BASE TABLE ace3 lang_write_sentences_point1 int(11) YES
BASE TABLE ace3 lang_write_sentences_point2 int(11) YES
BASE TABLE ace3 lang_repeat_word1 int(11) YES
BASE TABLE ace3 lang_repeat_word2 int(11) YES
BASE TABLE ace3 lang_repeat_word3 int(11) YES
BASE TABLE ace3 lang_repeat_word4 int(11) YES
BASE TABLE ace3 lang_repeat_sentence1 int(11) YES
BASE TABLE ace3 lang_repeat_sentence2 int(11) YES
BASE TABLE ace3 lang_name_picture1 int(11) YES
BASE TABLE ace3 lang_name_picture2 int(11) YES
BASE TABLE ace3 lang_name_picture3 int(11) YES
BASE TABLE ace3 lang_name_picture4 int(11) YES
BASE TABLE ace3 lang_name_picture5 int(11) YES
BASE TABLE ace3 lang_name_picture6 int(11) YES
BASE TABLE ace3 lang_name_picture7 int(11) YES
BASE TABLE ace3 lang_name_picture8 int(11) YES
BASE TABLE ace3 lang_name_picture9 int(11) YES
BASE TABLE ace3 lang_name_picture10 int(11) YES
BASE TABLE ace3 lang_name_picture11 int(11) YES
BASE TABLE ace3 lang_name_picture12 int(11) YES
BASE TABLE ace3 lang_identify_concept1 int(11) YES
BASE TABLE ace3 lang_identify_concept2 int(11) YES
BASE TABLE ace3 lang_identify_concept3 int(11) YES
BASE TABLE ace3 lang_identify_concept4 int(11) YES
BASE TABLE ace3 lang_read_words_aloud int(11) YES
BASE TABLE ace3 vsp_copy_infinity int(11) YES
BASE TABLE ace3 vsp_copy_cube int(11) YES
BASE TABLE ace3 vsp_draw_clock int(11) YES
BASE TABLE ace3 vsp_count_dots1 int(11) YES
BASE TABLE ace3 vsp_count_dots2 int(11) YES
BASE TABLE ace3 vsp_count_dots3 int(11) YES
BASE TABLE ace3 vsp_count_dots4 int(11) YES
BASE TABLE ace3 vsp_identify_letter1 int(11) YES
BASE TABLE ace3 vsp_identify_letter2 int(11) YES
BASE TABLE ace3 vsp_identify_letter3 int(11) YES
BASE TABLE ace3 vsp_identify_letter4 int(11) YES
BASE TABLE ace3 mem_recall_address1 int(11) YES
BASE TABLE ace3 mem_recall_address2 int(11) YES
BASE TABLE ace3 mem_recall_address3 int(11) YES
BASE TABLE ace3 mem_recall_address4 int(11) YES
BASE TABLE ace3 mem_recall_address5 int(11) YES
BASE TABLE ace3 mem_recall_address6 int(11) YES
BASE TABLE ace3 mem_recall_address7 int(11) YES
BASE TABLE ace3 mem_recognize_address1 int(11) YES
BASE TABLE ace3 mem_recognize_address2 int(11) YES
BASE TABLE ace3 mem_recognize_address3 int(11) YES
BASE TABLE ace3 mem_recognize_address4 int(11) YES
BASE TABLE ace3 mem_recognize_address5 int(11) YES
BASE TABLE ace3 picture1_blobid int(11) YES
BASE TABLE ace3 picture1_rotation int(11) YES
BASE TABLE ace3 picture2_blobid int(11) YES
BASE TABLE ace3 picture2_rotation int(11) YES
BASE TABLE ace3 comments text YES
BASE TABLE ace3_SUMMARY_TEMP ace3_pk int(11) NO FK to the source table's _pk field
BASE TABLE ace3_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE ace3_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE ace3_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE ace3_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE ace3_SUMMARY_TEMP total int(11) YES
BASE TABLE ace3_SUMMARY_TEMP attn int(11) YES
BASE TABLE ace3_SUMMARY_TEMP mem int(11) YES
BASE TABLE ace3_SUMMARY_TEMP fluency int(11) YES
BASE TABLE ace3_SUMMARY_TEMP lang int(11) YES
BASE TABLE ace3_SUMMARY_TEMP vsp int(11) YES
BASE TABLE aims _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE aims _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE aims _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE aims _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE aims _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE aims _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE aims _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE aims _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE aims _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE aims _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE aims _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE aims _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE aims _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE aims _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE aims _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE aims _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE aims _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE aims when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE aims id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE aims patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE aims when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE aims when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE aims firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE aims firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE aims clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE aims clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE aims clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE aims clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE aims clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE aims q1 int(11) YES
BASE TABLE aims q2 int(11) YES
BASE TABLE aims q3 int(11) YES
BASE TABLE aims q4 int(11) YES
BASE TABLE aims q5 int(11) YES
BASE TABLE aims q6 int(11) YES
BASE TABLE aims q7 int(11) YES
BASE TABLE aims q8 int(11) YES
BASE TABLE aims q9 int(11) YES
BASE TABLE aims q10 int(11) YES
BASE TABLE aims q11 int(11) YES
BASE TABLE aims q12 int(11) YES
BASE TABLE aims_SUMMARY_TEMP aims_pk int(11) NO FK to the source table's _pk field
BASE TABLE aims_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE aims_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE aims_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE aims_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE aims_SUMMARY_TEMP total int(11) YES
BASE TABLE audit _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE audit _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE audit _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE audit _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE audit _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE audit _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE audit _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE audit _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE audit _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE audit _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE audit _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE audit _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE audit _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE audit _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE audit _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE audit _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE audit _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE audit when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE audit id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE audit patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE audit when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE audit when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE audit firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE audit firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE audit q1 int(11) YES
BASE TABLE audit q2 int(11) YES
BASE TABLE audit q3 int(11) YES
BASE TABLE audit q4 int(11) YES
BASE TABLE audit q5 int(11) YES
BASE TABLE audit q6 int(11) YES
BASE TABLE audit q7 int(11) YES
BASE TABLE audit q8 int(11) YES
BASE TABLE audit q9 int(11) YES
BASE TABLE audit q10 int(11) YES
BASE TABLE audit_SUMMARY_TEMP audit_pk int(11) NO FK to the source table's _pk field
BASE TABLE audit_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE audit_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE audit_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE audit_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE audit_SUMMARY_TEMP total int(11) YES
BASE TABLE bdi _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE bdi _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE bdi _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE bdi _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE bdi _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE bdi _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE bdi _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE bdi _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE bdi _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE bdi _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE bdi _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE bdi _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE bdi _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE bdi _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE bdi _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE bdi _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE bdi _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE bdi when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE bdi id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE bdi patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE bdi when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE bdi when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE bdi firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE bdi firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE bdi bdi_scale text YES Which BDI scale (BDI-I, BDI-IA, BDI-II)?
BASE TABLE bdi q1 int(11) YES
BASE TABLE bdi q2 int(11) YES
BASE TABLE bdi q3 int(11) YES
BASE TABLE bdi q4 int(11) YES
BASE TABLE bdi q5 int(11) YES
BASE TABLE bdi q6 int(11) YES
BASE TABLE bdi q7 int(11) YES
BASE TABLE bdi q8 int(11) YES
BASE TABLE bdi q9 int(11) YES
BASE TABLE bdi q10 int(11) YES
BASE TABLE bdi q11 int(11) YES
BASE TABLE bdi q12 int(11) YES
BASE TABLE bdi q13 int(11) YES
BASE TABLE bdi q14 int(11) YES
BASE TABLE bdi q15 int(11) YES
BASE TABLE bdi q16 int(11) YES
BASE TABLE bdi q17 int(11) YES
BASE TABLE bdi q18 int(11) YES
BASE TABLE bdi q19 int(11) YES
BASE TABLE bdi q20 int(11) YES
BASE TABLE bdi q21 int(11) YES
BASE TABLE bdi_SUMMARY_TEMP bdi_pk int(11) NO FK to the source table's _pk field
BASE TABLE bdi_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE bdi_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE bdi_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE bdi_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE bdi_SUMMARY_TEMP total int(11) YES
BASE TABLE blobs _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE blobs _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE blobs _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE blobs _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE blobs _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE blobs _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE blobs _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE blobs _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE blobs _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE blobs _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE blobs _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE blobs _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE blobs _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE blobs _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE blobs _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE blobs _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE blobs _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE blobs when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE blobs id int(11) NO BLOB (binary large object) primary key on the source tablet device
BASE TABLE blobs tablename text NO Name of the table referring to this BLOB
BASE TABLE blobs tablepk int(11) NO Primary key (id field) of the row referring to this BLOB
BASE TABLE blobs fieldname text NO Field name of the field referring to this BLOB by ID
BASE TABLE blobs filename text YES Filename of the BLOB on the source tablet device (on the source device, BLOBs are stored in files, not in the database)
BASE TABLE blobs theblob longblob YES The BLOB itself, a binary object containing arbitrary information (such as a picture)
BASE TABLE bmi _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE bmi _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE bmi _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE bmi _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE bmi _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE bmi _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE bmi _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE bmi _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE bmi _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE bmi _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE bmi _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE bmi _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE bmi _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE bmi _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE bmi _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE bmi _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE bmi _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE bmi when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE bmi id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE bmi patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE bmi when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE bmi when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE bmi firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE bmi firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE bmi height_m double YES
BASE TABLE bmi mass_kg double YES
BASE TABLE bmi comment text YES
BASE TABLE bmi_SUMMARY_TEMP bmi_pk int(11) NO FK to the source table's _pk field
BASE TABLE bmi_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE bmi_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE bmi_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE bmi_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE bmi_SUMMARY_TEMP bmi double YES
BASE TABLE bprs _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE bprs _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE bprs _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE bprs _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE bprs _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE bprs _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE bprs _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE bprs _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE bprs _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE bprs _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE bprs _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE bprs _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE bprs _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE bprs _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE bprs _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE bprs _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE bprs _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE bprs when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE bprs id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE bprs patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE bprs when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE bprs when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE bprs firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE bprs firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE bprs clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE bprs clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE bprs clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE bprs clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE bprs clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE bprs q1 int(11) YES
BASE TABLE bprs q2 int(11) YES
BASE TABLE bprs q3 int(11) YES
BASE TABLE bprs q4 int(11) YES
BASE TABLE bprs q5 int(11) YES
BASE TABLE bprs q6 int(11) YES
BASE TABLE bprs q7 int(11) YES
BASE TABLE bprs q8 int(11) YES
BASE TABLE bprs q9 int(11) YES
BASE TABLE bprs q10 int(11) YES
BASE TABLE bprs q11 int(11) YES
BASE TABLE bprs q12 int(11) YES
BASE TABLE bprs q13 int(11) YES
BASE TABLE bprs q14 int(11) YES
BASE TABLE bprs q15 int(11) YES
BASE TABLE bprs q16 int(11) YES
BASE TABLE bprs q17 int(11) YES
BASE TABLE bprs q18 int(11) YES
BASE TABLE bprs q19 int(11) YES
BASE TABLE bprs q20 int(11) YES
BASE TABLE bprs_SUMMARY_TEMP bprs_pk int(11) NO FK to the source table's _pk field
BASE TABLE bprs_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE bprs_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE bprs_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE bprs_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE bprs_SUMMARY_TEMP total int(11) YES
BASE TABLE bprse _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE bprse _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE bprse _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE bprse _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE bprse _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE bprse _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE bprse _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE bprse _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE bprse _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE bprse _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE bprse _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE bprse _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE bprse _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE bprse _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE bprse _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE bprse _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE bprse _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE bprse when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE bprse id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE bprse patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE bprse when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE bprse when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE bprse firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE bprse firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE bprse clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE bprse clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE bprse clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE bprse clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE bprse clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE bprse q1 int(11) YES
BASE TABLE bprse q2 int(11) YES
BASE TABLE bprse q3 int(11) YES
BASE TABLE bprse q4 int(11) YES
BASE TABLE bprse q5 int(11) YES
BASE TABLE bprse q6 int(11) YES
BASE TABLE bprse q7 int(11) YES
BASE TABLE bprse q8 int(11) YES
BASE TABLE bprse q9 int(11) YES
BASE TABLE bprse q10 int(11) YES
BASE TABLE bprse q11 int(11) YES
BASE TABLE bprse q12 int(11) YES
BASE TABLE bprse q13 int(11) YES
BASE TABLE bprse q14 int(11) YES
BASE TABLE bprse q15 int(11) YES
BASE TABLE bprse q16 int(11) YES
BASE TABLE bprse q17 int(11) YES
BASE TABLE bprse q18 int(11) YES
BASE TABLE bprse q19 int(11) YES
BASE TABLE bprse q20 int(11) YES
BASE TABLE bprse q21 int(11) YES
BASE TABLE bprse q22 int(11) YES
BASE TABLE bprse q23 int(11) YES
BASE TABLE bprse q24 int(11) YES
BASE TABLE bprse_SUMMARY_TEMP bprse_pk int(11) NO FK to the source table's _pk field
BASE TABLE bprse_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE bprse_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE bprse_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE bprse_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE bprse_SUMMARY_TEMP total int(11) YES
BASE TABLE cage _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE cage _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE cage _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE cage _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE cage _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE cage _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE cage _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE cage _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE cage _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE cage _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE cage _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE cage _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE cage _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE cage _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE cage _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE cage _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE cage _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE cage when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE cage id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE cage patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE cage when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE cage when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE cage firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE cage firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE cage q1 varchar(1) YES
BASE TABLE cage q2 varchar(1) YES
BASE TABLE cage q3 varchar(1) YES
BASE TABLE cage q4 varchar(1) YES
BASE TABLE cage_SUMMARY_TEMP cage_pk int(11) NO FK to the source table's _pk field
BASE TABLE cage_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE cage_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE cage_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE cage_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE cage_SUMMARY_TEMP total int(11) YES
BASE TABLE caps _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE caps _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE caps _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE caps _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE caps _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE caps _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE caps _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE caps _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE caps _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE caps _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE caps _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE caps _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE caps _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE caps _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE caps _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE caps _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE caps _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE caps when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE caps id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE caps patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE caps when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE caps when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE caps firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE caps firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE caps endorse1 int(11) YES
BASE TABLE caps endorse2 int(11) YES
BASE TABLE caps endorse3 int(11) YES
BASE TABLE caps endorse4 int(11) YES
BASE TABLE caps endorse5 int(11) YES
BASE TABLE caps endorse6 int(11) YES
BASE TABLE caps endorse7 int(11) YES
BASE TABLE caps endorse8 int(11) YES
BASE TABLE caps endorse9 int(11) YES
BASE TABLE caps endorse10 int(11) YES
BASE TABLE caps endorse11 int(11) YES
BASE TABLE caps endorse12 int(11) YES
BASE TABLE caps endorse13 int(11) YES
BASE TABLE caps endorse14 int(11) YES
BASE TABLE caps endorse15 int(11) YES
BASE TABLE caps endorse16 int(11) YES
BASE TABLE caps endorse17 int(11) YES
BASE TABLE caps endorse18 int(11) YES
BASE TABLE caps endorse19 int(11) YES
BASE TABLE caps endorse20 int(11) YES
BASE TABLE caps endorse21 int(11) YES
BASE TABLE caps endorse22 int(11) YES
BASE TABLE caps endorse23 int(11) YES
BASE TABLE caps endorse24 int(11) YES
BASE TABLE caps endorse25 int(11) YES
BASE TABLE caps endorse26 int(11) YES
BASE TABLE caps endorse27 int(11) YES
BASE TABLE caps endorse28 int(11) YES
BASE TABLE caps endorse29 int(11) YES
BASE TABLE caps endorse30 int(11) YES
BASE TABLE caps endorse31 int(11) YES
BASE TABLE caps endorse32 int(11) YES
BASE TABLE caps distress1 int(11) YES
BASE TABLE caps distress2 int(11) YES
BASE TABLE caps distress3 int(11) YES
BASE TABLE caps distress4 int(11) YES
BASE TABLE caps distress5 int(11) YES
BASE TABLE caps distress6 int(11) YES
BASE TABLE caps distress7 int(11) YES
BASE TABLE caps distress8 int(11) YES
BASE TABLE caps distress9 int(11) YES
BASE TABLE caps distress10 int(11) YES
BASE TABLE caps distress11 int(11) YES
BASE TABLE caps distress12 int(11) YES
BASE TABLE caps distress13 int(11) YES
BASE TABLE caps distress14 int(11) YES
BASE TABLE caps distress15 int(11) YES
BASE TABLE caps distress16 int(11) YES
BASE TABLE caps distress17 int(11) YES
BASE TABLE caps distress18 int(11) YES
BASE TABLE caps distress19 int(11) YES
BASE TABLE caps distress20 int(11) YES
BASE TABLE caps distress21 int(11) YES
BASE TABLE caps distress22 int(11) YES
BASE TABLE caps distress23 int(11) YES
BASE TABLE caps distress24 int(11) YES
BASE TABLE caps distress25 int(11) YES
BASE TABLE caps distress26 int(11) YES
BASE TABLE caps distress27 int(11) YES
BASE TABLE caps distress28 int(11) YES
BASE TABLE caps distress29 int(11) YES
BASE TABLE caps distress30 int(11) YES
BASE TABLE caps distress31 int(11) YES
BASE TABLE caps distress32 int(11) YES
BASE TABLE caps intrusiveness1 int(11) YES
BASE TABLE caps intrusiveness2 int(11) YES
BASE TABLE caps intrusiveness3 int(11) YES
BASE TABLE caps intrusiveness4 int(11) YES
BASE TABLE caps intrusiveness5 int(11) YES
BASE TABLE caps intrusiveness6 int(11) YES
BASE TABLE caps intrusiveness7 int(11) YES
BASE TABLE caps intrusiveness8 int(11) YES
BASE TABLE caps intrusiveness9 int(11) YES
BASE TABLE caps intrusiveness10 int(11) YES
BASE TABLE caps intrusiveness11 int(11) YES
BASE TABLE caps intrusiveness12 int(11) YES
BASE TABLE caps intrusiveness13 int(11) YES
BASE TABLE caps intrusiveness14 int(11) YES
BASE TABLE caps intrusiveness15 int(11) YES
BASE TABLE caps intrusiveness16 int(11) YES
BASE TABLE caps intrusiveness17 int(11) YES
BASE TABLE caps intrusiveness18 int(11) YES
BASE TABLE caps intrusiveness19 int(11) YES
BASE TABLE caps intrusiveness20 int(11) YES
BASE TABLE caps intrusiveness21 int(11) YES
BASE TABLE caps intrusiveness22 int(11) YES
BASE TABLE caps intrusiveness23 int(11) YES
BASE TABLE caps intrusiveness24 int(11) YES
BASE TABLE caps intrusiveness25 int(11) YES
BASE TABLE caps intrusiveness26 int(11) YES
BASE TABLE caps intrusiveness27 int(11) YES
BASE TABLE caps intrusiveness28 int(11) YES
BASE TABLE caps intrusiveness29 int(11) YES
BASE TABLE caps intrusiveness30 int(11) YES
BASE TABLE caps intrusiveness31 int(11) YES
BASE TABLE caps intrusiveness32 int(11) YES
BASE TABLE caps frequency1 int(11) YES
BASE TABLE caps frequency2 int(11) YES
BASE TABLE caps frequency3 int(11) YES
BASE TABLE caps frequency4 int(11) YES
BASE TABLE caps frequency5 int(11) YES
BASE TABLE caps frequency6 int(11) YES
BASE TABLE caps frequency7 int(11) YES
BASE TABLE caps frequency8 int(11) YES
BASE TABLE caps frequency9 int(11) YES
BASE TABLE caps frequency10 int(11) YES
BASE TABLE caps frequency11 int(11) YES
BASE TABLE caps frequency12 int(11) YES
BASE TABLE caps frequency13 int(11) YES
BASE TABLE caps frequency14 int(11) YES
BASE TABLE caps frequency15 int(11) YES
BASE TABLE caps frequency16 int(11) YES
BASE TABLE caps frequency17 int(11) YES
BASE TABLE caps frequency18 int(11) YES
BASE TABLE caps frequency19 int(11) YES
BASE TABLE caps frequency20 int(11) YES
BASE TABLE caps frequency21 int(11) YES
BASE TABLE caps frequency22 int(11) YES
BASE TABLE caps frequency23 int(11) YES
BASE TABLE caps frequency24 int(11) YES
BASE TABLE caps frequency25 int(11) YES
BASE TABLE caps frequency26 int(11) YES
BASE TABLE caps frequency27 int(11) YES
BASE TABLE caps frequency28 int(11) YES
BASE TABLE caps frequency29 int(11) YES
BASE TABLE caps frequency30 int(11) YES
BASE TABLE caps frequency31 int(11) YES
BASE TABLE caps frequency32 int(11) YES
BASE TABLE caps_SUMMARY_TEMP caps_pk int(11) NO FK to the source table's _pk field
BASE TABLE caps_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE caps_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE caps_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE caps_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE caps_SUMMARY_TEMP total int(11) YES
BASE TABLE caps_SUMMARY_TEMP distress int(11) YES
BASE TABLE caps_SUMMARY_TEMP intrusiveness int(11) YES
BASE TABLE caps_SUMMARY_TEMP frequency int(11) YES
BASE TABLE cecaq3 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE cecaq3 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE cecaq3 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE cecaq3 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE cecaq3 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE cecaq3 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE cecaq3 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE cecaq3 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE cecaq3 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE cecaq3 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE cecaq3 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE cecaq3 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE cecaq3 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE cecaq3 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE cecaq3 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE cecaq3 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE cecaq3 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE cecaq3 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE cecaq3 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE cecaq3 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE cecaq3 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE cecaq3 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE cecaq3 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE cecaq3 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE cecaq3 s1a_motherfigure_birthmother tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_stepmother tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_femalerelative tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_femalerelative_detail text YES
BASE TABLE cecaq3 s1a_motherfigure_familyfriend tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_fostermother tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_adoptivemother tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_other tinyint(1) YES
BASE TABLE cecaq3 s1a_motherfigure_other_detail text YES
BASE TABLE cecaq3 s1a_fatherfigure_birthfather tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_stepfather tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_malerelative tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_malerelative_detail text YES
BASE TABLE cecaq3 s1a_fatherfigure_familyfriend tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_fosterfather tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_adoptivefather tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_other tinyint(1) YES
BASE TABLE cecaq3 s1a_fatherfigure_other_detail text YES
BASE TABLE cecaq3 s1b_institution tinyint(1) YES
BASE TABLE cecaq3 s1b_institution_time_years double YES
BASE TABLE cecaq3 s1c_mother_died tinyint(1) YES
BASE TABLE cecaq3 s1c_father_died tinyint(1) YES
BASE TABLE cecaq3 s1c_mother_died_subject_aged double YES
BASE TABLE cecaq3 s1c_father_died_subject_aged double YES
BASE TABLE cecaq3 s1c_separated_from_mother tinyint(1) YES
BASE TABLE cecaq3 s1c_separated_from_father tinyint(1) YES
BASE TABLE cecaq3 s1c_first_separated_from_mother_aged double YES
BASE TABLE cecaq3 s1c_first_separated_from_father_aged double YES
BASE TABLE cecaq3 s1c_mother_how_long_first_separation_years double YES
BASE TABLE cecaq3 s1c_father_how_long_first_separation_years double YES
BASE TABLE cecaq3 s1c_mother_separation_reason int(11) YES
BASE TABLE cecaq3 s1c_father_separation_reason int(11) YES
BASE TABLE cecaq3 s1c_describe_experience text YES
BASE TABLE cecaq3 s2a_which_mother_figure int(11) YES
BASE TABLE cecaq3 s2a_which_mother_figure_other_detail text YES
BASE TABLE cecaq3 s2a_q1 int(11) YES
BASE TABLE cecaq3 s2a_q2 int(11) YES
BASE TABLE cecaq3 s2a_q3 int(11) YES
BASE TABLE cecaq3 s2a_q4 int(11) YES
BASE TABLE cecaq3 s2a_q5 int(11) YES
BASE TABLE cecaq3 s2a_q6 int(11) YES
BASE TABLE cecaq3 s2a_q7 int(11) YES
BASE TABLE cecaq3 s2a_q8 int(11) YES
BASE TABLE cecaq3 s2a_q9 int(11) YES
BASE TABLE cecaq3 s2a_q10 int(11) YES
BASE TABLE cecaq3 s2a_q11 int(11) YES
BASE TABLE cecaq3 s2a_q12 int(11) YES
BASE TABLE cecaq3 s2a_q13 int(11) YES
BASE TABLE cecaq3 s2a_q14 int(11) YES
BASE TABLE cecaq3 s2a_q15 int(11) YES
BASE TABLE cecaq3 s2a_q16 int(11) YES
BASE TABLE cecaq3 s2a_extra text YES
BASE TABLE cecaq3 s2b_q1 int(11) YES
BASE TABLE cecaq3 s2b_q2 int(11) YES
BASE TABLE cecaq3 s2b_q3 int(11) YES
BASE TABLE cecaq3 s2b_q4 int(11) YES
BASE TABLE cecaq3 s2b_q5 int(11) YES
BASE TABLE cecaq3 s2b_q6 int(11) YES
BASE TABLE cecaq3 s2b_q7 int(11) YES
BASE TABLE cecaq3 s2b_q8 int(11) YES
BASE TABLE cecaq3 s2b_q9 int(11) YES
BASE TABLE cecaq3 s2b_q10 int(11) YES
BASE TABLE cecaq3 s2b_q11 int(11) YES
BASE TABLE cecaq3 s2b_q12 int(11) YES
BASE TABLE cecaq3 s2b_q13 int(11) YES
BASE TABLE cecaq3 s2b_q14 int(11) YES
BASE TABLE cecaq3 s2b_q15 int(11) YES
BASE TABLE cecaq3 s2b_q16 int(11) YES
BASE TABLE cecaq3 s2b_q17 int(11) YES
BASE TABLE cecaq3 s2b_q1_frequency int(11) YES
BASE TABLE cecaq3 s2b_q2_frequency int(11) YES
BASE TABLE cecaq3 s2b_q3_frequency int(11) YES
BASE TABLE cecaq3 s2b_q4_frequency int(11) YES
BASE TABLE cecaq3 s2b_q5_frequency int(11) YES
BASE TABLE cecaq3 s2b_q6_frequency int(11) YES
BASE TABLE cecaq3 s2b_q7_frequency int(11) YES
BASE TABLE cecaq3 s2b_q8_frequency int(11) YES
BASE TABLE cecaq3 s2b_q9_frequency int(11) YES
BASE TABLE cecaq3 s2b_q10_frequency int(11) YES
BASE TABLE cecaq3 s2b_q11_frequency int(11) YES
BASE TABLE cecaq3 s2b_q12_frequency int(11) YES
BASE TABLE cecaq3 s2b_q13_frequency int(11) YES
BASE TABLE cecaq3 s2b_q14_frequency int(11) YES
BASE TABLE cecaq3 s2b_q15_frequency int(11) YES
BASE TABLE cecaq3 s2b_q16_frequency int(11) YES
BASE TABLE cecaq3 s2b_q17_frequency int(11) YES
BASE TABLE cecaq3 s2b_age_began double YES
BASE TABLE cecaq3 s2b_extra text YES
BASE TABLE cecaq3 s3a_which_father_figure int(11) YES
BASE TABLE cecaq3 s3a_which_father_figure_other_detail text YES
BASE TABLE cecaq3 s3a_q1 int(11) YES
BASE TABLE cecaq3 s3a_q2 int(11) YES
BASE TABLE cecaq3 s3a_q3 int(11) YES
BASE TABLE cecaq3 s3a_q4 int(11) YES
BASE TABLE cecaq3 s3a_q5 int(11) YES
BASE TABLE cecaq3 s3a_q6 int(11) YES
BASE TABLE cecaq3 s3a_q7 int(11) YES
BASE TABLE cecaq3 s3a_q8 int(11) YES
BASE TABLE cecaq3 s3a_q9 int(11) YES
BASE TABLE cecaq3 s3a_q10 int(11) YES
BASE TABLE cecaq3 s3a_q11 int(11) YES
BASE TABLE cecaq3 s3a_q12 int(11) YES
BASE TABLE cecaq3 s3a_q13 int(11) YES
BASE TABLE cecaq3 s3a_q14 int(11) YES
BASE TABLE cecaq3 s3a_q15 int(11) YES
BASE TABLE cecaq3 s3a_q16 int(11) YES
BASE TABLE cecaq3 s3a_extra text YES
BASE TABLE cecaq3 s3b_q1 int(11) YES
BASE TABLE cecaq3 s3b_q2 int(11) YES
BASE TABLE cecaq3 s3b_q3 int(11) YES
BASE TABLE cecaq3 s3b_q4 int(11) YES
BASE TABLE cecaq3 s3b_q5 int(11) YES
BASE TABLE cecaq3 s3b_q6 int(11) YES
BASE TABLE cecaq3 s3b_q7 int(11) YES
BASE TABLE cecaq3 s3b_q8 int(11) YES
BASE TABLE cecaq3 s3b_q9 int(11) YES
BASE TABLE cecaq3 s3b_q10 int(11) YES
BASE TABLE cecaq3 s3b_q11 int(11) YES
BASE TABLE cecaq3 s3b_q12 int(11) YES
BASE TABLE cecaq3 s3b_q13 int(11) YES
BASE TABLE cecaq3 s3b_q14 int(11) YES
BASE TABLE cecaq3 s3b_q15 int(11) YES
BASE TABLE cecaq3 s3b_q16 int(11) YES
BASE TABLE cecaq3 s3b_q17 int(11) YES
BASE TABLE cecaq3 s3b_q1_frequency int(11) YES
BASE TABLE cecaq3 s3b_q2_frequency int(11) YES
BASE TABLE cecaq3 s3b_q3_frequency int(11) YES
BASE TABLE cecaq3 s3b_q4_frequency int(11) YES
BASE TABLE cecaq3 s3b_q5_frequency int(11) YES
BASE TABLE cecaq3 s3b_q6_frequency int(11) YES
BASE TABLE cecaq3 s3b_q7_frequency int(11) YES
BASE TABLE cecaq3 s3b_q8_frequency int(11) YES
BASE TABLE cecaq3 s3b_q9_frequency int(11) YES
BASE TABLE cecaq3 s3b_q10_frequency int(11) YES
BASE TABLE cecaq3 s3b_q11_frequency int(11) YES
BASE TABLE cecaq3 s3b_q12_frequency int(11) YES
BASE TABLE cecaq3 s3b_q13_frequency int(11) YES
BASE TABLE cecaq3 s3b_q14_frequency int(11) YES
BASE TABLE cecaq3 s3b_q15_frequency int(11) YES
BASE TABLE cecaq3 s3b_q16_frequency int(11) YES
BASE TABLE cecaq3 s3b_q17_frequency int(11) YES
BASE TABLE cecaq3 s3b_age_began double YES
BASE TABLE cecaq3 s3b_extra text YES
BASE TABLE cecaq3 s3c_q1 int(11) YES
BASE TABLE cecaq3 s3c_q2 int(11) YES
BASE TABLE cecaq3 s3c_q3 int(11) YES
BASE TABLE cecaq3 s3c_q4 int(11) YES
BASE TABLE cecaq3 s3c_q5 int(11) YES
BASE TABLE cecaq3 s3c_q6 int(11) YES
BASE TABLE cecaq3 s3c_q7 int(11) YES
BASE TABLE cecaq3 s3c_q8 int(11) YES
BASE TABLE cecaq3 s3c_q9 int(11) YES
BASE TABLE cecaq3 s3c_q10 int(11) YES
BASE TABLE cecaq3 s3c_q11 int(11) YES
BASE TABLE cecaq3 s3c_q12 int(11) YES
BASE TABLE cecaq3 s3c_q13 int(11) YES
BASE TABLE cecaq3 s3c_q14 int(11) YES
BASE TABLE cecaq3 s3c_q15 int(11) YES
BASE TABLE cecaq3 s3c_q16 int(11) YES
BASE TABLE cecaq3 s3c_q17 int(11) YES
BASE TABLE cecaq3 s3c_which_parent_cared_for int(11) YES
BASE TABLE cecaq3 s3c_parent_mental_problem int(11) YES
BASE TABLE cecaq3 s3c_parent_physical_problem int(11) YES
BASE TABLE cecaq3 s4a_adultconfidant tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_mother tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_father tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_otherrelative tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_familyfriend tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_responsibleadult tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_other tinyint(1) YES
BASE TABLE cecaq3 s4a_adultconfidant_other_detail text YES
BASE TABLE cecaq3 s4a_adultconfidant_additional text YES
BASE TABLE cecaq3 s4b_childconfidant tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_sister tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_brother tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_otherrelative tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_closefriend tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_otherfriend tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_other tinyint(1) YES
BASE TABLE cecaq3 s4b_childconfidant_other_detail text YES
BASE TABLE cecaq3 s4b_childconfidant_additional text YES
BASE TABLE cecaq3 s4c_closest_mother tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_father tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_sibling tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_otherrelative tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_adultfriend tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_childfriend tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_other tinyint(1) YES
BASE TABLE cecaq3 s4c_closest_other_detail text YES
BASE TABLE cecaq3 s4c_closest_additional text YES
BASE TABLE cecaq3 s5c_physicalabuse tinyint(1) YES
BASE TABLE cecaq3 s5c_abused_by_mother tinyint(1) YES
BASE TABLE cecaq3 s5c_abused_by_father tinyint(1) YES
BASE TABLE cecaq3 s5c_mother_abuse_age_began double YES
BASE TABLE cecaq3 s5c_father_abuse_age_began double YES
BASE TABLE cecaq3 s5c_mother_hit_more_than_once tinyint(1) YES
BASE TABLE cecaq3 s5c_father_hit_more_than_once tinyint(1) YES
BASE TABLE cecaq3 s5c_mother_hit_how int(11) YES
BASE TABLE cecaq3 s5c_father_hit_how int(11) YES
BASE TABLE cecaq3 s5c_mother_injured tinyint(1) YES
BASE TABLE cecaq3 s5c_father_injured tinyint(1) YES
BASE TABLE cecaq3 s5c_mother_out_of_control tinyint(1) YES
BASE TABLE cecaq3 s5c_father_out_of_control tinyint(1) YES
BASE TABLE cecaq3 s5c_parental_abuse_description text YES
BASE TABLE cecaq3 s5c_abuse_by_nonparent tinyint(1) YES
BASE TABLE cecaq3 s5c_nonparent_abuse_description text YES
BASE TABLE cecaq3 s6_any_unwanted_sexual_experience tinyint(1) YES
BASE TABLE cecaq3 s6_unwanted_intercourse tinyint(1) YES
BASE TABLE cecaq3 s6_upsetting_sexual_adult_authority tinyint(1) YES
BASE TABLE cecaq3 s6_first_age double YES
BASE TABLE cecaq3 s6_other_age double YES
BASE TABLE cecaq3 s6_first_person_known tinyint(1) YES
BASE TABLE cecaq3 s6_other_person_known tinyint(1) YES
BASE TABLE cecaq3 s6_first_relative tinyint(1) YES
BASE TABLE cecaq3 s6_other_relative tinyint(1) YES
BASE TABLE cecaq3 s6_first_in_household tinyint(1) YES
BASE TABLE cecaq3 s6_other_in_household tinyint(1) YES
BASE TABLE cecaq3 s6_first_more_than_once tinyint(1) YES
BASE TABLE cecaq3 s6_other_more_than_once tinyint(1) YES
BASE TABLE cecaq3 s6_first_touch_privates_subject tinyint(1) YES
BASE TABLE cecaq3 s6_other_touch_privates_subject tinyint(1) YES
BASE TABLE cecaq3 s6_first_touch_privates_other tinyint(1) YES
BASE TABLE cecaq3 s6_other_touch_privates_other tinyint(1) YES
BASE TABLE cecaq3 s6_first_intercourse tinyint(1) YES
BASE TABLE cecaq3 s6_other_intercourse tinyint(1) YES
BASE TABLE cecaq3 s6_unwanted_sexual_description text YES
BASE TABLE cecaq3 any_other_comments text YES
BASE TABLE cecaq3_SUMMARY_TEMP cecaq3_pk int(11) NO FK to the source table's _pk field
BASE TABLE cecaq3_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE cecaq3_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE cecaq3_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE cecaq3_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE cecaq3_SUMMARY_TEMP parental_loss_risk int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP parental_loss_high_risk int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP mother_antipathy int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP mother_neglect int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP mother_psychological_abuse int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP father_antipathy int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP father_neglect int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP father_psychological_abuse int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP role_reversal int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP physical_abuse_screen int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP physical_abuse_severity_mother int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP physical_abuse_severity_father int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP sexual_abuse_screen int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP sexual_abuse_score_first int(11) YES
BASE TABLE cecaq3_SUMMARY_TEMP sexual_abuse_score_other int(11) YES
BASE TABLE cgi _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE cgi _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE cgi _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE cgi _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE cgi _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE cgi _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE cgi _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE cgi _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE cgi _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE cgi _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE cgi _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE cgi _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE cgi _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE cgi _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE cgi _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE cgi _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE cgi _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE cgi when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE cgi id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE cgi patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE cgi when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE cgi when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE cgi firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE cgi firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE cgi clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE cgi clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE cgi clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE cgi clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE cgi clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE cgi q1 int(11) YES
BASE TABLE cgi q2 int(11) YES
BASE TABLE cgi q3t int(11) YES
BASE TABLE cgi q3s int(11) YES
BASE TABLE cgi q3 int(11) YES
BASE TABLE cgi_SUMMARY_TEMP cgi_pk int(11) NO FK to the source table's _pk field
BASE TABLE cgi_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE cgi_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE cgi_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE cgi_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE cgi_SUMMARY_TEMP total int(11) YES
BASE TABLE ciwa _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE ciwa _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE ciwa _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE ciwa _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE ciwa _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE ciwa _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE ciwa _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE ciwa _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE ciwa _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE ciwa _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE ciwa _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE ciwa _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE ciwa _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE ciwa _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE ciwa _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE ciwa _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE ciwa _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE ciwa when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE ciwa id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE ciwa patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE ciwa when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE ciwa when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE ciwa firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE ciwa firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE ciwa clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE ciwa clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE ciwa clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE ciwa clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE ciwa clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE ciwa q1 int(11) YES
BASE TABLE ciwa q2 int(11) YES
BASE TABLE ciwa q3 int(11) YES
BASE TABLE ciwa q4 int(11) YES
BASE TABLE ciwa q5 int(11) YES
BASE TABLE ciwa q6 int(11) YES
BASE TABLE ciwa q7 int(11) YES
BASE TABLE ciwa q8 int(11) YES
BASE TABLE ciwa q9 int(11) YES
BASE TABLE ciwa q10 int(11) YES
BASE TABLE ciwa t int(11) YES
BASE TABLE ciwa hr int(11) YES
BASE TABLE ciwa sbp int(11) YES
BASE TABLE ciwa dbp int(11) YES
BASE TABLE ciwa rr int(11) YES
BASE TABLE ciwa_SUMMARY_TEMP ciwa_pk int(11) NO FK to the source table's _pk field
BASE TABLE ciwa_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE ciwa_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE ciwa_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE ciwa_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE ciwa_SUMMARY_TEMP total int(11) YES
BASE TABLE ciwa_SUMMARY_TEMP severity text YES
BASE TABLE contactlog _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE contactlog _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE contactlog _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE contactlog _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE contactlog _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE contactlog _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE contactlog _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE contactlog _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE contactlog _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE contactlog _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE contactlog _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE contactlog _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE contactlog _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE contactlog _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE contactlog _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE contactlog _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE contactlog _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE contactlog when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE contactlog id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE contactlog patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE contactlog when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE contactlog when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE contactlog firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE contactlog firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE contactlog clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE contactlog clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE contactlog clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE contactlog clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE contactlog clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE contactlog location text YES Location
BASE TABLE contactlog start text YES Date/time that contact started
BASE TABLE contactlog end text YES Date/time that contact ended
BASE TABLE contactlog patient_contact int(11) YES Patient contact involved (1)?
BASE TABLE contactlog staff_liaison int(11) YES Liaison with staff involved (1)?
BASE TABLE contactlog other_liaison int(11) YES Liaison with others (e.g. family) involved (1)?
BASE TABLE contactlog comment text YES Comment
BASE TABLE dast _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE dast _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE dast _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE dast _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE dast _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE dast _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE dast _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE dast _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE dast _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE dast _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE dast _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE dast _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE dast _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE dast _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE dast _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE dast _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE dast _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE dast when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE dast id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE dast patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE dast when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE dast when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE dast firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE dast firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE dast q1 varchar(1) YES
BASE TABLE dast q2 varchar(1) YES
BASE TABLE dast q3 varchar(1) YES
BASE TABLE dast q4 varchar(1) YES
BASE TABLE dast q5 varchar(1) YES
BASE TABLE dast q6 varchar(1) YES
BASE TABLE dast q7 varchar(1) YES
BASE TABLE dast q8 varchar(1) YES
BASE TABLE dast q9 varchar(1) YES
BASE TABLE dast q10 varchar(1) YES
BASE TABLE dast q11 varchar(1) YES
BASE TABLE dast q12 varchar(1) YES
BASE TABLE dast q13 varchar(1) YES
BASE TABLE dast q14 varchar(1) YES
BASE TABLE dast q15 varchar(1) YES
BASE TABLE dast q16 varchar(1) YES
BASE TABLE dast q17 varchar(1) YES
BASE TABLE dast q18 varchar(1) YES
BASE TABLE dast q19 varchar(1) YES
BASE TABLE dast q20 varchar(1) YES
BASE TABLE dast q21 varchar(1) YES
BASE TABLE dast q22 varchar(1) YES
BASE TABLE dast q23 varchar(1) YES
BASE TABLE dast q24 varchar(1) YES
BASE TABLE dast q25 varchar(1) YES
BASE TABLE dast q26 varchar(1) YES
BASE TABLE dast q27 varchar(1) YES
BASE TABLE dast q28 varchar(1) YES
BASE TABLE dast_SUMMARY_TEMP dast_pk int(11) NO FK to the source table's _pk field
BASE TABLE dast_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE dast_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE dast_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE dast_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE dast_SUMMARY_TEMP total int(11) YES
BASE TABLE deakin_1_healthreview _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE deakin_1_healthreview _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE deakin_1_healthreview _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE deakin_1_healthreview _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE deakin_1_healthreview _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE deakin_1_healthreview _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE deakin_1_healthreview _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE deakin_1_healthreview _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE deakin_1_healthreview _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE deakin_1_healthreview _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE deakin_1_healthreview _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE deakin_1_healthreview _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE deakin_1_healthreview _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE deakin_1_healthreview _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE deakin_1_healthreview _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE deakin_1_healthreview _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE deakin_1_healthreview _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE deakin_1_healthreview when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE deakin_1_healthreview id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE deakin_1_healthreview patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE deakin_1_healthreview when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE deakin_1_healthreview when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE deakin_1_healthreview firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE deakin_1_healthreview firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE deakin_1_healthreview ethnicity int(11) YES
BASE TABLE deakin_1_healthreview ethnicity_text text YES
BASE TABLE deakin_1_healthreview ethnicity_other_details text YES
BASE TABLE deakin_1_healthreview handedness text YES
BASE TABLE deakin_1_healthreview education text YES
BASE TABLE deakin_1_healthreview allergies tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_asthma tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_pollen_dust tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_dermatitis tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_food tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_dander tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_other tinyint(1) YES
BASE TABLE deakin_1_healthreview allergy_details text YES
BASE TABLE deakin_1_healthreview vaccinations_last3months tinyint(1) YES
BASE TABLE deakin_1_healthreview vaccination_details text YES
BASE TABLE deakin_1_healthreview infections_last3months tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_respiratory tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_gastroenteritis tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_urinary tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_sexual tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_hepatitis tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_other tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_recent_details text YES
BASE TABLE deakin_1_healthreview infections_chronic tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_respiratory tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_gastroenteritis tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_urinary tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_sexual tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_hepatitis tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_other tinyint(1) YES
BASE TABLE deakin_1_healthreview infection_chronic_details text YES
BASE TABLE deakin_1_healthreview immune_disorders tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_ms tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_sle tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_arthritis tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_hiv tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_graves tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_diabetes tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_other tinyint(1) YES
BASE TABLE deakin_1_healthreview immunity_details text YES
BASE TABLE deakin_1_healthreview family_history tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_ms tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_sle tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_arthritis tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_graves tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_diabetes tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_psychosis_sz tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_bipolar tinyint(1) YES
BASE TABLE deakin_1_healthreview familyhistory_details text YES
BASE TABLE deakin_1_healthreview health_anything_else tinyint(1) YES
BASE TABLE deakin_1_healthreview health_anything_else_details text YES
BASE TABLE deakin_1_healthreview drug_history text YES
BASE TABLE deakin_1_healthreview first_antipsychotic_medication text YES
BASE TABLE deakin_1_healthreview recreational_drug_in_last_3_months tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_tobacco_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_tobacco_cigsperweek int(11) YES
BASE TABLE deakin_1_healthreview recdrug_tobacco_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_cannabis_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_cannabis_jointsperweek int(11) YES
BASE TABLE deakin_1_healthreview recdrug_cannabis_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_alcohol_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_alcohol_unitsperweek int(11) YES
BASE TABLE deakin_1_healthreview recdrug_alcohol_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_mdma_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_mdma_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_cocaine_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_cocaine_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_crack_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_crack_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_heroin_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_heroin_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_methadone_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_methadone_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_amphetamines_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_amphetamines_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_benzodiazepines_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_benzodiazepines_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_ketamine_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_ketamine_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_legalhighs_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_legalhighs_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_inhalants_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_inhalants_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_hallucinogens_frequency int(11) YES
BASE TABLE deakin_1_healthreview recdrug_hallucinogens_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_details text YES
BASE TABLE deakin_1_healthreview recdrug_prevheavy tinyint(1) YES
BASE TABLE deakin_1_healthreview recdrug_prevheavy_details text YES
BASE TABLE deakin_1_healthreview mri_claustrophobic tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_difficulty_lying_1_hour tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_nonremovable_metal tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_metal_from_operations tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_tattoos_nicotine_patches tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_worked_with_metal tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_previous_brain_scan tinyint(1) YES
BASE TABLE deakin_1_healthreview mri_previous_brain_scan_details text YES
BASE TABLE deakin_1_healthreview other_relevant_things tinyint(1) YES
BASE TABLE deakin_1_healthreview other_relevant_things_details text YES
BASE TABLE deakin_1_healthreview willing_to_participate_in_further_studies tinyint(1) YES
BASE TABLE demoquestionnaire _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE demoquestionnaire _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE demoquestionnaire _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE demoquestionnaire _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE demoquestionnaire _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE demoquestionnaire _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE demoquestionnaire _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE demoquestionnaire _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE demoquestionnaire _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE demoquestionnaire _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE demoquestionnaire _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE demoquestionnaire _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE demoquestionnaire _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE demoquestionnaire _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE demoquestionnaire _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE demoquestionnaire _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE demoquestionnaire _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE demoquestionnaire when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE demoquestionnaire id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE demoquestionnaire when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE demoquestionnaire when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE demoquestionnaire firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE demoquestionnaire firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE demoquestionnaire mcq1 int(11) YES
BASE TABLE demoquestionnaire mcq2 int(11) YES
BASE TABLE demoquestionnaire mcq3 int(11) YES
BASE TABLE demoquestionnaire mcq4 int(11) YES
BASE TABLE demoquestionnaire mcq5 int(11) YES
BASE TABLE demoquestionnaire mcq6 int(11) YES
BASE TABLE demoquestionnaire mcq7 int(11) YES
BASE TABLE demoquestionnaire mcq8 int(11) YES
BASE TABLE demoquestionnaire mcqbool1 int(11) YES
BASE TABLE demoquestionnaire mcqbool2 int(11) YES
BASE TABLE demoquestionnaire mcqbool3 int(11) YES
BASE TABLE demoquestionnaire multipleresponse1 int(11) YES
BASE TABLE demoquestionnaire multipleresponse2 int(11) YES
BASE TABLE demoquestionnaire multipleresponse3 int(11) YES
BASE TABLE demoquestionnaire multipleresponse4 int(11) YES
BASE TABLE demoquestionnaire multipleresponse5 int(11) YES
BASE TABLE demoquestionnaire multipleresponse6 int(11) YES
BASE TABLE demoquestionnaire booltext1 int(11) YES
BASE TABLE demoquestionnaire booltext2 int(11) YES
BASE TABLE demoquestionnaire booltext3 int(11) YES
BASE TABLE demoquestionnaire booltext4 int(11) YES
BASE TABLE demoquestionnaire booltext5 int(11) YES
BASE TABLE demoquestionnaire booltext6 int(11) YES
BASE TABLE demoquestionnaire booltext7 int(11) YES
BASE TABLE demoquestionnaire booltext8 int(11) YES
BASE TABLE demoquestionnaire booltext9 int(11) YES
BASE TABLE demoquestionnaire booltext10 int(11) YES
BASE TABLE demoquestionnaire booltext11 int(11) YES
BASE TABLE demoquestionnaire booltext12 int(11) YES
BASE TABLE demoquestionnaire booltext13 int(11) YES
BASE TABLE demoquestionnaire booltext14 int(11) YES
BASE TABLE demoquestionnaire booltext15 int(11) YES
BASE TABLE demoquestionnaire booltext16 int(11) YES
BASE TABLE demoquestionnaire booltext17 int(11) YES
BASE TABLE demoquestionnaire booltext18 int(11) YES
BASE TABLE demoquestionnaire booltext19 int(11) YES
BASE TABLE demoquestionnaire booltext20 int(11) YES
BASE TABLE demoquestionnaire booltext21 int(11) YES
BASE TABLE demoquestionnaire slider1 double YES
BASE TABLE demoquestionnaire slider2 double YES
BASE TABLE demoquestionnaire mcqtext_1a text YES
BASE TABLE demoquestionnaire mcqtext_1b text YES
BASE TABLE demoquestionnaire mcqtext_2a text YES
BASE TABLE demoquestionnaire mcqtext_2b text YES
BASE TABLE demoquestionnaire mcqtext_3a text YES
BASE TABLE demoquestionnaire mcqtext_3b text YES
BASE TABLE demoquestionnaire boolimage int(11) YES
BASE TABLE demoquestionnaire typedvar_text text YES
BASE TABLE demoquestionnaire typedvar_text_multiline text YES
BASE TABLE demoquestionnaire typedvar_int int(11) YES
BASE TABLE demoquestionnaire typedvar_real double YES
BASE TABLE demoquestionnaire date_only varchar(32) YES
BASE TABLE demoquestionnaire date_time varchar(32) YES
BASE TABLE demoquestionnaire thermometer int(11) YES
BASE TABLE demoquestionnaire diagnosticcode_code text YES
BASE TABLE demoquestionnaire diagnosticcode_description text YES
BASE TABLE demoquestionnaire photo_blobid int(11) YES
BASE TABLE demoquestionnaire photo_rotation int(11) YES
BASE TABLE demoquestionnaire canvas_blobid int(11) YES
BASE TABLE demoquestionnaire booltext22 int(11) YES
BASE TABLE demoquestionnaire boolimage1 int(11) YES
BASE TABLE demoquestionnaire boolimage2 int(11) YES
BASE TABLE demoquestionnaire picker1 int(11) YES
BASE TABLE demoquestionnaire picker2 int(11) YES
BASE TABLE diagnosis_icd10 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE diagnosis_icd10 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE diagnosis_icd10 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE diagnosis_icd10 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE diagnosis_icd10 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE diagnosis_icd10 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE diagnosis_icd10 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE diagnosis_icd10 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE diagnosis_icd10 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE diagnosis_icd10 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE diagnosis_icd10 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE diagnosis_icd10 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE diagnosis_icd10 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE diagnosis_icd10 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE diagnosis_icd10 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE diagnosis_icd10 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE diagnosis_icd10 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE diagnosis_icd10 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE diagnosis_icd10 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE diagnosis_icd10 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE diagnosis_icd10 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE diagnosis_icd10 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE diagnosis_icd10 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE diagnosis_icd10 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE diagnosis_icd10 clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE diagnosis_icd10 clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE diagnosis_icd10 clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE diagnosis_icd10 clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE diagnosis_icd10 clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE diagnosis_icd10_item _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE diagnosis_icd10_item _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE diagnosis_icd10_item _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE diagnosis_icd10_item _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE diagnosis_icd10_item _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE diagnosis_icd10_item _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE diagnosis_icd10_item _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE diagnosis_icd10_item _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE diagnosis_icd10_item _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE diagnosis_icd10_item _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE diagnosis_icd10_item _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE diagnosis_icd10_item _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE diagnosis_icd10_item _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE diagnosis_icd10_item _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE diagnosis_icd10_item _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE diagnosis_icd10_item _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE diagnosis_icd10_item _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE diagnosis_icd10_item when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE diagnosis_icd10_item id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE diagnosis_icd10_item diagnosis_icd10_id int(11) NO
BASE TABLE diagnosis_icd10_item seqnum int(11) NO
BASE TABLE diagnosis_icd10_item code text YES Diagnostic code
BASE TABLE diagnosis_icd10_item description text YES Description of the diagnostic code
BASE TABLE diagnosis_icd9cm _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE diagnosis_icd9cm _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE diagnosis_icd9cm _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE diagnosis_icd9cm _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE diagnosis_icd9cm _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE diagnosis_icd9cm _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE diagnosis_icd9cm _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE diagnosis_icd9cm _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE diagnosis_icd9cm _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE diagnosis_icd9cm _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE diagnosis_icd9cm _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE diagnosis_icd9cm _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE diagnosis_icd9cm _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE diagnosis_icd9cm _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE diagnosis_icd9cm _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE diagnosis_icd9cm _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE diagnosis_icd9cm _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE diagnosis_icd9cm when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE diagnosis_icd9cm id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE diagnosis_icd9cm patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE diagnosis_icd9cm when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE diagnosis_icd9cm when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE diagnosis_icd9cm firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE diagnosis_icd9cm firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE diagnosis_icd9cm clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE diagnosis_icd9cm clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE diagnosis_icd9cm clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE diagnosis_icd9cm clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE diagnosis_icd9cm clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE diagnosis_icd9cm_item _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE diagnosis_icd9cm_item _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE diagnosis_icd9cm_item _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE diagnosis_icd9cm_item _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE diagnosis_icd9cm_item _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE diagnosis_icd9cm_item _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE diagnosis_icd9cm_item _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE diagnosis_icd9cm_item _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE diagnosis_icd9cm_item _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE diagnosis_icd9cm_item _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE diagnosis_icd9cm_item _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE diagnosis_icd9cm_item _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE diagnosis_icd9cm_item _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE diagnosis_icd9cm_item _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE diagnosis_icd9cm_item _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE diagnosis_icd9cm_item _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE diagnosis_icd9cm_item _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE diagnosis_icd9cm_item when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE diagnosis_icd9cm_item id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE diagnosis_icd9cm_item diagnosis_icd9cm_id int(11) NO
BASE TABLE diagnosis_icd9cm_item seqnum int(11) NO
BASE TABLE diagnosis_icd9cm_item code text YES Diagnostic code
BASE TABLE diagnosis_icd9cm_item description text YES Description of the diagnostic code
BASE TABLE distressthermometer _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE distressthermometer _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE distressthermometer _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE distressthermometer _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE distressthermometer _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE distressthermometer _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE distressthermometer _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE distressthermometer _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE distressthermometer _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE distressthermometer _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE distressthermometer _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE distressthermometer _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE distressthermometer _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE distressthermometer _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE distressthermometer _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE distressthermometer _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE distressthermometer _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE distressthermometer when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE distressthermometer id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE distressthermometer patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE distressthermometer when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE distressthermometer when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE distressthermometer firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE distressthermometer firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE distressthermometer q1 int(11) YES
BASE TABLE distressthermometer q2 int(11) YES
BASE TABLE distressthermometer q3 int(11) YES
BASE TABLE distressthermometer q4 int(11) YES
BASE TABLE distressthermometer q5 int(11) YES
BASE TABLE distressthermometer q6 int(11) YES
BASE TABLE distressthermometer q7 int(11) YES
BASE TABLE distressthermometer q8 int(11) YES
BASE TABLE distressthermometer q9 int(11) YES
BASE TABLE distressthermometer q10 int(11) YES
BASE TABLE distressthermometer q11 int(11) YES
BASE TABLE distressthermometer q12 int(11) YES
BASE TABLE distressthermometer q13 int(11) YES
BASE TABLE distressthermometer q14 int(11) YES
BASE TABLE distressthermometer q15 int(11) YES
BASE TABLE distressthermometer q16 int(11) YES
BASE TABLE distressthermometer q17 int(11) YES
BASE TABLE distressthermometer q18 int(11) YES
BASE TABLE distressthermometer q19 int(11) YES
BASE TABLE distressthermometer q20 int(11) YES
BASE TABLE distressthermometer q21 int(11) YES
BASE TABLE distressthermometer q22 int(11) YES
BASE TABLE distressthermometer q23 int(11) YES
BASE TABLE distressthermometer q24 int(11) YES
BASE TABLE distressthermometer q25 int(11) YES
BASE TABLE distressthermometer q26 int(11) YES
BASE TABLE distressthermometer q27 int(11) YES
BASE TABLE distressthermometer q28 int(11) YES
BASE TABLE distressthermometer q29 int(11) YES
BASE TABLE distressthermometer q30 int(11) YES
BASE TABLE distressthermometer q31 int(11) YES
BASE TABLE distressthermometer q32 int(11) YES
BASE TABLE distressthermometer q33 int(11) YES
BASE TABLE distressthermometer q34 int(11) YES
BASE TABLE distressthermometer q35 int(11) YES
BASE TABLE distressthermometer q36 int(11) YES
BASE TABLE distressthermometer distress int(11) YES
BASE TABLE distressthermometer other text YES
BASE TABLE expdetthreshold _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE expdetthreshold _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE expdetthreshold _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE expdetthreshold _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE expdetthreshold _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE expdetthreshold _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE expdetthreshold _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE expdetthreshold _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE expdetthreshold _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE expdetthreshold _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE expdetthreshold _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE expdetthreshold _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE expdetthreshold _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE expdetthreshold _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE expdetthreshold _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE expdetthreshold _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE expdetthreshold _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE expdetthreshold when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE expdetthreshold id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE expdetthreshold patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE expdetthreshold when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE expdetthreshold when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE expdetthreshold firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE expdetthreshold firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE expdetthreshold modality int(11) YES
BASE TABLE expdetthreshold target_number int(11) YES
BASE TABLE expdetthreshold background_filename text YES
BASE TABLE expdetthreshold target_filename text YES
BASE TABLE expdetthreshold visual_target_duration_s double YES
BASE TABLE expdetthreshold background_intensity double YES
BASE TABLE expdetthreshold start_intensity_min double YES
BASE TABLE expdetthreshold start_intensity_max double YES
BASE TABLE expdetthreshold initial_large_intensity_step double YES
BASE TABLE expdetthreshold main_small_intensity_step double YES
BASE TABLE expdetthreshold num_trials_in_main_sequence int(11) YES
BASE TABLE expdetthreshold p_catch_trial double YES
BASE TABLE expdetthreshold prompt text YES
BASE TABLE expdetthreshold iti_s double YES
BASE TABLE expdetthreshold finished int(11) YES
BASE TABLE expdetthreshold intercept double YES
BASE TABLE expdetthreshold slope double YES
BASE TABLE expdetthreshold k double YES
BASE TABLE expdetthreshold theta double YES
BASE TABLE expdetthreshold_trials _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE expdetthreshold_trials _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE expdetthreshold_trials _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE expdetthreshold_trials _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE expdetthreshold_trials _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE expdetthreshold_trials _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE expdetthreshold_trials _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE expdetthreshold_trials _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE expdetthreshold_trials _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE expdetthreshold_trials _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE expdetthreshold_trials _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE expdetthreshold_trials _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE expdetthreshold_trials _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE expdetthreshold_trials _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE expdetthreshold_trials _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE expdetthreshold_trials _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE expdetthreshold_trials _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE expdetthreshold_trials when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE expdetthreshold_trials id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE expdetthreshold_trials expdetthreshold_id int(11) NO
BASE TABLE expdetthreshold_trials trial int(11) NO
BASE TABLE expdetthreshold_trials trial_ignoring_catch_trials int(11) YES
BASE TABLE expdetthreshold_trials target_presented int(11) YES
BASE TABLE expdetthreshold_trials target_time text YES
BASE TABLE expdetthreshold_trials intensity double YES
BASE TABLE expdetthreshold_trials choice_time text YES
BASE TABLE expdetthreshold_trials responded int(11) YES
BASE TABLE expdetthreshold_trials response_time text YES
BASE TABLE expdetthreshold_trials response_latency_ms int(11) YES
BASE TABLE expdetthreshold_trials yes int(11) YES
BASE TABLE expdetthreshold_trials no int(11) YES
BASE TABLE expdetthreshold_trials caught_out_reset int(11) YES
BASE TABLE expdetthreshold_trials trial_num_in_calculation_sequence int(11) YES
BASE TABLE expectationdetection _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE expectationdetection _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE expectationdetection _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE expectationdetection _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE expectationdetection _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE expectationdetection _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE expectationdetection _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE expectationdetection _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE expectationdetection _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE expectationdetection _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE expectationdetection _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE expectationdetection _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE expectationdetection _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE expectationdetection _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE expectationdetection _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE expectationdetection _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE expectationdetection _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE expectationdetection when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE expectationdetection id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE expectationdetection patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE expectationdetection when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE expectationdetection when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE expectationdetection firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE expectationdetection firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE expectationdetection num_blocks int(11) YES
BASE TABLE expectationdetection stimulus_counterbalancing int(11) YES
BASE TABLE expectationdetection is_detection_response_on_right int(11) YES
BASE TABLE expectationdetection pause_every_n_trials int(11) YES
BASE TABLE expectationdetection cue_duration_s double YES
BASE TABLE expectationdetection visual_cue_intensity double YES
BASE TABLE expectationdetection auditory_cue_intensity double YES
BASE TABLE expectationdetection isi_duration_s double YES
BASE TABLE expectationdetection visual_target_duration_s double YES
BASE TABLE expectationdetection visual_background_intensity double YES
BASE TABLE expectationdetection visual_target_0_intensity double YES
BASE TABLE expectationdetection visual_target_1_intensity double YES
BASE TABLE expectationdetection auditory_background_intensity double YES
BASE TABLE expectationdetection auditory_target_0_intensity double YES
BASE TABLE expectationdetection auditory_target_1_intensity double YES
BASE TABLE expectationdetection iti_min_s double YES
BASE TABLE expectationdetection iti_max_s double YES
BASE TABLE expectationdetection aborted int(11) YES
BASE TABLE expectationdetection finished int(11) YES
BASE TABLE expectationdetection last_trial_completed int(11) YES
BASE TABLE expectationdetection_SUMMARY_TEMP expectationdetection_pk int(11) NO FK to the source table's _pk field
BASE TABLE expectationdetection_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE expectationdetection_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE expectationdetection_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE expectationdetection_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE expectationdetection_SUMMARY_TEMP final_score int(11) YES
BASE TABLE expectationdetection_trialgroupspec _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE expectationdetection_trialgroupspec _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE expectationdetection_trialgroupspec _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE expectationdetection_trialgroupspec _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE expectationdetection_trialgroupspec _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE expectationdetection_trialgroupspec _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE expectationdetection_trialgroupspec _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE expectationdetection_trialgroupspec _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE expectationdetection_trialgroupspec _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE expectationdetection_trialgroupspec _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE expectationdetection_trialgroupspec _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE expectationdetection_trialgroupspec _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE expectationdetection_trialgroupspec _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE expectationdetection_trialgroupspec _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE expectationdetection_trialgroupspec _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE expectationdetection_trialgroupspec _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE expectationdetection_trialgroupspec _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE expectationdetection_trialgroupspec when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE expectationdetection_trialgroupspec id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE expectationdetection_trialgroupspec expectationdetection_id int(11) NO
BASE TABLE expectationdetection_trialgroupspec group_num int(11) NO
BASE TABLE expectationdetection_trialgroupspec cue int(11) YES
BASE TABLE expectationdetection_trialgroupspec target_modality int(11) YES
BASE TABLE expectationdetection_trialgroupspec target_number int(11) YES
BASE TABLE expectationdetection_trialgroupspec n_target int(11) YES
BASE TABLE expectationdetection_trialgroupspec n_no_target int(11) YES
BASE TABLE expectationdetection_trials _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE expectationdetection_trials _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE expectationdetection_trials _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE expectationdetection_trials _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE expectationdetection_trials _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE expectationdetection_trials _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE expectationdetection_trials _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE expectationdetection_trials _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE expectationdetection_trials _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE expectationdetection_trials _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE expectationdetection_trials _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE expectationdetection_trials _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE expectationdetection_trials _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE expectationdetection_trials _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE expectationdetection_trials _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE expectationdetection_trials _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE expectationdetection_trials _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE expectationdetection_trials when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE expectationdetection_trials id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE expectationdetection_trials expectationdetection_id int(11) NO
BASE TABLE expectationdetection_trials trial int(11) NO
BASE TABLE expectationdetection_trials block int(11) YES
BASE TABLE expectationdetection_trials group_num int(11) YES
BASE TABLE expectationdetection_trials cue int(11) YES
BASE TABLE expectationdetection_trials raw_cue_number int(11) YES
BASE TABLE expectationdetection_trials target_modality int(11) YES
BASE TABLE expectationdetection_trials target_number int(11) YES
BASE TABLE expectationdetection_trials target_present int(11) YES
BASE TABLE expectationdetection_trials iti_length_s double YES
BASE TABLE expectationdetection_trials pause_given_before_trial int(11) YES
BASE TABLE expectationdetection_trials pause_start_time text YES
BASE TABLE expectationdetection_trials pause_end_time text YES
BASE TABLE expectationdetection_trials trial_start_time text YES
BASE TABLE expectationdetection_trials cue_start_time text YES
BASE TABLE expectationdetection_trials target_start_time text YES
BASE TABLE expectationdetection_trials detection_start_time text YES
BASE TABLE expectationdetection_trials iti_start_time text YES
BASE TABLE expectationdetection_trials iti_end_time text YES
BASE TABLE expectationdetection_trials trial_end_time text YES
BASE TABLE expectationdetection_trials responded int(11) YES
BASE TABLE expectationdetection_trials response_time text YES
BASE TABLE expectationdetection_trials response_latency_ms int(11) YES
BASE TABLE expectationdetection_trials rating int(11) YES
BASE TABLE expectationdetection_trials correct int(11) YES
BASE TABLE expectationdetection_trials points int(11) YES
BASE TABLE expectationdetection_trials cumulative_points int(11) YES
BASE TABLE fast _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE fast _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE fast _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE fast _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE fast _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE fast _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE fast _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE fast _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE fast _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE fast _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE fast _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE fast _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE fast _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE fast _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE fast _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE fast _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE fast _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE fast when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE fast id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE fast patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE fast when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE fast when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE fast firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE fast firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE fast q1 int(11) YES
BASE TABLE fast q2 int(11) YES
BASE TABLE fast q3 int(11) YES
BASE TABLE fast q4 int(11) YES
BASE TABLE fast_SUMMARY_TEMP fast_pk int(11) NO FK to the source table's _pk field
BASE TABLE fast_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE fast_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE fast_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE fast_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE fast_SUMMARY_TEMP total int(11) YES
BASE TABLE fast_SUMMARY_TEMP positive tinyint(1) YES
BASE TABLE gad7 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE gad7 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE gad7 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE gad7 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE gad7 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE gad7 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE gad7 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE gad7 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE gad7 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE gad7 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE gad7 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE gad7 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE gad7 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE gad7 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE gad7 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE gad7 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE gad7 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE gad7 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE gad7 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE gad7 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE gad7 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE gad7 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE gad7 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE gad7 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE gad7 q1 int(11) YES
BASE TABLE gad7 q2 int(11) YES
BASE TABLE gad7 q3 int(11) YES
BASE TABLE gad7 q4 int(11) YES
BASE TABLE gad7 q5 int(11) YES
BASE TABLE gad7 q6 int(11) YES
BASE TABLE gad7 q7 int(11) YES
BASE TABLE gad7_SUMMARY_TEMP gad7_pk int(11) NO FK to the source table's _pk field
BASE TABLE gad7_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE gad7_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE gad7_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE gad7_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE gad7_SUMMARY_TEMP total int(11) YES
BASE TABLE gad7_SUMMARY_TEMP severity text YES
BASE TABLE gaf _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE gaf _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE gaf _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE gaf _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE gaf _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE gaf _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE gaf _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE gaf _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE gaf _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE gaf _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE gaf _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE gaf _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE gaf _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE gaf _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE gaf _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE gaf _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE gaf _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE gaf when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE gaf id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE gaf patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE gaf when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE gaf when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE gaf firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE gaf firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE gaf score int(11) YES GAF score (1-100 or 0 for insufficient information)
BASE TABLE gaf_SUMMARY_TEMP gaf_pk int(11) NO FK to the source table's _pk field
BASE TABLE gaf_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE gaf_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE gaf_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE gaf_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE gaf_SUMMARY_TEMP total int(11) YES
BASE TABLE gmcpq _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE gmcpq _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE gmcpq _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE gmcpq _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE gmcpq _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE gmcpq _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE gmcpq _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE gmcpq _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE gmcpq _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE gmcpq _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE gmcpq _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE gmcpq _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE gmcpq _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE gmcpq _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE gmcpq _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE gmcpq _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE gmcpq _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE gmcpq when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE gmcpq id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE gmcpq when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE gmcpq when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE gmcpq firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE gmcpq firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE gmcpq doctor text YES
BASE TABLE gmcpq q1 int(11) YES
BASE TABLE gmcpq q2a int(11) YES
BASE TABLE gmcpq q2b int(11) YES
BASE TABLE gmcpq q2c int(11) YES
BASE TABLE gmcpq q2d int(11) YES
BASE TABLE gmcpq q2e int(11) YES
BASE TABLE gmcpq q2f int(11) YES
BASE TABLE gmcpq q2f_details text YES
BASE TABLE gmcpq q3 int(11) YES
BASE TABLE gmcpq q4a int(11) YES
BASE TABLE gmcpq q4b int(11) YES
BASE TABLE gmcpq q4c int(11) YES
BASE TABLE gmcpq q4d int(11) YES
BASE TABLE gmcpq q4e int(11) YES
BASE TABLE gmcpq q4f int(11) YES
BASE TABLE gmcpq q4g int(11) YES
BASE TABLE gmcpq q5a int(11) YES
BASE TABLE gmcpq q5b int(11) YES
BASE TABLE gmcpq q6 int(11) YES
BASE TABLE gmcpq q7 int(11) YES
BASE TABLE gmcpq q8 int(11) YES
BASE TABLE gmcpq q9 text YES
BASE TABLE gmcpq q10 text YES
BASE TABLE gmcpq q11 int(11) YES
BASE TABLE gmcpq q12 int(11) YES
BASE TABLE gmcpq q12_details text YES
BASE TABLE hama _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE hama _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE hama _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE hama _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE hama _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE hama _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE hama _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE hama _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE hama _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE hama _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE hama _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE hama _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE hama _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE hama _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE hama _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE hama _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE hama _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE hama when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE hama id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE hama patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE hama when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE hama when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE hama firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE hama firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE hama clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE hama clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE hama clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE hama clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE hama clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE hama q1 int(11) YES
BASE TABLE hama q2 int(11) YES
BASE TABLE hama q3 int(11) YES
BASE TABLE hama q4 int(11) YES
BASE TABLE hama q5 int(11) YES
BASE TABLE hama q6 int(11) YES
BASE TABLE hama q7 int(11) YES
BASE TABLE hama q8 int(11) YES
BASE TABLE hama q9 int(11) YES
BASE TABLE hama q10 int(11) YES
BASE TABLE hama q11 int(11) YES
BASE TABLE hama q12 int(11) YES
BASE TABLE hama q13 int(11) YES
BASE TABLE hama q14 int(11) YES
BASE TABLE hama_SUMMARY_TEMP hama_pk int(11) NO FK to the source table's _pk field
BASE TABLE hama_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE hama_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE hama_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE hama_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE hama_SUMMARY_TEMP total int(11) YES
BASE TABLE hamd _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE hamd _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE hamd _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE hamd _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE hamd _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE hamd _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE hamd _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE hamd _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE hamd _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE hamd _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE hamd _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE hamd _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE hamd _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE hamd _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE hamd _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE hamd _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE hamd _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE hamd when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE hamd id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE hamd patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE hamd when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE hamd when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE hamd firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE hamd firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE hamd clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE hamd clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE hamd clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE hamd clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE hamd clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE hamd q1 int(11) YES
BASE TABLE hamd q2 int(11) YES
BASE TABLE hamd q3 int(11) YES
BASE TABLE hamd q4 int(11) YES
BASE TABLE hamd q5 int(11) YES
BASE TABLE hamd q6 int(11) YES
BASE TABLE hamd q7 int(11) YES
BASE TABLE hamd q8 int(11) YES
BASE TABLE hamd q9 int(11) YES
BASE TABLE hamd q10 int(11) YES
BASE TABLE hamd q11 int(11) YES
BASE TABLE hamd q12 int(11) YES
BASE TABLE hamd q13 int(11) YES
BASE TABLE hamd q14 int(11) YES
BASE TABLE hamd q15 int(11) YES
BASE TABLE hamd whichq16 int(11) YES
BASE TABLE hamd q16a int(11) YES
BASE TABLE hamd q16b int(11) YES
BASE TABLE hamd q17 int(11) YES
BASE TABLE hamd q18a int(11) YES
BASE TABLE hamd q18b int(11) YES
BASE TABLE hamd q19 int(11) YES
BASE TABLE hamd q20 int(11) YES
BASE TABLE hamd q21 int(11) YES
BASE TABLE hamd7 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE hamd7 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE hamd7 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE hamd7 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE hamd7 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE hamd7 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE hamd7 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE hamd7 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE hamd7 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE hamd7 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE hamd7 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE hamd7 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE hamd7 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE hamd7 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE hamd7 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE hamd7 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE hamd7 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE hamd7 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE hamd7 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE hamd7 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE hamd7 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE hamd7 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE hamd7 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE hamd7 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE hamd7 clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE hamd7 clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE hamd7 clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE hamd7 clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE hamd7 clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE hamd7 q1 int(11) YES
BASE TABLE hamd7 q2 int(11) YES
BASE TABLE hamd7 q3 int(11) YES
BASE TABLE hamd7 q4 int(11) YES
BASE TABLE hamd7 q5 int(11) YES
BASE TABLE hamd7 q6 int(11) YES
BASE TABLE hamd7 q7 int(11) YES
BASE TABLE hamd7_SUMMARY_TEMP hamd7_pk int(11) NO FK to the source table's _pk field
BASE TABLE hamd7_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE hamd7_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE hamd7_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE hamd7_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE hamd7_SUMMARY_TEMP total int(11) YES
BASE TABLE hamd_SUMMARY_TEMP hamd_pk int(11) NO FK to the source table's _pk field
BASE TABLE hamd_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE hamd_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE hamd_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE hamd_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE hamd_SUMMARY_TEMP total int(11) YES
BASE TABLE honos _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE honos _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE honos _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE honos _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE honos _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE honos _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE honos _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE honos _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE honos _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE honos _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE honos _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE honos _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE honos _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE honos _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE honos _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE honos _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE honos _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE honos when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE honos id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE honos patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE honos when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE honos when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE honos firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE honos firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE honos clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE honos clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE honos clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE honos clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE honos clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE honos q1 int(11) YES
BASE TABLE honos q2 int(11) YES
BASE TABLE honos q3 int(11) YES
BASE TABLE honos q4 int(11) YES
BASE TABLE honos q5 int(11) YES
BASE TABLE honos q6 int(11) YES
BASE TABLE honos q7 int(11) YES
BASE TABLE honos q8 int(11) YES
BASE TABLE honos q9 int(11) YES
BASE TABLE honos q10 int(11) YES
BASE TABLE honos q11 int(11) YES
BASE TABLE honos q12 int(11) YES
BASE TABLE honos period_rated text YES
BASE TABLE honos q8problemtype varchar(1) YES
BASE TABLE honos q8otherproblem text YES
BASE TABLE honos65 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE honos65 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE honos65 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE honos65 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE honos65 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE honos65 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE honos65 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE honos65 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE honos65 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE honos65 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE honos65 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE honos65 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE honos65 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE honos65 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE honos65 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE honos65 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE honos65 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE honos65 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE honos65 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE honos65 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE honos65 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE honos65 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE honos65 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE honos65 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE honos65 clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE honos65 clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE honos65 clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE honos65 clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE honos65 clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE honos65 q1 int(11) YES
BASE TABLE honos65 q2 int(11) YES
BASE TABLE honos65 q3 int(11) YES
BASE TABLE honos65 q4 int(11) YES
BASE TABLE honos65 q5 int(11) YES
BASE TABLE honos65 q6 int(11) YES
BASE TABLE honos65 q7 int(11) YES
BASE TABLE honos65 q8 int(11) YES
BASE TABLE honos65 q9 int(11) YES
BASE TABLE honos65 q10 int(11) YES
BASE TABLE honos65 q11 int(11) YES
BASE TABLE honos65 q12 int(11) YES
BASE TABLE honos65 period_rated text YES
BASE TABLE honos65 q8problemtype varchar(1) YES
BASE TABLE honos65 q8otherproblem text YES
BASE TABLE honos65_SUMMARY_TEMP honos65_pk int(11) NO FK to the source table's _pk field
BASE TABLE honos65_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE honos65_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE honos65_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE honos65_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE honos65_SUMMARY_TEMP total int(11) YES
BASE TABLE honos_SUMMARY_TEMP honos_pk int(11) NO FK to the source table's _pk field
BASE TABLE honos_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE honos_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE honos_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE honos_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE honos_SUMMARY_TEMP total int(11) YES
BASE TABLE honosca _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE honosca _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE honosca _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE honosca _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE honosca _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE honosca _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE honosca _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE honosca _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE honosca _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE honosca _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE honosca _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE honosca _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE honosca _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE honosca _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE honosca _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE honosca _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE honosca _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE honosca when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE honosca id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE honosca patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE honosca when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE honosca when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE honosca firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE honosca firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE honosca clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE honosca clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE honosca clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE honosca clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE honosca clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE honosca q1 int(11) YES
BASE TABLE honosca q2 int(11) YES
BASE TABLE honosca q3 int(11) YES
BASE TABLE honosca q4 int(11) YES
BASE TABLE honosca q5 int(11) YES
BASE TABLE honosca q6 int(11) YES
BASE TABLE honosca q7 int(11) YES
BASE TABLE honosca q8 int(11) YES
BASE TABLE honosca q9 int(11) YES
BASE TABLE honosca q10 int(11) YES
BASE TABLE honosca q11 int(11) YES
BASE TABLE honosca q12 int(11) YES
BASE TABLE honosca q13 int(11) YES
BASE TABLE honosca q14 int(11) YES
BASE TABLE honosca q15 int(11) YES
BASE TABLE honosca period_rated text YES
BASE TABLE honosca_SUMMARY_TEMP honosca_pk int(11) NO FK to the source table's _pk field
BASE TABLE honosca_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE honosca_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE honosca_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE honosca_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE honosca_SUMMARY_TEMP total int(11) YES
BASE TABLE icd10depressive _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10depressive _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10depressive _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10depressive _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10depressive _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10depressive _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10depressive _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10depressive _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10depressive _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10depressive _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10depressive _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10depressive _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10depressive _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10depressive _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10depressive _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10depressive _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10depressive _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10depressive when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10depressive id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10depressive patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10depressive when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10depressive when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10depressive firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10depressive firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10depressive clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10depressive clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10depressive clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10depressive clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10depressive clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10depressive date_pertains_to varchar(32) YES
BASE TABLE icd10depressive comments text YES
BASE TABLE icd10depressive duration_at_least_2_weeks tinyint(1) YES
BASE TABLE icd10depressive severe_clinically tinyint(1) YES
BASE TABLE icd10depressive mood tinyint(1) YES
BASE TABLE icd10depressive anhedonia tinyint(1) YES
BASE TABLE icd10depressive energy tinyint(1) YES
BASE TABLE icd10depressive sleep tinyint(1) YES
BASE TABLE icd10depressive worth tinyint(1) YES
BASE TABLE icd10depressive appetite tinyint(1) YES
BASE TABLE icd10depressive guilt tinyint(1) YES
BASE TABLE icd10depressive concentration tinyint(1) YES
BASE TABLE icd10depressive activity tinyint(1) YES
BASE TABLE icd10depressive death tinyint(1) YES
BASE TABLE icd10depressive somatic_anhedonia tinyint(1) YES
BASE TABLE icd10depressive somatic_emotional_unreactivity tinyint(1) YES
BASE TABLE icd10depressive somatic_early_morning_waking tinyint(1) YES
BASE TABLE icd10depressive somatic_mood_worse_morning tinyint(1) YES
BASE TABLE icd10depressive somatic_psychomotor tinyint(1) YES
BASE TABLE icd10depressive somatic_appetite tinyint(1) YES
BASE TABLE icd10depressive somatic_weight tinyint(1) YES
BASE TABLE icd10depressive somatic_libido tinyint(1) YES
BASE TABLE icd10depressive hallucinations_schizophrenic tinyint(1) YES
BASE TABLE icd10depressive hallucinations_other tinyint(1) YES
BASE TABLE icd10depressive delusions_schizophrenic tinyint(1) YES
BASE TABLE icd10depressive delusions_other tinyint(1) YES
BASE TABLE icd10depressive stupor tinyint(1) YES
BASE TABLE icd10manic _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10manic _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10manic _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10manic _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10manic _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10manic _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10manic _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10manic _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10manic _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10manic _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10manic _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10manic _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10manic _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10manic _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10manic _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10manic _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10manic _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10manic when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10manic id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10manic patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10manic when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10manic when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10manic firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10manic firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10manic clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10manic clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10manic clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10manic clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10manic clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10manic date_pertains_to varchar(32) YES
BASE TABLE icd10manic comments text YES
BASE TABLE icd10manic mood_elevated tinyint(1) YES
BASE TABLE icd10manic mood_irritable tinyint(1) YES
BASE TABLE icd10manic distractible tinyint(1) YES
BASE TABLE icd10manic activity tinyint(1) YES
BASE TABLE icd10manic sleep tinyint(1) YES
BASE TABLE icd10manic talkativeness tinyint(1) YES
BASE TABLE icd10manic recklessness tinyint(1) YES
BASE TABLE icd10manic social_disinhibition tinyint(1) YES
BASE TABLE icd10manic sexual tinyint(1) YES
BASE TABLE icd10manic grandiosity tinyint(1) YES
BASE TABLE icd10manic flight_of_ideas tinyint(1) YES
BASE TABLE icd10manic sustained4days tinyint(1) YES
BASE TABLE icd10manic sustained7days tinyint(1) YES
BASE TABLE icd10manic admission_required tinyint(1) YES
BASE TABLE icd10manic some_interference_functioning tinyint(1) YES
BASE TABLE icd10manic severe_interference_functioning tinyint(1) YES
BASE TABLE icd10manic perceptual_alterations tinyint(1) YES
BASE TABLE icd10manic hallucinations_schizophrenic tinyint(1) YES
BASE TABLE icd10manic hallucinations_other tinyint(1) YES
BASE TABLE icd10manic delusions_schizophrenic tinyint(1) YES
BASE TABLE icd10manic delusions_other tinyint(1) YES
BASE TABLE icd10mixed _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10mixed _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10mixed _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10mixed _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10mixed _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10mixed _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10mixed _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10mixed _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10mixed _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10mixed _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10mixed _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10mixed _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10mixed _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10mixed _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10mixed _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10mixed _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10mixed _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10mixed when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10mixed id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10mixed patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10mixed when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10mixed when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10mixed firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10mixed firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10mixed clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10mixed clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10mixed clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10mixed clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10mixed clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10mixed date_pertains_to varchar(32) YES
BASE TABLE icd10mixed comments text YES
BASE TABLE icd10mixed mixture_or_rapid_alternation tinyint(1) YES
BASE TABLE icd10mixed duration_at_least_2_weeks tinyint(1) YES
BASE TABLE icd10schizophrenia _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10schizophrenia _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10schizophrenia _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10schizophrenia _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10schizophrenia _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10schizophrenia _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10schizophrenia _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10schizophrenia _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10schizophrenia _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10schizophrenia _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10schizophrenia _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10schizophrenia _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10schizophrenia _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10schizophrenia _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10schizophrenia _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10schizophrenia _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10schizophrenia _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10schizophrenia when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10schizophrenia id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10schizophrenia patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10schizophrenia when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10schizophrenia when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10schizophrenia firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10schizophrenia firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10schizophrenia clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10schizophrenia clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10schizophrenia clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10schizophrenia clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10schizophrenia clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10schizophrenia date_pertains_to varchar(32) YES
BASE TABLE icd10schizophrenia comments text YES
BASE TABLE icd10schizophrenia passivity_bodily tinyint(1) YES
BASE TABLE icd10schizophrenia passivity_mental tinyint(1) YES
BASE TABLE icd10schizophrenia tpah_commentary tinyint(1) YES
BASE TABLE icd10schizophrenia tpah_discussing tinyint(1) YES
BASE TABLE icd10schizophrenia tpah_from_body tinyint(1) YES
BASE TABLE icd10schizophrenia delusions tinyint(1) YES
BASE TABLE icd10schizophrenia delusional_perception tinyint(1) YES
BASE TABLE icd10schizophrenia thought_echo tinyint(1) YES
BASE TABLE icd10schizophrenia thought_withdrawal tinyint(1) YES
BASE TABLE icd10schizophrenia thought_insertion tinyint(1) YES
BASE TABLE icd10schizophrenia thought_broadcasting tinyint(1) YES
BASE TABLE icd10schizophrenia hallucinations_other tinyint(1) YES
BASE TABLE icd10schizophrenia thought_disorder tinyint(1) YES
BASE TABLE icd10schizophrenia catatonia tinyint(1) YES
BASE TABLE icd10schizophrenia negative tinyint(1) YES
BASE TABLE icd10schizophrenia present_one_month tinyint(1) YES
BASE TABLE icd10schizophrenia also_manic tinyint(1) YES
BASE TABLE icd10schizophrenia also_depressive tinyint(1) YES
BASE TABLE icd10schizophrenia if_mood_psychosis_first tinyint(1) YES
BASE TABLE icd10schizophrenia not_organic_or_substance tinyint(1) YES
BASE TABLE icd10schizophrenia behaviour_change tinyint(1) YES
BASE TABLE icd10schizophrenia performance_decline tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_paranoid tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_hebephrenic tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_catatonic tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_undifferentiated tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_postschizophrenic_depression tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_residual tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_simple tinyint(1) YES
BASE TABLE icd10schizophrenia subtype_cenesthopathic tinyint(1) YES
BASE TABLE icd10schizotypal _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10schizotypal _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10schizotypal _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10schizotypal _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10schizotypal _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10schizotypal _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10schizotypal _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10schizotypal _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10schizotypal _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10schizotypal _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10schizotypal _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10schizotypal _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10schizotypal _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10schizotypal _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10schizotypal _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10schizotypal _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10schizotypal _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10schizotypal when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10schizotypal id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10schizotypal patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10schizotypal when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10schizotypal when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10schizotypal firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10schizotypal firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10schizotypal clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10schizotypal clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10schizotypal clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10schizotypal clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10schizotypal clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10schizotypal date_pertains_to varchar(32) YES
BASE TABLE icd10schizotypal comments text YES
BASE TABLE icd10schizotypal b tinyint(1) YES
BASE TABLE icd10schizotypal a1 tinyint(1) YES
BASE TABLE icd10schizotypal a2 tinyint(1) YES
BASE TABLE icd10schizotypal a3 tinyint(1) YES
BASE TABLE icd10schizotypal a4 tinyint(1) YES
BASE TABLE icd10schizotypal a5 tinyint(1) YES
BASE TABLE icd10schizotypal a6 tinyint(1) YES
BASE TABLE icd10schizotypal a7 tinyint(1) YES
BASE TABLE icd10schizotypal a8 tinyint(1) YES
BASE TABLE icd10schizotypal a9 tinyint(1) YES
BASE TABLE icd10specpd _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE icd10specpd _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE icd10specpd _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE icd10specpd _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE icd10specpd _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE icd10specpd _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE icd10specpd _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE icd10specpd _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE icd10specpd _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE icd10specpd _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE icd10specpd _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE icd10specpd _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE icd10specpd _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE icd10specpd _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE icd10specpd _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE icd10specpd _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE icd10specpd _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE icd10specpd when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE icd10specpd id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE icd10specpd patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE icd10specpd when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE icd10specpd when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE icd10specpd firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE icd10specpd firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE icd10specpd clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE icd10specpd clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE icd10specpd clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE icd10specpd clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE icd10specpd clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE icd10specpd date_pertains_to varchar(32) YES
BASE TABLE icd10specpd comments text YES
BASE TABLE icd10specpd skip_paranoid tinyint(1) YES
BASE TABLE icd10specpd skip_schizoid tinyint(1) YES
BASE TABLE icd10specpd skip_dissocial tinyint(1) YES
BASE TABLE icd10specpd skip_eu tinyint(1) YES
BASE TABLE icd10specpd skip_histrionic tinyint(1) YES
BASE TABLE icd10specpd skip_anankastic tinyint(1) YES
BASE TABLE icd10specpd skip_anxious tinyint(1) YES
BASE TABLE icd10specpd skip_dependent tinyint(1) YES
BASE TABLE icd10specpd vignette text YES
BASE TABLE icd10specpd g1 tinyint(1) YES
BASE TABLE icd10specpd g2 tinyint(1) YES
BASE TABLE icd10specpd g3 tinyint(1) YES
BASE TABLE icd10specpd g4 tinyint(1) YES
BASE TABLE icd10specpd g5 tinyint(1) YES
BASE TABLE icd10specpd g6 tinyint(1) YES
BASE TABLE icd10specpd g1_1 tinyint(1) YES
BASE TABLE icd10specpd g1_2 tinyint(1) YES
BASE TABLE icd10specpd g1_3 tinyint(1) YES
BASE TABLE icd10specpd g1_4 tinyint(1) YES
BASE TABLE icd10specpd paranoid1 tinyint(1) YES
BASE TABLE icd10specpd paranoid2 tinyint(1) YES
BASE TABLE icd10specpd paranoid3 tinyint(1) YES
BASE TABLE icd10specpd paranoid4 tinyint(1) YES
BASE TABLE icd10specpd paranoid5 tinyint(1) YES
BASE TABLE icd10specpd paranoid6 tinyint(1) YES
BASE TABLE icd10specpd paranoid7 tinyint(1) YES
BASE TABLE icd10specpd schizoid1 tinyint(1) YES
BASE TABLE icd10specpd schizoid2 tinyint(1) YES
BASE TABLE icd10specpd schizoid3 tinyint(1) YES
BASE TABLE icd10specpd schizoid4 tinyint(1) YES
BASE TABLE icd10specpd schizoid5 tinyint(1) YES
BASE TABLE icd10specpd schizoid6 tinyint(1) YES
BASE TABLE icd10specpd schizoid7 tinyint(1) YES
BASE TABLE icd10specpd schizoid8 tinyint(1) YES
BASE TABLE icd10specpd schizoid9 tinyint(1) YES
BASE TABLE icd10specpd dissocial1 tinyint(1) YES
BASE TABLE icd10specpd dissocial2 tinyint(1) YES
BASE TABLE icd10specpd dissocial3 tinyint(1) YES
BASE TABLE icd10specpd dissocial4 tinyint(1) YES
BASE TABLE icd10specpd dissocial5 tinyint(1) YES
BASE TABLE icd10specpd dissocial6 tinyint(1) YES
BASE TABLE icd10specpd eu1 tinyint(1) YES
BASE TABLE icd10specpd eu2 tinyint(1) YES
BASE TABLE icd10specpd eu3 tinyint(1) YES
BASE TABLE icd10specpd eu4 tinyint(1) YES
BASE TABLE icd10specpd eu5 tinyint(1) YES
BASE TABLE icd10specpd eu6 tinyint(1) YES
BASE TABLE icd10specpd eu7 tinyint(1) YES
BASE TABLE icd10specpd eu8 tinyint(1) YES
BASE TABLE icd10specpd eu9 tinyint(1) YES
BASE TABLE icd10specpd eu10 tinyint(1) YES
BASE TABLE icd10specpd histrionic1 tinyint(1) YES
BASE TABLE icd10specpd histrionic2 tinyint(1) YES
BASE TABLE icd10specpd histrionic3 tinyint(1) YES
BASE TABLE icd10specpd histrionic4 tinyint(1) YES
BASE TABLE icd10specpd histrionic5 tinyint(1) YES
BASE TABLE icd10specpd histrionic6 tinyint(1) YES
BASE TABLE icd10specpd anankastic1 tinyint(1) YES
BASE TABLE icd10specpd anankastic2 tinyint(1) YES
BASE TABLE icd10specpd anankastic3 tinyint(1) YES
BASE TABLE icd10specpd anankastic4 tinyint(1) YES
BASE TABLE icd10specpd anankastic5 tinyint(1) YES
BASE TABLE icd10specpd anankastic6 tinyint(1) YES
BASE TABLE icd10specpd anankastic7 tinyint(1) YES
BASE TABLE icd10specpd anankastic8 tinyint(1) YES
BASE TABLE icd10specpd anxious1 tinyint(1) YES
BASE TABLE icd10specpd anxious2 tinyint(1) YES
BASE TABLE icd10specpd anxious3 tinyint(1) YES
BASE TABLE icd10specpd anxious4 tinyint(1) YES
BASE TABLE icd10specpd anxious5 tinyint(1) YES
BASE TABLE icd10specpd dependent1 tinyint(1) YES
BASE TABLE icd10specpd dependent2 tinyint(1) YES
BASE TABLE icd10specpd dependent3 tinyint(1) YES
BASE TABLE icd10specpd dependent4 tinyint(1) YES
BASE TABLE icd10specpd dependent5 tinyint(1) YES
BASE TABLE icd10specpd dependent6 tinyint(1) YES
BASE TABLE mast _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE mast _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE mast _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE mast _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE mast _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE mast _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE mast _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE mast _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE mast _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE mast _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE mast _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE mast _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE mast _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE mast _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE mast _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE mast _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE mast _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE mast when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE mast id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE mast patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE mast when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE mast when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE mast firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE mast firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE mast q1 varchar(1) YES
BASE TABLE mast q2 varchar(1) YES
BASE TABLE mast q3 varchar(1) YES
BASE TABLE mast q4 varchar(1) YES
BASE TABLE mast q5 varchar(1) YES
BASE TABLE mast q6 varchar(1) YES
BASE TABLE mast q7 varchar(1) YES
BASE TABLE mast q8 varchar(1) YES
BASE TABLE mast q9 varchar(1) YES
BASE TABLE mast q10 varchar(1) YES
BASE TABLE mast q11 varchar(1) YES
BASE TABLE mast q12 varchar(1) YES
BASE TABLE mast q13 varchar(1) YES
BASE TABLE mast q14 varchar(1) YES
BASE TABLE mast q15 varchar(1) YES
BASE TABLE mast q16 varchar(1) YES
BASE TABLE mast q17 varchar(1) YES
BASE TABLE mast q18 varchar(1) YES
BASE TABLE mast q19 varchar(1) YES
BASE TABLE mast q20 varchar(1) YES
BASE TABLE mast q21 varchar(1) YES
BASE TABLE mast q22 varchar(1) YES
BASE TABLE mast q23 varchar(1) YES
BASE TABLE mast q24 varchar(1) YES
BASE TABLE mast_SUMMARY_TEMP mast_pk int(11) NO FK to the source table's _pk field
BASE TABLE mast_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE mast_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE mast_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE mast_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE mast_SUMMARY_TEMP total int(11) YES
BASE TABLE moca _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE moca _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE moca _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE moca _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE moca _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE moca _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE moca _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE moca _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE moca _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE moca _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE moca _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE moca _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE moca _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE moca _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE moca _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE moca _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE moca _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE moca when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE moca id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE moca patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE moca when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE moca when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE moca firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE moca firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE moca clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE moca clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE moca clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE moca clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE moca clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE moca q1 int(11) YES
BASE TABLE moca q2 int(11) YES
BASE TABLE moca q3 int(11) YES
BASE TABLE moca q4 int(11) YES
BASE TABLE moca q5 int(11) YES
BASE TABLE moca q6 int(11) YES
BASE TABLE moca q7 int(11) YES
BASE TABLE moca q8 int(11) YES
BASE TABLE moca q9 int(11) YES
BASE TABLE moca q10 int(11) YES
BASE TABLE moca q11 int(11) YES
BASE TABLE moca q12 int(11) YES
BASE TABLE moca q13 int(11) YES
BASE TABLE moca q14 int(11) YES
BASE TABLE moca q15 int(11) YES
BASE TABLE moca q16 int(11) YES
BASE TABLE moca q17 int(11) YES
BASE TABLE moca q18 int(11) YES
BASE TABLE moca q19 int(11) YES
BASE TABLE moca q20 int(11) YES
BASE TABLE moca q21 int(11) YES
BASE TABLE moca q22 int(11) YES
BASE TABLE moca q23 int(11) YES
BASE TABLE moca q24 int(11) YES
BASE TABLE moca q25 int(11) YES
BASE TABLE moca q26 int(11) YES
BASE TABLE moca q27 int(11) YES
BASE TABLE moca q28 int(11) YES
BASE TABLE moca education12y_or_less int(11) YES
BASE TABLE moca trailpicture_blobid int(11) YES
BASE TABLE moca cubepicture_blobid int(11) YES
BASE TABLE moca clockpicture_blobid int(11) YES
BASE TABLE moca register_trial1_1 int(11) YES
BASE TABLE moca register_trial1_2 int(11) YES
BASE TABLE moca register_trial1_3 int(11) YES
BASE TABLE moca register_trial1_4 int(11) YES
BASE TABLE moca register_trial1_5 int(11) YES
BASE TABLE moca register_trial2_1 int(11) YES
BASE TABLE moca register_trial2_2 int(11) YES
BASE TABLE moca register_trial2_3 int(11) YES
BASE TABLE moca register_trial2_4 int(11) YES
BASE TABLE moca register_trial2_5 int(11) YES
BASE TABLE moca recall_category_cue_1 int(11) YES
BASE TABLE moca recall_category_cue_2 int(11) YES
BASE TABLE moca recall_category_cue_3 int(11) YES
BASE TABLE moca recall_category_cue_4 int(11) YES
BASE TABLE moca recall_category_cue_5 int(11) YES
BASE TABLE moca recall_mc_cue_1 int(11) YES
BASE TABLE moca recall_mc_cue_2 int(11) YES
BASE TABLE moca recall_mc_cue_3 int(11) YES
BASE TABLE moca recall_mc_cue_4 int(11) YES
BASE TABLE moca recall_mc_cue_5 int(11) YES
BASE TABLE moca comments text YES
BASE TABLE moca_SUMMARY_TEMP moca_pk int(11) NO FK to the source table's _pk field
BASE TABLE moca_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE moca_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE moca_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE moca_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE moca_SUMMARY_TEMP total int(11) YES
BASE TABLE nart _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE nart _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE nart _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE nart _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE nart _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE nart _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE nart _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE nart _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE nart _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE nart _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE nart _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE nart _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE nart _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE nart _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE nart _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE nart _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE nart _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE nart when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE nart id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE nart patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE nart when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE nart when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE nart firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE nart firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE nart clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE nart clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE nart clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE nart clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE nart clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE nart chord tinyint(1) YES
BASE TABLE nart ache tinyint(1) YES
BASE TABLE nart depot tinyint(1) YES
BASE TABLE nart aisle tinyint(1) YES
BASE TABLE nart bouquet tinyint(1) YES
BASE TABLE nart psalm tinyint(1) YES
BASE TABLE nart capon tinyint(1) YES
BASE TABLE nart deny tinyint(1) YES
BASE TABLE nart nausea tinyint(1) YES
BASE TABLE nart debt tinyint(1) YES
BASE TABLE nart courteous tinyint(1) YES
BASE TABLE nart rarefy tinyint(1) YES
BASE TABLE nart equivocal tinyint(1) YES
BASE TABLE nart naive tinyint(1) YES
BASE TABLE nart catacomb tinyint(1) YES
BASE TABLE nart gaoled tinyint(1) YES
BASE TABLE nart thyme tinyint(1) YES
BASE TABLE nart heir tinyint(1) YES
BASE TABLE nart radix tinyint(1) YES
BASE TABLE nart assignate tinyint(1) YES
BASE TABLE nart hiatus tinyint(1) YES
BASE TABLE nart subtle tinyint(1) YES
BASE TABLE nart procreate tinyint(1) YES
BASE TABLE nart gist tinyint(1) YES
BASE TABLE nart gouge tinyint(1) YES
BASE TABLE nart superfluous tinyint(1) YES
BASE TABLE nart simile tinyint(1) YES
BASE TABLE nart banal tinyint(1) YES
BASE TABLE nart quadruped tinyint(1) YES
BASE TABLE nart cellist tinyint(1) YES
BASE TABLE nart facade tinyint(1) YES
BASE TABLE nart zealot tinyint(1) YES
BASE TABLE nart drachm tinyint(1) YES
BASE TABLE nart aeon tinyint(1) YES
BASE TABLE nart placebo tinyint(1) YES
BASE TABLE nart abstemious tinyint(1) YES
BASE TABLE nart detente tinyint(1) YES
BASE TABLE nart idyll tinyint(1) YES
BASE TABLE nart puerperal tinyint(1) YES
BASE TABLE nart aver tinyint(1) YES
BASE TABLE nart gauche tinyint(1) YES
BASE TABLE nart topiary tinyint(1) YES
BASE TABLE nart leviathan tinyint(1) YES
BASE TABLE nart beatify tinyint(1) YES
BASE TABLE nart prelate tinyint(1) YES
BASE TABLE nart sidereal tinyint(1) YES
BASE TABLE nart demesne tinyint(1) YES
BASE TABLE nart syncope tinyint(1) YES
BASE TABLE nart labile tinyint(1) YES
BASE TABLE nart campanile tinyint(1) YES
BASE TABLE nart_SUMMARY_TEMP nart_pk int(11) NO FK to the source table's _pk field
BASE TABLE nart_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE nart_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE nart_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE nart_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE nart_SUMMARY_TEMP fsiq double YES
BASE TABLE nart_SUMMARY_TEMP viq double YES
BASE TABLE nart_SUMMARY_TEMP piq double YES
BASE TABLE panss _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE panss _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE panss _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE panss _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE panss _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE panss _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE panss _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE panss _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE panss _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE panss _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE panss _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE panss _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE panss _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE panss _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE panss _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE panss _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE panss _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE panss when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE panss id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE panss patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE panss when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE panss when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE panss firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE panss firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE panss clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE panss clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE panss clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE panss clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE panss clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE panss p1 int(11) YES
BASE TABLE panss p2 int(11) YES
BASE TABLE panss p3 int(11) YES
BASE TABLE panss p4 int(11) YES
BASE TABLE panss p5 int(11) YES
BASE TABLE panss p6 int(11) YES
BASE TABLE panss p7 int(11) YES
BASE TABLE panss n1 int(11) YES
BASE TABLE panss n2 int(11) YES
BASE TABLE panss n3 int(11) YES
BASE TABLE panss n4 int(11) YES
BASE TABLE panss n5 int(11) YES
BASE TABLE panss n6 int(11) YES
BASE TABLE panss n7 int(11) YES
BASE TABLE panss g1 int(11) YES
BASE TABLE panss g2 int(11) YES
BASE TABLE panss g3 int(11) YES
BASE TABLE panss g4 int(11) YES
BASE TABLE panss g5 int(11) YES
BASE TABLE panss g6 int(11) YES
BASE TABLE panss g7 int(11) YES
BASE TABLE panss g8 int(11) YES
BASE TABLE panss g9 int(11) YES
BASE TABLE panss g10 int(11) YES
BASE TABLE panss g11 int(11) YES
BASE TABLE panss g12 int(11) YES
BASE TABLE panss g13 int(11) YES
BASE TABLE panss g14 int(11) YES
BASE TABLE panss g15 int(11) YES
BASE TABLE panss g16 int(11) YES
BASE TABLE panss_SUMMARY_TEMP panss_pk int(11) NO FK to the source table's _pk field
BASE TABLE panss_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE panss_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE panss_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE panss_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE panss_SUMMARY_TEMP total int(11) YES
BASE TABLE panss_SUMMARY_TEMP p int(11) YES
BASE TABLE panss_SUMMARY_TEMP n int(11) YES
BASE TABLE panss_SUMMARY_TEMP g int(11) YES
BASE TABLE panss_SUMMARY_TEMP composite int(11) YES
BASE TABLE patient _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE patient _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE patient _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE patient _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE patient _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE patient _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE patient _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE patient _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE patient _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE patient _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE patient _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE patient _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE patient _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE patient _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE patient _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE patient _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE patient _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE patient when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE patient id int(11) NO Primary key (patient ID) on the source tablet device
BASE TABLE patient forename varchar(255) NO Forename
BASE TABLE patient surname varchar(255) NO Surname
BASE TABLE patient dob varchar(32) NO Date of birth
BASE TABLE patient sex varchar(1) NO Sex (M, F)
BASE TABLE patient address text YES Address
BASE TABLE patient gp text YES General practitioner (GP)
BASE TABLE patient other text YES Other details
BASE TABLE patient idnum1 int(11) YES ID number 1
BASE TABLE patient iddesc1 varchar(255) YES ID description 1
BASE TABLE patient idshortdesc1 varchar(255) YES ID short description 1
BASE TABLE patient idnum2 int(11) YES ID number 2
BASE TABLE patient iddesc2 varchar(255) YES ID description 2
BASE TABLE patient idshortdesc2 varchar(255) YES ID short description 2
BASE TABLE patient idnum3 int(11) YES ID number 3
BASE TABLE patient iddesc3 varchar(255) YES ID description 3
BASE TABLE patient idshortdesc3 varchar(255) YES ID short description 3
BASE TABLE patient idnum4 int(11) YES ID number 4
BASE TABLE patient iddesc4 varchar(255) YES ID description 4
BASE TABLE patient idshortdesc4 varchar(255) YES ID short description 4
BASE TABLE patient idnum5 int(11) YES ID number 5
BASE TABLE patient iddesc5 varchar(255) YES ID description 5
BASE TABLE patient idshortdesc5 varchar(255) YES ID short description 5
BASE TABLE patient idnum6 int(11) YES ID number 6
BASE TABLE patient iddesc6 varchar(255) YES ID description 6
BASE TABLE patient idshortdesc6 varchar(255) YES ID short description 6
BASE TABLE patient idnum7 int(11) YES ID number 7
BASE TABLE patient iddesc7 varchar(255) YES ID description 7
BASE TABLE patient idshortdesc7 varchar(255) YES ID short description 7
BASE TABLE patient idnum8 int(11) YES ID number 8
BASE TABLE patient iddesc8 varchar(255) YES ID description 8
BASE TABLE patient idshortdesc8 varchar(255) YES ID short description 8
BASE TABLE pclc _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE pclc _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE pclc _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE pclc _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE pclc _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE pclc _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE pclc _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE pclc _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE pclc _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE pclc _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE pclc _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE pclc _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE pclc _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE pclc _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE pclc _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE pclc _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE pclc _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE pclc when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE pclc id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE pclc patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE pclc when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE pclc when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE pclc firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE pclc firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE pclc q1 int(11) YES
BASE TABLE pclc q2 int(11) YES
BASE TABLE pclc q3 int(11) YES
BASE TABLE pclc q4 int(11) YES
BASE TABLE pclc q5 int(11) YES
BASE TABLE pclc q6 int(11) YES
BASE TABLE pclc q7 int(11) YES
BASE TABLE pclc q8 int(11) YES
BASE TABLE pclc q9 int(11) YES
BASE TABLE pclc q10 int(11) YES
BASE TABLE pclc q11 int(11) YES
BASE TABLE pclc q12 int(11) YES
BASE TABLE pclc q13 int(11) YES
BASE TABLE pclc q14 int(11) YES
BASE TABLE pclc q15 int(11) YES
BASE TABLE pclc q16 int(11) YES
BASE TABLE pclc q17 int(11) YES
BASE TABLE pclm _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE pclm _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE pclm _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE pclm _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE pclm _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE pclm _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE pclm _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE pclm _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE pclm _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE pclm _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE pclm _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE pclm _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE pclm _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE pclm _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE pclm _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE pclm _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE pclm _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE pclm when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE pclm id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE pclm patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE pclm when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE pclm when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE pclm firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE pclm firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE pclm q1 int(11) YES
BASE TABLE pclm q2 int(11) YES
BASE TABLE pclm q3 int(11) YES
BASE TABLE pclm q4 int(11) YES
BASE TABLE pclm q5 int(11) YES
BASE TABLE pclm q6 int(11) YES
BASE TABLE pclm q7 int(11) YES
BASE TABLE pclm q8 int(11) YES
BASE TABLE pclm q9 int(11) YES
BASE TABLE pclm q10 int(11) YES
BASE TABLE pclm q11 int(11) YES
BASE TABLE pclm q12 int(11) YES
BASE TABLE pclm q13 int(11) YES
BASE TABLE pclm q14 int(11) YES
BASE TABLE pclm q15 int(11) YES
BASE TABLE pclm q16 int(11) YES
BASE TABLE pclm q17 int(11) YES
BASE TABLE pcls _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE pcls _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE pcls _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE pcls _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE pcls _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE pcls _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE pcls _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE pcls _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE pcls _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE pcls _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE pcls _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE pcls _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE pcls _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE pcls _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE pcls _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE pcls _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE pcls _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE pcls when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE pcls id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE pcls patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE pcls when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE pcls when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE pcls firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE pcls firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE pcls q1 int(11) YES
BASE TABLE pcls q2 int(11) YES
BASE TABLE pcls q3 int(11) YES
BASE TABLE pcls q4 int(11) YES
BASE TABLE pcls q5 int(11) YES
BASE TABLE pcls q6 int(11) YES
BASE TABLE pcls q7 int(11) YES
BASE TABLE pcls q8 int(11) YES
BASE TABLE pcls q9 int(11) YES
BASE TABLE pcls q10 int(11) YES
BASE TABLE pcls q11 int(11) YES
BASE TABLE pcls q12 int(11) YES
BASE TABLE pcls q13 int(11) YES
BASE TABLE pcls q14 int(11) YES
BASE TABLE pcls q15 int(11) YES
BASE TABLE pcls q16 int(11) YES
BASE TABLE pcls q17 int(11) YES
BASE TABLE pcls event text YES
BASE TABLE pcls eventdate text YES
BASE TABLE photo _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE photo _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE photo _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE photo _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE photo _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE photo _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE photo _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE photo _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE photo _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE photo _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE photo _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE photo _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE photo _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE photo _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE photo _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE photo _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE photo _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE photo when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE photo id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE photo patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE photo when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE photo when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE photo firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE photo firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE photo clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE photo clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE photo clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE photo clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE photo clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE photo description text YES Description of the photograph
BASE TABLE photo photo_blobid int(11) YES ID of the BLOB (foreign key to blobs.id, given matching device and current/frozen record status)
BASE TABLE photo rotation int(11) YES Rotation (clockwise, in degrees) to be applied for viewing
BASE TABLE photosequence _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE photosequence _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE photosequence _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE photosequence _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE photosequence _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE photosequence _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE photosequence _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE photosequence _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE photosequence _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE photosequence _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE photosequence _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE photosequence _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE photosequence _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE photosequence _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE photosequence _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE photosequence _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE photosequence _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE photosequence when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE photosequence id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE photosequence patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE photosequence when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE photosequence when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE photosequence firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE photosequence firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE photosequence clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE photosequence clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE photosequence clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE photosequence clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE photosequence clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE photosequence sequence_description text YES Description of the sequence of photographs
BASE TABLE photosequence_photos _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE photosequence_photos _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE photosequence_photos _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE photosequence_photos _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE photosequence_photos _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE photosequence_photos _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE photosequence_photos _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE photosequence_photos _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE photosequence_photos _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE photosequence_photos _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE photosequence_photos _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE photosequence_photos _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE photosequence_photos _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE photosequence_photos _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE photosequence_photos _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE photosequence_photos _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE photosequence_photos _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE photosequence_photos when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE photosequence_photos id int(11) NO (ANCILLARY) Primary key on the tablet device
BASE TABLE photosequence_photos photosequence_id int(11) NO
BASE TABLE photosequence_photos seqnum int(11) NO
BASE TABLE photosequence_photos description text YES Description of the photograph
BASE TABLE photosequence_photos photo_blobid int(11) YES ID of the BLOB (foreign key to blobs.id, given matching device and current/frozen record status)
BASE TABLE photosequence_photos rotation int(11) YES Rotation (clockwise, in degrees) to be applied for viewing
BASE TABLE phq15 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE phq15 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE phq15 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE phq15 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE phq15 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE phq15 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE phq15 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE phq15 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE phq15 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE phq15 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE phq15 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE phq15 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE phq15 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE phq15 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE phq15 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE phq15 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE phq15 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE phq15 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE phq15 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE phq15 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE phq15 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE phq15 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE phq15 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE phq15 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE phq15 q1 int(11) YES
BASE TABLE phq15 q2 int(11) YES
BASE TABLE phq15 q3 int(11) YES
BASE TABLE phq15 q4 int(11) YES
BASE TABLE phq15 q5 int(11) YES
BASE TABLE phq15 q6 int(11) YES
BASE TABLE phq15 q7 int(11) YES
BASE TABLE phq15 q8 int(11) YES
BASE TABLE phq15 q9 int(11) YES
BASE TABLE phq15 q10 int(11) YES
BASE TABLE phq15 q11 int(11) YES
BASE TABLE phq15 q12 int(11) YES
BASE TABLE phq15 q13 int(11) YES
BASE TABLE phq15 q14 int(11) YES
BASE TABLE phq15 q15 int(11) YES
BASE TABLE phq15_SUMMARY_TEMP phq15_pk int(11) NO FK to the source table's _pk field
BASE TABLE phq15_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE phq15_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE phq15_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE phq15_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE phq15_SUMMARY_TEMP total int(11) YES
BASE TABLE phq9 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE phq9 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE phq9 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE phq9 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE phq9 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE phq9 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE phq9 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE phq9 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE phq9 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE phq9 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE phq9 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE phq9 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE phq9 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE phq9 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE phq9 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE phq9 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE phq9 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE phq9 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE phq9 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE phq9 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE phq9 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE phq9 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE phq9 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE phq9 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE phq9 q1 int(11) YES
BASE TABLE phq9 q2 int(11) YES
BASE TABLE phq9 q3 int(11) YES
BASE TABLE phq9 q4 int(11) YES
BASE TABLE phq9 q5 int(11) YES
BASE TABLE phq9 q6 int(11) YES
BASE TABLE phq9 q7 int(11) YES
BASE TABLE phq9 q8 int(11) YES
BASE TABLE phq9 q9 int(11) YES
BASE TABLE phq9 q10 int(11) YES
BASE TABLE phq9_SUMMARY_TEMP phq9_pk int(11) NO FK to the source table's _pk field
BASE TABLE phq9_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE phq9_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE phq9_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE phq9_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE phq9_SUMMARY_TEMP total int(11) YES
BASE TABLE phq9_SUMMARY_TEMP n_core int(11) YES
BASE TABLE phq9_SUMMARY_TEMP n_other int(11) YES
BASE TABLE phq9_SUMMARY_TEMP n_total int(11) YES
BASE TABLE phq9_SUMMARY_TEMP is_mds int(11) YES
BASE TABLE phq9_SUMMARY_TEMP is_ods int(11) YES
BASE TABLE phq9_SUMMARY_TEMP severity text YES
BASE TABLE progressnote _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE progressnote _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE progressnote _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE progressnote _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE progressnote _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE progressnote _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE progressnote _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE progressnote _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE progressnote _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE progressnote _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE progressnote _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE progressnote _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE progressnote _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE progressnote _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE progressnote _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE progressnote _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE progressnote _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE progressnote when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE progressnote id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE progressnote patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE progressnote when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE progressnote when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE progressnote firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE progressnote firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE progressnote clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE progressnote clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE progressnote clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE progressnote clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE progressnote clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE progressnote location text YES Location
BASE TABLE progressnote note text YES Clinical note
BASE TABLE psychiatricclerking _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE psychiatricclerking _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE psychiatricclerking _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE psychiatricclerking _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE psychiatricclerking _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE psychiatricclerking _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE psychiatricclerking _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE psychiatricclerking _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE psychiatricclerking _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE psychiatricclerking _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE psychiatricclerking _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE psychiatricclerking _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE psychiatricclerking _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE psychiatricclerking _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE psychiatricclerking _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE psychiatricclerking _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE psychiatricclerking _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE psychiatricclerking when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE psychiatricclerking id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE psychiatricclerking patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE psychiatricclerking when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE psychiatricclerking when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE psychiatricclerking firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE psychiatricclerking firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE psychiatricclerking clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE psychiatricclerking clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE psychiatricclerking clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE psychiatricclerking clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE psychiatricclerking clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE psychiatricclerking location text YES
BASE TABLE psychiatricclerking contact_type text YES
BASE TABLE psychiatricclerking reason_for_contact text YES
BASE TABLE psychiatricclerking presenting_issue text YES
BASE TABLE psychiatricclerking systems_review text YES
BASE TABLE psychiatricclerking collateral_history text YES
BASE TABLE psychiatricclerking diagnoses_psychiatric text YES
BASE TABLE psychiatricclerking diagnoses_medical text YES
BASE TABLE psychiatricclerking operations_procedures text YES
BASE TABLE psychiatricclerking allergies_adverse_reactions text YES
BASE TABLE psychiatricclerking medications text YES
BASE TABLE psychiatricclerking recreational_drug_use text YES
BASE TABLE psychiatricclerking family_history text YES
BASE TABLE psychiatricclerking developmental_history text YES
BASE TABLE psychiatricclerking personal_history text YES
BASE TABLE psychiatricclerking premorbid_personality text YES
BASE TABLE psychiatricclerking forensic_history text YES
BASE TABLE psychiatricclerking current_social_situation text YES
BASE TABLE psychiatricclerking mse_appearance_behaviour text YES
BASE TABLE psychiatricclerking mse_speech text YES
BASE TABLE psychiatricclerking mse_mood_subjective text YES
BASE TABLE psychiatricclerking mse_mood_objective text YES
BASE TABLE psychiatricclerking mse_thought_form text YES
BASE TABLE psychiatricclerking mse_thought_content text YES
BASE TABLE psychiatricclerking mse_perception text YES
BASE TABLE psychiatricclerking mse_cognition text YES
BASE TABLE psychiatricclerking mse_insight text YES
BASE TABLE psychiatricclerking physical_examination_general text YES
BASE TABLE psychiatricclerking physical_examination_cardiovascular text YES
BASE TABLE psychiatricclerking physical_examination_respiratory text YES
BASE TABLE psychiatricclerking physical_examination_abdominal text YES
BASE TABLE psychiatricclerking physical_examination_neurological text YES
BASE TABLE psychiatricclerking assessment_scales text YES
BASE TABLE psychiatricclerking investigations_results text YES
BASE TABLE psychiatricclerking safety_alerts text YES
BASE TABLE psychiatricclerking risk_assessment text YES
BASE TABLE psychiatricclerking relevant_legal_information text YES
BASE TABLE psychiatricclerking current_problems text YES
BASE TABLE psychiatricclerking patient_carer_concerns text YES
BASE TABLE psychiatricclerking impression text YES
BASE TABLE psychiatricclerking management_plan text YES
BASE TABLE psychiatricclerking information_given text YES
BASE TABLE qolbasic _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE qolbasic _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE qolbasic _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE qolbasic _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE qolbasic _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE qolbasic _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE qolbasic _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE qolbasic _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE qolbasic _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE qolbasic _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE qolbasic _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE qolbasic _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE qolbasic _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE qolbasic _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE qolbasic _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE qolbasic _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE qolbasic _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE qolbasic when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE qolbasic id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE qolbasic patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE qolbasic when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE qolbasic when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE qolbasic firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE qolbasic firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE qolbasic tto double YES
BASE TABLE qolbasic rs double YES
BASE TABLE qolbasic_SUMMARY_TEMP qolbasic_pk int(11) NO FK to the source table's _pk field
BASE TABLE qolbasic_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE qolbasic_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE qolbasic_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE qolbasic_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE qolbasic_SUMMARY_TEMP tto_qol double YES
BASE TABLE qolbasic_SUMMARY_TEMP rs_qol double YES
BASE TABLE qolsg _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE qolsg _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE qolsg _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE qolsg _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE qolsg _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE qolsg _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE qolsg _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE qolsg _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE qolsg _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE qolsg _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE qolsg _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE qolsg _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE qolsg _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE qolsg _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE qolsg _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE qolsg _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE qolsg _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE qolsg when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE qolsg id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE qolsg patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE qolsg when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE qolsg when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE qolsg firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE qolsg firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE qolsg category_start_time text YES
BASE TABLE qolsg category_responded int(11) YES
BASE TABLE qolsg category_response_time text YES
BASE TABLE qolsg category_chosen text YES
BASE TABLE qolsg gamble_fixed_option text YES
BASE TABLE qolsg gamble_lottery_option_p text YES
BASE TABLE qolsg gamble_lottery_option_q text YES
BASE TABLE qolsg gamble_lottery_on_left int(11) YES
BASE TABLE qolsg gamble_starting_p double YES
BASE TABLE qolsg gamble_start_time text YES
BASE TABLE qolsg gamble_responded int(11) YES
BASE TABLE qolsg gamble_response_time text YES
BASE TABLE qolsg gamble_p double YES
BASE TABLE qolsg utility double YES
BASE TABLE rand36 _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE rand36 _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE rand36 _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE rand36 _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE rand36 _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE rand36 _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE rand36 _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE rand36 _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE rand36 _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE rand36 _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE rand36 _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE rand36 _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE rand36 _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE rand36 _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE rand36 _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE rand36 _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE rand36 _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE rand36 when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE rand36 id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE rand36 patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE rand36 when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE rand36 when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE rand36 firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE rand36 firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE rand36 q1 int(11) YES
BASE TABLE rand36 q2 int(11) YES
BASE TABLE rand36 q3 int(11) YES
BASE TABLE rand36 q4 int(11) YES
BASE TABLE rand36 q5 int(11) YES
BASE TABLE rand36 q6 int(11) YES
BASE TABLE rand36 q7 int(11) YES
BASE TABLE rand36 q8 int(11) YES
BASE TABLE rand36 q9 int(11) YES
BASE TABLE rand36 q10 int(11) YES
BASE TABLE rand36 q11 int(11) YES
BASE TABLE rand36 q12 int(11) YES
BASE TABLE rand36 q13 int(11) YES
BASE TABLE rand36 q14 int(11) YES
BASE TABLE rand36 q15 int(11) YES
BASE TABLE rand36 q16 int(11) YES
BASE TABLE rand36 q17 int(11) YES
BASE TABLE rand36 q18 int(11) YES
BASE TABLE rand36 q19 int(11) YES
BASE TABLE rand36 q20 int(11) YES
BASE TABLE rand36 q21 int(11) YES
BASE TABLE rand36 q22 int(11) YES
BASE TABLE rand36 q23 int(11) YES
BASE TABLE rand36 q24 int(11) YES
BASE TABLE rand36 q25 int(11) YES
BASE TABLE rand36 q26 int(11) YES
BASE TABLE rand36 q27 int(11) YES
BASE TABLE rand36 q28 int(11) YES
BASE TABLE rand36 q29 int(11) YES
BASE TABLE rand36 q30 int(11) YES
BASE TABLE rand36 q31 int(11) YES
BASE TABLE rand36 q32 int(11) YES
BASE TABLE rand36 q33 int(11) YES
BASE TABLE rand36 q34 int(11) YES
BASE TABLE rand36 q35 int(11) YES
BASE TABLE rand36 q36 int(11) YES
BASE TABLE rand36_SUMMARY_TEMP rand36_pk int(11) NO FK to the source table's _pk field
BASE TABLE rand36_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE rand36_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE rand36_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE rand36_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE rand36_SUMMARY_TEMP overall double YES
BASE TABLE rand36_SUMMARY_TEMP physical_functioning double YES
BASE TABLE rand36_SUMMARY_TEMP role_limitations_physical double YES
BASE TABLE rand36_SUMMARY_TEMP role_limitations_emotional double YES
BASE TABLE rand36_SUMMARY_TEMP energy double YES
BASE TABLE rand36_SUMMARY_TEMP emotional_wellbeing double YES
BASE TABLE rand36_SUMMARY_TEMP social_functioning double YES
BASE TABLE rand36_SUMMARY_TEMP pain double YES
BASE TABLE rand36_SUMMARY_TEMP general_health double YES
BASE TABLE slums _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE slums _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE slums _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE slums _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE slums _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE slums _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE slums _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE slums _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE slums _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE slums _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE slums _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE slums _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE slums _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE slums _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE slums _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE slums _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE slums _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE slums when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE slums id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE slums patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE slums when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE slums when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE slums firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE slums firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE slums clinician_specialty text YES Clinician's specialty (e.g. Liaison Psychiatry)
BASE TABLE slums clinician_name text YES Clinician's name (e.g. Dr X)
BASE TABLE slums clinician_post text YES Clinician's post (e.g. Consultant)
BASE TABLE slums clinician_professional_registration text YES Clinician's professional registration (e.g. GMC# 12345)
BASE TABLE slums clinician_contact_details text YES Clinician's contact details (e.g. bleep, extension)
BASE TABLE slums alert int(11) YES
BASE TABLE slums highschooleducation int(11) YES
BASE TABLE slums q1 int(11) YES
BASE TABLE slums q2 int(11) YES
BASE TABLE slums q3 int(11) YES
BASE TABLE slums q5a int(11) YES
BASE TABLE slums q5b int(11) YES
BASE TABLE slums q6 int(11) YES
BASE TABLE slums q7a int(11) YES
BASE TABLE slums q7b int(11) YES
BASE TABLE slums q7c int(11) YES
BASE TABLE slums q7d int(11) YES
BASE TABLE slums q7e int(11) YES
BASE TABLE slums q8b int(11) YES
BASE TABLE slums q8c int(11) YES
BASE TABLE slums q9a int(11) YES
BASE TABLE slums q9b int(11) YES
BASE TABLE slums q10a int(11) YES
BASE TABLE slums q10b int(11) YES
BASE TABLE slums q11a int(11) YES
BASE TABLE slums q11b int(11) YES
BASE TABLE slums q11c int(11) YES
BASE TABLE slums q11d int(11) YES
BASE TABLE slums clockpicture_blobid int(11) YES
BASE TABLE slums shapespicture_blobid int(11) YES
BASE TABLE slums comments text YES
BASE TABLE slums_SUMMARY_TEMP slums_pk int(11) NO FK to the source table's _pk field
BASE TABLE slums_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE slums_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE slums_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE slums_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE slums_SUMMARY_TEMP total int(11) YES
BASE TABLE smast _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE smast _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE smast _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE smast _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE smast _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE smast _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE smast _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE smast _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE smast _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE smast _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE smast _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE smast _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE smast _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE smast _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE smast _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE smast _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE smast _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE smast when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE smast id int(11) NO (TASK) Primary key (task ID) on the tablet device
BASE TABLE smast patient_id int(11) NO (TASK) Foreign key to patient.id for this device
BASE TABLE smast when_created varchar(32) NO (TASK) Date/time this task instance was created (ISO 8601)
BASE TABLE smast when_firstexit varchar(32) YES (TASK) Date/time of the first exit from this task (ISO 8601)
BASE TABLE smast firstexit_is_finish tinyint(1) YES (TASK) Was the first exit from the task because it was finished (1)?
BASE TABLE smast firstexit_is_abort tinyint(1) YES (TASK) Was the first exit from this task because it was aborted (1)?
BASE TABLE smast q1 varchar(1) YES
BASE TABLE smast q2 varchar(1) YES
BASE TABLE smast q3 varchar(1) YES
BASE TABLE smast q4 varchar(1) YES
BASE TABLE smast q5 varchar(1) YES
BASE TABLE smast q6 varchar(1) YES
BASE TABLE smast q7 varchar(1) YES
BASE TABLE smast q8 varchar(1) YES
BASE TABLE smast q9 varchar(1) YES
BASE TABLE smast q10 varchar(1) YES
BASE TABLE smast q11 varchar(1) YES
BASE TABLE smast q12 varchar(1) YES
BASE TABLE smast q13 varchar(1) YES
BASE TABLE smast_SUMMARY_TEMP smast_pk int(11) NO FK to the source table's _pk field
BASE TABLE smast_SUMMARY_TEMP when_source_record_created_utc datetime YES When was the source record created?
BASE TABLE smast_SUMMARY_TEMP when_summary_created_utc datetime YES When was this summary created?
BASE TABLE smast_SUMMARY_TEMP seconds_from_creation_to_first_finish double YES Time (in seconds) from record creation to first exit, if that was a finish not an abort
BASE TABLE smast_SUMMARY_TEMP is_complete tinyint(1) YES
BASE TABLE smast_SUMMARY_TEMP total int(11) YES
BASE TABLE storedvars _pk int(11) NO (SERVER) Primary key (on the server)
BASE TABLE storedvars _device varchar(255) NO (SERVER) ID of the source tablet device
BASE TABLE storedvars _era varchar(32) NO (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601)
BASE TABLE storedvars _current tinyint(1) NO (SERVER) Is the row current (1) or not (0)?
BASE TABLE storedvars _when_added_exact varchar(32) YES (SERVER) Date/time this row was added (ISO 8601)
BASE TABLE storedvars _when_added_batch_utc datetime YES (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC)
BASE TABLE storedvars _adding_user varchar(255) YES (SERVER) User that added this row
BASE TABLE storedvars _when_removed_exact varchar(32) YES (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601)
BASE TABLE storedvars _when_removed_batch_utc datetime YES (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC)
BASE TABLE storedvars _removing_user varchar(255) YES (SERVER) User that removed this row
BASE TABLE storedvars _preserving_user varchar(255) YES (SERVER) User that preserved this row
BASE TABLE storedvars _predecessor_pk int(11) YES (SERVER) PK of predecessor record, prior to modification
BASE TABLE storedvars _successor_pk int(11) YES (SERVER) PK of successor record (after modification) or NULL (after deletion)
BASE TABLE storedvars _camcops_version double YES (SERVER) CamCOPS version number of the uploading device
BASE TABLE storedvars _addition_pending tinyint(1) NO (SERVER) Addition pending?
BASE TABLE storedvars _removal_pending tinyint(1) NO (SERVER) Removal pending?
BASE TABLE storedvars _move_off_tablet tinyint(1) YES (SERVER/TABLET) Record-specific preservation pending?
BASE TABLE storedvars when_last_modified varchar(32) YES (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601)
BASE TABLE storedvars id int(11) NO Arbitrary numerical primary key on the source tablet device
BASE TABLE storedvars name varchar(255) NO Variable name (effectively the actual primary key on the source tablet device)
BASE TABLE storedvars type varchar(255) NO Variable type ('integer', 'real', 'text')
BASE TABLE storedvars valueInteger int(11) YES Value of an integer variable
BASE TABLE storedvars valueText text YES Value of a text variable
BASE TABLE storedvars valueReal double YES Value of a real (floating-point) variable
Valid HTML 4.01 Transitional
Valid CSS