| 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? |