| BASE TABLE | diagnosis_icd9cm_item | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | diagnosis_icd9cm_item | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | diagnosis_icd9cm_item | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | diagnosis_icd9cm_item | id | int(11) | NO | (ANCILLARY) Primary key on the tablet device |
| BASE TABLE | diagnosis_icd9cm_item | diagnosis_icd9cm_id | int(11) | NO | |
| BASE TABLE | diagnosis_icd9cm_item | seqnum | int(11) | NO | |
| BASE TABLE | diagnosis_icd9cm_item | code | text | YES | Diagnostic code |
| BASE TABLE | diagnosis_icd9cm_item | description | text | YES | Description of the diagnostic code |
| BASE TABLE | distressthermometer | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | distressthermometer | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | distressthermometer | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | distressthermometer | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | distressthermometer | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | distressthermometer | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | distressthermometer | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | distressthermometer | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | distressthermometer | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | distressthermometer | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | distressthermometer | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | distressthermometer | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | distressthermometer | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | distressthermometer | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | distressthermometer | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | distressthermometer | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | distressthermometer | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | distressthermometer | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | distressthermometer | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | distressthermometer | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | distressthermometer | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | distressthermometer | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | distressthermometer | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | distressthermometer | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | distressthermometer | q1 | int(11) | YES | |
| BASE TABLE | distressthermometer | q2 | int(11) | YES | |
| BASE TABLE | distressthermometer | q3 | int(11) | YES | |
| BASE TABLE | distressthermometer | q4 | int(11) | YES | |
| BASE TABLE | distressthermometer | q5 | int(11) | YES | |
| BASE TABLE | distressthermometer | q6 | int(11) | YES | |
| BASE TABLE | distressthermometer | q7 | int(11) | YES | |
| BASE TABLE | distressthermometer | q8 | int(11) | YES | |
| BASE TABLE | distressthermometer | q9 | int(11) | YES | |
| BASE TABLE | distressthermometer | q10 | int(11) | YES | |
| BASE TABLE | distressthermometer | q11 | int(11) | YES | |
| BASE TABLE | distressthermometer | q12 | int(11) | YES | |
| BASE TABLE | distressthermometer | q13 | int(11) | YES | |
| BASE TABLE | distressthermometer | q14 | int(11) | YES | |
| BASE TABLE | distressthermometer | q15 | int(11) | YES | |
| BASE TABLE | distressthermometer | q16 | int(11) | YES | |
| BASE TABLE | distressthermometer | q17 | int(11) | YES | |
| BASE TABLE | distressthermometer | q18 | int(11) | YES | |
| BASE TABLE | distressthermometer | q19 | int(11) | YES | |
| BASE TABLE | distressthermometer | q20 | int(11) | YES | |
| BASE TABLE | distressthermometer | q21 | int(11) | YES | |
| BASE TABLE | distressthermometer | q22 | int(11) | YES | |
| BASE TABLE | distressthermometer | q23 | int(11) | YES | |
| BASE TABLE | distressthermometer | q24 | int(11) | YES | |
| BASE TABLE | distressthermometer | q25 | int(11) | YES | |
| BASE TABLE | distressthermometer | q26 | int(11) | YES | |
| BASE TABLE | distressthermometer | q27 | int(11) | YES | |
| BASE TABLE | distressthermometer | q28 | int(11) | YES | |
| BASE TABLE | distressthermometer | q29 | int(11) | YES | |
| BASE TABLE | distressthermometer | q30 | int(11) | YES | |
| BASE TABLE | distressthermometer | q31 | int(11) | YES | |
| BASE TABLE | distressthermometer | q32 | int(11) | YES | |
| BASE TABLE | distressthermometer | q33 | int(11) | YES | |
| BASE TABLE | distressthermometer | q34 | int(11) | YES | |
| BASE TABLE | distressthermometer | q35 | int(11) | YES | |
| BASE TABLE | distressthermometer | q36 | int(11) | YES | |
| BASE TABLE | distressthermometer | distress | int(11) | YES | |
| BASE TABLE | distressthermometer | other | text | YES | |
| BASE TABLE | expdetthreshold | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | expdetthreshold | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | expdetthreshold | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | expdetthreshold | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | expdetthreshold | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | expdetthreshold | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | expdetthreshold | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | expdetthreshold | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | expdetthreshold | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | expdetthreshold | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | expdetthreshold | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | expdetthreshold | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | expdetthreshold | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | expdetthreshold | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | expdetthreshold | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | expdetthreshold | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | expdetthreshold | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | expdetthreshold | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | expdetthreshold | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | expdetthreshold | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | expdetthreshold | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | expdetthreshold | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | expdetthreshold | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | expdetthreshold | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | expdetthreshold | modality | int(11) | YES | |
| BASE TABLE | expdetthreshold | target_number | int(11) | YES | |
| BASE TABLE | expdetthreshold | background_filename | text | YES | |
| BASE TABLE | expdetthreshold | target_filename | text | YES | |
| BASE TABLE | expdetthreshold | visual_target_duration_s | double | YES | |
| BASE TABLE | expdetthreshold | background_intensity | double | YES | |
| BASE TABLE | expdetthreshold | start_intensity_min | double | YES | |
| BASE TABLE | expdetthreshold | start_intensity_max | double | YES | |
| BASE TABLE | expdetthreshold | initial_large_intensity_step | double | YES | |
| BASE TABLE | expdetthreshold | main_small_intensity_step | double | YES | |
| BASE TABLE | expdetthreshold | num_trials_in_main_sequence | int(11) | YES | |
| BASE TABLE | expdetthreshold | p_catch_trial | double | YES | |
| BASE TABLE | expdetthreshold | prompt | text | YES | |
| BASE TABLE | expdetthreshold | iti_s | double | YES | |
| BASE TABLE | expdetthreshold | finished | int(11) | YES | |
| BASE TABLE | expdetthreshold | intercept | double | YES | |
| BASE TABLE | expdetthreshold | slope | double | YES | |
| BASE TABLE | expdetthreshold | k | double | YES | |
| BASE TABLE | expdetthreshold | theta | double | YES | |
| BASE TABLE | expdetthreshold_trials | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | expdetthreshold_trials | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | expdetthreshold_trials | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | expdetthreshold_trials | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | expdetthreshold_trials | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | expdetthreshold_trials | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | expdetthreshold_trials | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | expdetthreshold_trials | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | expdetthreshold_trials | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | expdetthreshold_trials | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | expdetthreshold_trials | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | expdetthreshold_trials | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | expdetthreshold_trials | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | expdetthreshold_trials | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | expdetthreshold_trials | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | expdetthreshold_trials | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | expdetthreshold_trials | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | expdetthreshold_trials | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | expdetthreshold_trials | id | int(11) | NO | (ANCILLARY) Primary key on the tablet device |
| BASE TABLE | expdetthreshold_trials | expdetthreshold_id | int(11) | NO | |
| BASE TABLE | expdetthreshold_trials | trial | int(11) | NO | |
| BASE TABLE | expdetthreshold_trials | trial_ignoring_catch_trials | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | target_presented | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | target_time | text | YES | |
| BASE TABLE | expdetthreshold_trials | intensity | double | YES | |
| BASE TABLE | expdetthreshold_trials | choice_time | text | YES | |
| BASE TABLE | expdetthreshold_trials | responded | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | response_time | text | YES | |
| BASE TABLE | expdetthreshold_trials | response_latency_ms | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | yes | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | no | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | caught_out_reset | int(11) | YES | |
| BASE TABLE | expdetthreshold_trials | trial_num_in_calculation_sequence | int(11) | YES | |
| BASE TABLE | expectationdetection | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | expectationdetection | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | expectationdetection | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | expectationdetection | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | expectationdetection | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | expectationdetection | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | expectationdetection | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | expectationdetection | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | expectationdetection | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | expectationdetection | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | expectationdetection | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | expectationdetection | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | expectationdetection | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | expectationdetection | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | expectationdetection | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | expectationdetection | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | expectationdetection | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | expectationdetection | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | expectationdetection | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | expectationdetection | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | expectationdetection | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | expectationdetection | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | expectationdetection | num_blocks | int(11) | YES | |
| BASE TABLE | expectationdetection | stimulus_counterbalancing | int(11) | YES | |
| BASE TABLE | expectationdetection | is_detection_response_on_right | int(11) | YES | |
| BASE TABLE | expectationdetection | pause_every_n_trials | int(11) | YES | |
| BASE TABLE | expectationdetection | cue_duration_s | double | YES | |
| BASE TABLE | expectationdetection | visual_cue_intensity | double | YES | |
| BASE TABLE | expectationdetection | auditory_cue_intensity | double | YES | |
| BASE TABLE | expectationdetection | isi_duration_s | double | YES | |
| BASE TABLE | expectationdetection | visual_target_duration_s | double | YES | |
| BASE TABLE | expectationdetection | visual_background_intensity | double | YES | |
| BASE TABLE | expectationdetection | visual_target_0_intensity | double | YES | |
| BASE TABLE | expectationdetection | visual_target_1_intensity | double | YES | |
| BASE TABLE | expectationdetection | auditory_background_intensity | double | YES | |
| BASE TABLE | expectationdetection | auditory_target_0_intensity | double | YES | |
| BASE TABLE | expectationdetection | auditory_target_1_intensity | double | YES | |
| BASE TABLE | expectationdetection | iti_min_s | double | YES | |
| BASE TABLE | expectationdetection | iti_max_s | double | YES | |
| BASE TABLE | expectationdetection | aborted | int(11) | YES | |
| BASE TABLE | expectationdetection | finished | int(11) | YES | |
| BASE TABLE | expectationdetection | last_trial_completed | int(11) | YES | |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | expectationdetection_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | expectationdetection_SUMMARY_TEMP | final_score | int(11) | YES | |
| BASE TABLE | expectationdetection_trialgroupspec | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | expectationdetection_trialgroupspec | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | expectationdetection_trialgroupspec | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | expectationdetection_trialgroupspec | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | expectationdetection_trialgroupspec | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | expectationdetection_trialgroupspec | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection_trialgroupspec | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | expectationdetection_trialgroupspec | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | expectationdetection_trialgroupspec | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection_trialgroupspec | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | expectationdetection_trialgroupspec | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | expectationdetection_trialgroupspec | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | expectationdetection_trialgroupspec | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | expectationdetection_trialgroupspec | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | expectationdetection_trialgroupspec | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | expectationdetection_trialgroupspec | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | expectationdetection_trialgroupspec | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | expectationdetection_trialgroupspec | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | expectationdetection_trialgroupspec | id | int(11) | NO | (ANCILLARY) Primary key on the tablet device |
| BASE TABLE | expectationdetection_trialgroupspec | expectationdetection_id | int(11) | NO | |
| BASE TABLE | expectationdetection_trialgroupspec | group_num | int(11) | NO | |
| BASE TABLE | expectationdetection_trialgroupspec | cue | int(11) | YES | |
| BASE TABLE | expectationdetection_trialgroupspec | target_modality | int(11) | YES | |
| BASE TABLE | expectationdetection_trialgroupspec | target_number | int(11) | YES | |
| BASE TABLE | expectationdetection_trialgroupspec | n_target | int(11) | YES | |
| BASE TABLE | expectationdetection_trialgroupspec | n_no_target | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | expectationdetection_trials | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | expectationdetection_trials | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | expectationdetection_trials | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | expectationdetection_trials | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | expectationdetection_trials | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection_trials | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | expectationdetection_trials | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | expectationdetection_trials | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | expectationdetection_trials | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | expectationdetection_trials | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | expectationdetection_trials | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | expectationdetection_trials | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | expectationdetection_trials | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | expectationdetection_trials | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | expectationdetection_trials | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | expectationdetection_trials | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | expectationdetection_trials | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | expectationdetection_trials | id | int(11) | NO | (ANCILLARY) Primary key on the tablet device |
| BASE TABLE | expectationdetection_trials | expectationdetection_id | int(11) | NO | |
| BASE TABLE | expectationdetection_trials | trial | int(11) | NO | |
| BASE TABLE | expectationdetection_trials | block | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | group_num | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | cue | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | raw_cue_number | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | target_modality | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | target_number | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | target_present | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | iti_length_s | double | YES | |
| BASE TABLE | expectationdetection_trials | pause_given_before_trial | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | pause_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | pause_end_time | text | YES | |
| BASE TABLE | expectationdetection_trials | trial_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | cue_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | target_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | detection_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | iti_start_time | text | YES | |
| BASE TABLE | expectationdetection_trials | iti_end_time | text | YES | |
| BASE TABLE | expectationdetection_trials | trial_end_time | text | YES | |
| BASE TABLE | expectationdetection_trials | responded | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | response_time | text | YES | |
| BASE TABLE | expectationdetection_trials | response_latency_ms | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | rating | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | correct | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | points | int(11) | YES | |
| BASE TABLE | expectationdetection_trials | cumulative_points | int(11) | YES | |
| BASE TABLE | fast | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | fast | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | fast | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | fast | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | fast | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | fast | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | fast | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | fast | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | fast | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | fast | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | fast | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | fast | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | fast | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | fast | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | fast | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | fast | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | fast | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | fast | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | fast | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | fast | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | fast | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | fast | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | fast | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | fast | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | fast | q1 | int(11) | YES | |
| BASE TABLE | fast | q2 | int(11) | YES | |
| BASE TABLE | fast | q3 | int(11) | YES | |
| BASE TABLE | fast | q4 | int(11) | YES | |
| BASE TABLE | fast_SUMMARY_TEMP | fast_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | fast_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | fast_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | fast_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | fast_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | fast_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | fast_SUMMARY_TEMP | positive | tinyint(1) | YES | |
| BASE TABLE | gad7 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | gad7 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | gad7 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | gad7 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | gad7 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | gad7 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | gad7 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | gad7 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | gad7 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | gad7 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | gad7 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | gad7 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | gad7 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | gad7 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | gad7 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | gad7 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | gad7 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | gad7 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | gad7 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | gad7 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | gad7 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | gad7 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | gad7 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | gad7 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | gad7 | q1 | int(11) | YES | |
| BASE TABLE | gad7 | q2 | int(11) | YES | |
| BASE TABLE | gad7 | q3 | int(11) | YES | |
| BASE TABLE | gad7 | q4 | int(11) | YES | |
| BASE TABLE | gad7 | q5 | int(11) | YES | |
| BASE TABLE | gad7 | q6 | int(11) | YES | |
| BASE TABLE | gad7 | q7 | int(11) | YES | |
| BASE TABLE | gad7_SUMMARY_TEMP | gad7_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | gad7_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | gad7_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | gad7_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | gad7_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | gad7_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | gad7_SUMMARY_TEMP | severity | text | YES | |
| BASE TABLE | gaf | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | gaf | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | gaf | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | gaf | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | gaf | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | gaf | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | gaf | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | gaf | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | gaf | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | gaf | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | gaf | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | gaf | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | gaf | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | gaf | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | gaf | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | gaf | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | gaf | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | gaf | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | gaf | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | gaf | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | gaf | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | gaf | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | gaf | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | gaf | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | gaf | score | int(11) | YES | GAF score (1-100 or 0 for insufficient information) |
| BASE TABLE | gaf_SUMMARY_TEMP | gaf_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | gaf_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | gaf_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | gaf_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | gaf_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | gaf_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | gmcpq | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | gmcpq | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | gmcpq | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | gmcpq | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | gmcpq | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | gmcpq | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | gmcpq | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | gmcpq | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | gmcpq | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | gmcpq | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | gmcpq | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | gmcpq | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | gmcpq | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | gmcpq | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | gmcpq | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | gmcpq | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | gmcpq | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | gmcpq | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | gmcpq | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | gmcpq | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | gmcpq | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | gmcpq | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | gmcpq | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | gmcpq | doctor | text | YES | |
| BASE TABLE | gmcpq | q1 | int(11) | YES | |
| BASE TABLE | gmcpq | q2a | int(11) | YES | |
| BASE TABLE | gmcpq | q2b | int(11) | YES | |
| BASE TABLE | gmcpq | q2c | int(11) | YES | |
| BASE TABLE | gmcpq | q2d | int(11) | YES | |
| BASE TABLE | gmcpq | q2e | int(11) | YES | |
| BASE TABLE | gmcpq | q2f | int(11) | YES | |
| BASE TABLE | gmcpq | q2f_details | text | YES | |
| BASE TABLE | gmcpq | q3 | int(11) | YES | |
| BASE TABLE | gmcpq | q4a | int(11) | YES | |
| BASE TABLE | gmcpq | q4b | int(11) | YES | |
| BASE TABLE | gmcpq | q4c | int(11) | YES | |
| BASE TABLE | gmcpq | q4d | int(11) | YES | |
| BASE TABLE | gmcpq | q4e | int(11) | YES | |
| BASE TABLE | gmcpq | q4f | int(11) | YES | |
| BASE TABLE | gmcpq | q4g | int(11) | YES | |
| BASE TABLE | gmcpq | q5a | int(11) | YES | |
| BASE TABLE | gmcpq | q5b | int(11) | YES | |
| BASE TABLE | gmcpq | q6 | int(11) | YES | |
| BASE TABLE | gmcpq | q7 | int(11) | YES | |
| BASE TABLE | gmcpq | q8 | int(11) | YES | |
| BASE TABLE | gmcpq | q9 | text | YES | |
| BASE TABLE | gmcpq | q10 | text | YES | |
| BASE TABLE | gmcpq | q11 | int(11) | YES | |
| BASE TABLE | gmcpq | q12 | int(11) | YES | |
| BASE TABLE | gmcpq | q12_details | text | YES | |
| BASE TABLE | hama | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | hama | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | hama | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | hama | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | hama | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | hama | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | hama | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | hama | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | hama | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | hama | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | hama | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | hama | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | hama | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | hama | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | hama | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | hama | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | hama | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | hama | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | hama | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | hama | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | hama | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | hama | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | hama | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | hama | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | hama | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | hama | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | hama | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | hama | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | hama | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | hama | q1 | int(11) | YES | |
| BASE TABLE | hama | q2 | int(11) | YES | |
| BASE TABLE | hama | q3 | int(11) | YES | |
| BASE TABLE | hama | q4 | int(11) | YES | |
| BASE TABLE | hama | q5 | int(11) | YES | |
| BASE TABLE | hama | q6 | int(11) | YES | |
| BASE TABLE | hama | q7 | int(11) | YES | |
| BASE TABLE | hama | q8 | int(11) | YES | |
| BASE TABLE | hama | q9 | int(11) | YES | |
| BASE TABLE | hama | q10 | int(11) | YES | |
| BASE TABLE | hama | q11 | int(11) | YES | |
| BASE TABLE | hama | q12 | int(11) | YES | |
| BASE TABLE | hama | q13 | int(11) | YES | |
| BASE TABLE | hama | q14 | int(11) | YES | |
| BASE TABLE | hama_SUMMARY_TEMP | hama_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | hama_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | hama_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | hama_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | hama_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | hama_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | hamd | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | hamd | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | hamd | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | hamd | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | hamd | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | hamd | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | hamd | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | hamd | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | hamd | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | hamd | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | hamd | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | hamd | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | hamd | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | hamd | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | hamd | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | hamd | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | hamd | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | hamd | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | hamd | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | hamd | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | hamd | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | hamd | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | hamd | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | hamd | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | hamd | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | hamd | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | hamd | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | hamd | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | hamd | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | hamd | q1 | int(11) | YES | |
| BASE TABLE | hamd | q2 | int(11) | YES | |
| BASE TABLE | hamd | q3 | int(11) | YES | |
| BASE TABLE | hamd | q4 | int(11) | YES | |
| BASE TABLE | hamd | q5 | int(11) | YES | |
| BASE TABLE | hamd | q6 | int(11) | YES | |
| BASE TABLE | hamd | q7 | int(11) | YES | |
| BASE TABLE | hamd | q8 | int(11) | YES | |
| BASE TABLE | hamd | q9 | int(11) | YES | |
| BASE TABLE | hamd | q10 | int(11) | YES | |
| BASE TABLE | hamd | q11 | int(11) | YES | |
| BASE TABLE | hamd | q12 | int(11) | YES | |
| BASE TABLE | hamd | q13 | int(11) | YES | |
| BASE TABLE | hamd | q14 | int(11) | YES | |
| BASE TABLE | hamd | q15 | int(11) | YES | |
| BASE TABLE | hamd | whichq16 | int(11) | YES | |
| BASE TABLE | hamd | q16a | int(11) | YES | |
| BASE TABLE | hamd | q16b | int(11) | YES | |
| BASE TABLE | hamd | q17 | int(11) | YES | |
| BASE TABLE | hamd | q18a | int(11) | YES | |
| BASE TABLE | hamd | q18b | int(11) | YES | |
| BASE TABLE | hamd | q19 | int(11) | YES | |
| BASE TABLE | hamd | q20 | int(11) | YES | |
| BASE TABLE | hamd | q21 | int(11) | YES | |
| BASE TABLE | hamd7 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | hamd7 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | hamd7 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | hamd7 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | hamd7 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | hamd7 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | hamd7 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | hamd7 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | hamd7 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | hamd7 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | hamd7 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | hamd7 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | hamd7 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | hamd7 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | hamd7 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | hamd7 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | hamd7 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | hamd7 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | hamd7 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | hamd7 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | hamd7 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | hamd7 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | hamd7 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | hamd7 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | hamd7 | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | hamd7 | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | hamd7 | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | hamd7 | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | hamd7 | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | hamd7 | q1 | int(11) | YES | |
| BASE TABLE | hamd7 | q2 | int(11) | YES | |
| BASE TABLE | hamd7 | q3 | int(11) | YES | |
| BASE TABLE | hamd7 | q4 | int(11) | YES | |
| BASE TABLE | hamd7 | q5 | int(11) | YES | |
| BASE TABLE | hamd7 | q6 | int(11) | YES | |
| BASE TABLE | hamd7 | q7 | int(11) | YES | |
| BASE TABLE | hamd7_SUMMARY_TEMP | hamd7_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | hamd7_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | hamd7_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | hamd7_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | hamd7_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | hamd7_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | hamd_SUMMARY_TEMP | hamd_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | hamd_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | hamd_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | hamd_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | hamd_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | hamd_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | honos | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | honos | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | honos | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | honos | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | honos | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | honos | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | honos | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | honos | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | honos | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | honos | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | honos | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | honos | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | honos | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | honos | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | honos | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | honos | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | honos | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | honos | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | honos | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | honos | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | honos | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | honos | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | honos | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | honos | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | honos | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | honos | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | honos | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | honos | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | honos | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | honos | q1 | int(11) | YES | |
| BASE TABLE | honos | q2 | int(11) | YES | |
| BASE TABLE | honos | q3 | int(11) | YES | |
| BASE TABLE | honos | q4 | int(11) | YES | |
| BASE TABLE | honos | q5 | int(11) | YES | |
| BASE TABLE | honos | q6 | int(11) | YES | |
| BASE TABLE | honos | q7 | int(11) | YES | |
| BASE TABLE | honos | q8 | int(11) | YES | |
| BASE TABLE | honos | q9 | int(11) | YES | |
| BASE TABLE | honos | q10 | int(11) | YES | |
| BASE TABLE | honos | q11 | int(11) | YES | |
| BASE TABLE | honos | q12 | int(11) | YES | |
| BASE TABLE | honos | period_rated | text | YES | |
| BASE TABLE | honos | q8problemtype | varchar(1) | YES | |
| BASE TABLE | honos | q8otherproblem | text | YES | |
| BASE TABLE | honos65 | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | honos65 | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | honos65 | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | honos65 | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | honos65 | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | honos65 | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | honos65 | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | honos65 | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | honos65 | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | honos65 | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | honos65 | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | honos65 | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | honos65 | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | honos65 | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | honos65 | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | honos65 | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | honos65 | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | honos65 | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | honos65 | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | honos65 | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | honos65 | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | honos65 | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | honos65 | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | honos65 | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | honos65 | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | honos65 | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | honos65 | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | honos65 | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | honos65 | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | honos65 | q1 | int(11) | YES | |
| BASE TABLE | honos65 | q2 | int(11) | YES | |
| BASE TABLE | honos65 | q3 | int(11) | YES | |
| BASE TABLE | honos65 | q4 | int(11) | YES | |
| BASE TABLE | honos65 | q5 | int(11) | YES | |
| BASE TABLE | honos65 | q6 | int(11) | YES | |
| BASE TABLE | honos65 | q7 | int(11) | YES | |
| BASE TABLE | honos65 | q8 | int(11) | YES | |
| BASE TABLE | honos65 | q9 | int(11) | YES | |
| BASE TABLE | honos65 | q10 | int(11) | YES | |
| BASE TABLE | honos65 | q11 | int(11) | YES | |
| BASE TABLE | honos65 | q12 | int(11) | YES | |
| BASE TABLE | honos65 | period_rated | text | YES | |
| BASE TABLE | honos65 | q8problemtype | varchar(1) | YES | |
| BASE TABLE | honos65 | q8otherproblem | text | YES | |
| BASE TABLE | honos65_SUMMARY_TEMP | honos65_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | honos65_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | honos65_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | honos65_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | honos65_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | honos65_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | honos_SUMMARY_TEMP | honos_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | honos_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | honos_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | honos_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | honos_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | honos_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | honosca | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | honosca | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | honosca | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | honosca | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | honosca | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | honosca | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | honosca | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | honosca | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | honosca | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | honosca | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | honosca | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | honosca | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | honosca | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | honosca | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | honosca | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | honosca | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | honosca | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | honosca | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | honosca | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | honosca | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | honosca | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | honosca | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | honosca | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | honosca | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | honosca | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | honosca | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | honosca | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | honosca | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | honosca | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | honosca | q1 | int(11) | YES | |
| BASE TABLE | honosca | q2 | int(11) | YES | |
| BASE TABLE | honosca | q3 | int(11) | YES | |
| BASE TABLE | honosca | q4 | int(11) | YES | |
| BASE TABLE | honosca | q5 | int(11) | YES | |
| BASE TABLE | honosca | q6 | int(11) | YES | |
| BASE TABLE | honosca | q7 | int(11) | YES | |
| BASE TABLE | honosca | q8 | int(11) | YES | |
| BASE TABLE | honosca | q9 | int(11) | YES | |
| BASE TABLE | honosca | q10 | int(11) | YES | |
| BASE TABLE | honosca | q11 | int(11) | YES | |
| BASE TABLE | honosca | q12 | int(11) | YES | |
| BASE TABLE | honosca | q13 | int(11) | YES | |
| BASE TABLE | honosca | q14 | int(11) | YES | |
| BASE TABLE | honosca | q15 | int(11) | YES | |
| BASE TABLE | honosca | period_rated | text | YES | |
| BASE TABLE | honosca_SUMMARY_TEMP | honosca_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | honosca_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | honosca_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | honosca_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | honosca_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | honosca_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | icd10depressive | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10depressive | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10depressive | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10depressive | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10depressive | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10depressive | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10depressive | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10depressive | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10depressive | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10depressive | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10depressive | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10depressive | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10depressive | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10depressive | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10depressive | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10depressive | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10depressive | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10depressive | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10depressive | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10depressive | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10depressive | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10depressive | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10depressive | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10depressive | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10depressive | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10depressive | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10depressive | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10depressive | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10depressive | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10depressive | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10depressive | comments | text | YES | |
| BASE TABLE | icd10depressive | duration_at_least_2_weeks | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | severe_clinically | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | mood | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | anhedonia | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | energy | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | sleep | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | worth | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | appetite | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | guilt | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | concentration | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | activity | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | death | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_anhedonia | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_emotional_unreactivity | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_early_morning_waking | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_mood_worse_morning | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_psychomotor | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_appetite | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_weight | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | somatic_libido | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | hallucinations_schizophrenic | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | hallucinations_other | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | delusions_schizophrenic | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | delusions_other | tinyint(1) | YES | |
| BASE TABLE | icd10depressive | stupor | tinyint(1) | YES | |
| BASE TABLE | icd10manic | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10manic | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10manic | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10manic | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10manic | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10manic | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10manic | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10manic | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10manic | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10manic | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10manic | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10manic | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10manic | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10manic | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10manic | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10manic | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10manic | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10manic | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10manic | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10manic | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10manic | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10manic | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10manic | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10manic | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10manic | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10manic | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10manic | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10manic | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10manic | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10manic | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10manic | comments | text | YES | |
| BASE TABLE | icd10manic | mood_elevated | tinyint(1) | YES | |
| BASE TABLE | icd10manic | mood_irritable | tinyint(1) | YES | |
| BASE TABLE | icd10manic | distractible | tinyint(1) | YES | |
| BASE TABLE | icd10manic | activity | tinyint(1) | YES | |
| BASE TABLE | icd10manic | sleep | tinyint(1) | YES | |
| BASE TABLE | icd10manic | talkativeness | tinyint(1) | YES | |
| BASE TABLE | icd10manic | recklessness | tinyint(1) | YES | |
| BASE TABLE | icd10manic | social_disinhibition | tinyint(1) | YES | |
| BASE TABLE | icd10manic | sexual | tinyint(1) | YES | |
| BASE TABLE | icd10manic | grandiosity | tinyint(1) | YES | |
| BASE TABLE | icd10manic | flight_of_ideas | tinyint(1) | YES | |
| BASE TABLE | icd10manic | sustained4days | tinyint(1) | YES | |
| BASE TABLE | icd10manic | sustained7days | tinyint(1) | YES | |
| BASE TABLE | icd10manic | admission_required | tinyint(1) | YES | |
| BASE TABLE | icd10manic | some_interference_functioning | tinyint(1) | YES | |
| BASE TABLE | icd10manic | severe_interference_functioning | tinyint(1) | YES | |
| BASE TABLE | icd10manic | perceptual_alterations | tinyint(1) | YES | |
| BASE TABLE | icd10manic | hallucinations_schizophrenic | tinyint(1) | YES | |
| BASE TABLE | icd10manic | hallucinations_other | tinyint(1) | YES | |
| BASE TABLE | icd10manic | delusions_schizophrenic | tinyint(1) | YES | |
| BASE TABLE | icd10manic | delusions_other | tinyint(1) | YES | |
| BASE TABLE | icd10mixed | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10mixed | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10mixed | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10mixed | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10mixed | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10mixed | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10mixed | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10mixed | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10mixed | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10mixed | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10mixed | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10mixed | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10mixed | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10mixed | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10mixed | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10mixed | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10mixed | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10mixed | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10mixed | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10mixed | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10mixed | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10mixed | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10mixed | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10mixed | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10mixed | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10mixed | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10mixed | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10mixed | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10mixed | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10mixed | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10mixed | comments | text | YES | |
| BASE TABLE | icd10mixed | mixture_or_rapid_alternation | tinyint(1) | YES | |
| BASE TABLE | icd10mixed | duration_at_least_2_weeks | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10schizophrenia | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10schizophrenia | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10schizophrenia | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10schizophrenia | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10schizophrenia | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10schizophrenia | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10schizophrenia | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10schizophrenia | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10schizophrenia | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10schizophrenia | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10schizophrenia | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10schizophrenia | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10schizophrenia | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10schizophrenia | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10schizophrenia | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10schizophrenia | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10schizophrenia | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10schizophrenia | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10schizophrenia | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10schizophrenia | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10schizophrenia | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10schizophrenia | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10schizophrenia | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10schizophrenia | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10schizophrenia | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10schizophrenia | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10schizophrenia | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10schizophrenia | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10schizophrenia | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10schizophrenia | comments | text | YES | |
| BASE TABLE | icd10schizophrenia | passivity_bodily | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | passivity_mental | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | tpah_commentary | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | tpah_discussing | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | tpah_from_body | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | delusions | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | delusional_perception | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | thought_echo | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | thought_withdrawal | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | thought_insertion | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | thought_broadcasting | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | hallucinations_other | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | thought_disorder | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | catatonia | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | negative | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | present_one_month | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | also_manic | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | also_depressive | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | if_mood_psychosis_first | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | not_organic_or_substance | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | behaviour_change | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | performance_decline | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_paranoid | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_hebephrenic | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_catatonic | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_undifferentiated | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_postschizophrenic_depression | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_residual | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_simple | tinyint(1) | YES | |
| BASE TABLE | icd10schizophrenia | subtype_cenesthopathic | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10schizotypal | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10schizotypal | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10schizotypal | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10schizotypal | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10schizotypal | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10schizotypal | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10schizotypal | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10schizotypal | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10schizotypal | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10schizotypal | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10schizotypal | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10schizotypal | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10schizotypal | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10schizotypal | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10schizotypal | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10schizotypal | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10schizotypal | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10schizotypal | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10schizotypal | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10schizotypal | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10schizotypal | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10schizotypal | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10schizotypal | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10schizotypal | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10schizotypal | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10schizotypal | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10schizotypal | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10schizotypal | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10schizotypal | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10schizotypal | comments | text | YES | |
| BASE TABLE | icd10schizotypal | b | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a1 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a2 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a3 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a4 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a5 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a6 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a7 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a8 | tinyint(1) | YES | |
| BASE TABLE | icd10schizotypal | a9 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | icd10specpd | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | icd10specpd | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | icd10specpd | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | icd10specpd | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | icd10specpd | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | icd10specpd | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | icd10specpd | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | icd10specpd | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | icd10specpd | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | icd10specpd | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | icd10specpd | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | icd10specpd | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | icd10specpd | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | icd10specpd | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | icd10specpd | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | icd10specpd | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | icd10specpd | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | icd10specpd | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | icd10specpd | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | icd10specpd | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | icd10specpd | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | icd10specpd | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | icd10specpd | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | icd10specpd | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | icd10specpd | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | icd10specpd | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | icd10specpd | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | icd10specpd | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | icd10specpd | date_pertains_to | varchar(32) | YES | |
| BASE TABLE | icd10specpd | comments | text | YES | |
| BASE TABLE | icd10specpd | skip_paranoid | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_schizoid | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_dissocial | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_eu | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_histrionic | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_anankastic | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_anxious | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | skip_dependent | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | vignette | text | YES | |
| BASE TABLE | icd10specpd | g1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g1_1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g1_2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g1_3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | g1_4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | paranoid7 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid7 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid8 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | schizoid9 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dissocial6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu7 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu8 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu9 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | eu10 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | histrionic6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic6 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic7 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anankastic8 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anxious1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anxious2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anxious3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anxious4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | anxious5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent1 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent2 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent3 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent4 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent5 | tinyint(1) | YES | |
| BASE TABLE | icd10specpd | dependent6 | tinyint(1) | YES | |
| BASE TABLE | mast | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | mast | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | mast | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | mast | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | mast | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | mast | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | mast | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | mast | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | mast | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | mast | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | mast | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | mast | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | mast | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | mast | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | mast | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | mast | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | mast | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | mast | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | mast | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | mast | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | mast | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | mast | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | mast | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | mast | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | mast | q1 | varchar(1) | YES | |
| BASE TABLE | mast | q2 | varchar(1) | YES | |
| BASE TABLE | mast | q3 | varchar(1) | YES | |
| BASE TABLE | mast | q4 | varchar(1) | YES | |
| BASE TABLE | mast | q5 | varchar(1) | YES | |
| BASE TABLE | mast | q6 | varchar(1) | YES | |
| BASE TABLE | mast | q7 | varchar(1) | YES | |
| BASE TABLE | mast | q8 | varchar(1) | YES | |
| BASE TABLE | mast | q9 | varchar(1) | YES | |
| BASE TABLE | mast | q10 | varchar(1) | YES | |
| BASE TABLE | mast | q11 | varchar(1) | YES | |
| BASE TABLE | mast | q12 | varchar(1) | YES | |
| BASE TABLE | mast | q13 | varchar(1) | YES | |
| BASE TABLE | mast | q14 | varchar(1) | YES | |
| BASE TABLE | mast | q15 | varchar(1) | YES | |
| BASE TABLE | mast | q16 | varchar(1) | YES | |
| BASE TABLE | mast | q17 | varchar(1) | YES | |
| BASE TABLE | mast | q18 | varchar(1) | YES | |
| BASE TABLE | mast | q19 | varchar(1) | YES | |
| BASE TABLE | mast | q20 | varchar(1) | YES | |
| BASE TABLE | mast | q21 | varchar(1) | YES | |
| BASE TABLE | mast | q22 | varchar(1) | YES | |
| BASE TABLE | mast | q23 | varchar(1) | YES | |
| BASE TABLE | mast | q24 | varchar(1) | YES | |
| BASE TABLE | mast_SUMMARY_TEMP | mast_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | mast_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | mast_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | mast_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | mast_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | mast_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | moca | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | moca | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | moca | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | moca | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | moca | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | moca | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | moca | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | moca | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | moca | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | moca | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | moca | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | moca | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | moca | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | moca | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | moca | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | moca | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | moca | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | moca | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | moca | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | moca | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | moca | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | moca | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | moca | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | moca | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | moca | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | moca | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | moca | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | moca | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | moca | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | moca | q1 | int(11) | YES | |
| BASE TABLE | moca | q2 | int(11) | YES | |
| BASE TABLE | moca | q3 | int(11) | YES | |
| BASE TABLE | moca | q4 | int(11) | YES | |
| BASE TABLE | moca | q5 | int(11) | YES | |
| BASE TABLE | moca | q6 | int(11) | YES | |
| BASE TABLE | moca | q7 | int(11) | YES | |
| BASE TABLE | moca | q8 | int(11) | YES | |
| BASE TABLE | moca | q9 | int(11) | YES | |
| BASE TABLE | moca | q10 | int(11) | YES | |
| BASE TABLE | moca | q11 | int(11) | YES | |
| BASE TABLE | moca | q12 | int(11) | YES | |
| BASE TABLE | moca | q13 | int(11) | YES | |
| BASE TABLE | moca | q14 | int(11) | YES | |
| BASE TABLE | moca | q15 | int(11) | YES | |
| BASE TABLE | moca | q16 | int(11) | YES | |
| BASE TABLE | moca | q17 | int(11) | YES | |
| BASE TABLE | moca | q18 | int(11) | YES | |
| BASE TABLE | moca | q19 | int(11) | YES | |
| BASE TABLE | moca | q20 | int(11) | YES | |
| BASE TABLE | moca | q21 | int(11) | YES | |
| BASE TABLE | moca | q22 | int(11) | YES | |
| BASE TABLE | moca | q23 | int(11) | YES | |
| BASE TABLE | moca | q24 | int(11) | YES | |
| BASE TABLE | moca | q25 | int(11) | YES | |
| BASE TABLE | moca | q26 | int(11) | YES | |
| BASE TABLE | moca | q27 | int(11) | YES | |
| BASE TABLE | moca | q28 | int(11) | YES | |
| BASE TABLE | moca | education12y_or_less | int(11) | YES | |
| BASE TABLE | moca | trailpicture_blobid | int(11) | YES | |
| BASE TABLE | moca | cubepicture_blobid | int(11) | YES | |
| BASE TABLE | moca | clockpicture_blobid | int(11) | YES | |
| BASE TABLE | moca | register_trial1_1 | int(11) | YES | |
| BASE TABLE | moca | register_trial1_2 | int(11) | YES | |
| BASE TABLE | moca | register_trial1_3 | int(11) | YES | |
| BASE TABLE | moca | register_trial1_4 | int(11) | YES | |
| BASE TABLE | moca | register_trial1_5 | int(11) | YES | |
| BASE TABLE | moca | register_trial2_1 | int(11) | YES | |
| BASE TABLE | moca | register_trial2_2 | int(11) | YES | |
| BASE TABLE | moca | register_trial2_3 | int(11) | YES | |
| BASE TABLE | moca | register_trial2_4 | int(11) | YES | |
| BASE TABLE | moca | register_trial2_5 | int(11) | YES | |
| BASE TABLE | moca | recall_category_cue_1 | int(11) | YES | |
| BASE TABLE | moca | recall_category_cue_2 | int(11) | YES | |
| BASE TABLE | moca | recall_category_cue_3 | int(11) | YES | |
| BASE TABLE | moca | recall_category_cue_4 | int(11) | YES | |
| BASE TABLE | moca | recall_category_cue_5 | int(11) | YES | |
| BASE TABLE | moca | recall_mc_cue_1 | int(11) | YES | |
| BASE TABLE | moca | recall_mc_cue_2 | int(11) | YES | |
| BASE TABLE | moca | recall_mc_cue_3 | int(11) | YES | |
| BASE TABLE | moca | recall_mc_cue_4 | int(11) | YES | |
| BASE TABLE | moca | recall_mc_cue_5 | int(11) | YES | |
| BASE TABLE | moca | comments | text | YES | |
| BASE TABLE | moca_SUMMARY_TEMP | moca_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | moca_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | moca_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | moca_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | moca_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | moca_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | nart | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | nart | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | nart | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | nart | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | nart | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | nart | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | nart | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | nart | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | nart | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | nart | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | nart | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | nart | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | nart | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | nart | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | nart | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | nart | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | nart | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | nart | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | nart | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | nart | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | nart | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | nart | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | nart | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | nart | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | nart | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | nart | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | nart | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | nart | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | nart | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | nart | chord | tinyint(1) | YES | |
| BASE TABLE | nart | ache | tinyint(1) | YES | |
| BASE TABLE | nart | depot | tinyint(1) | YES | |
| BASE TABLE | nart | aisle | tinyint(1) | YES | |
| BASE TABLE | nart | bouquet | tinyint(1) | YES | |
| BASE TABLE | nart | psalm | tinyint(1) | YES | |
| BASE TABLE | nart | capon | tinyint(1) | YES | |
| BASE TABLE | nart | deny | tinyint(1) | YES | |
| BASE TABLE | nart | nausea | tinyint(1) | YES | |
| BASE TABLE | nart | debt | tinyint(1) | YES | |
| BASE TABLE | nart | courteous | tinyint(1) | YES | |
| BASE TABLE | nart | rarefy | tinyint(1) | YES | |
| BASE TABLE | nart | equivocal | tinyint(1) | YES | |
| BASE TABLE | nart | naive | tinyint(1) | YES | |
| BASE TABLE | nart | catacomb | tinyint(1) | YES | |
| BASE TABLE | nart | gaoled | tinyint(1) | YES | |
| BASE TABLE | nart | thyme | tinyint(1) | YES | |
| BASE TABLE | nart | heir | tinyint(1) | YES | |
| BASE TABLE | nart | radix | tinyint(1) | YES | |
| BASE TABLE | nart | assignate | tinyint(1) | YES | |
| BASE TABLE | nart | hiatus | tinyint(1) | YES | |
| BASE TABLE | nart | subtle | tinyint(1) | YES | |
| BASE TABLE | nart | procreate | tinyint(1) | YES | |
| BASE TABLE | nart | gist | tinyint(1) | YES | |
| BASE TABLE | nart | gouge | tinyint(1) | YES | |
| BASE TABLE | nart | superfluous | tinyint(1) | YES | |
| BASE TABLE | nart | simile | tinyint(1) | YES | |
| BASE TABLE | nart | banal | tinyint(1) | YES | |
| BASE TABLE | nart | quadruped | tinyint(1) | YES | |
| BASE TABLE | nart | cellist | tinyint(1) | YES | |
| BASE TABLE | nart | facade | tinyint(1) | YES | |
| BASE TABLE | nart | zealot | tinyint(1) | YES | |
| BASE TABLE | nart | drachm | tinyint(1) | YES | |
| BASE TABLE | nart | aeon | tinyint(1) | YES | |
| BASE TABLE | nart | placebo | tinyint(1) | YES | |
| BASE TABLE | nart | abstemious | tinyint(1) | YES | |
| BASE TABLE | nart | detente | tinyint(1) | YES | |
| BASE TABLE | nart | idyll | tinyint(1) | YES | |
| BASE TABLE | nart | puerperal | tinyint(1) | YES | |
| BASE TABLE | nart | aver | tinyint(1) | YES | |
| BASE TABLE | nart | gauche | tinyint(1) | YES | |
| BASE TABLE | nart | topiary | tinyint(1) | YES | |
| BASE TABLE | nart | leviathan | tinyint(1) | YES | |
| BASE TABLE | nart | beatify | tinyint(1) | YES | |
| BASE TABLE | nart | prelate | tinyint(1) | YES | |
| BASE TABLE | nart | sidereal | tinyint(1) | YES | |
| BASE TABLE | nart | demesne | tinyint(1) | YES | |
| BASE TABLE | nart | syncope | tinyint(1) | YES | |
| BASE TABLE | nart | labile | tinyint(1) | YES | |
| BASE TABLE | nart | campanile | tinyint(1) | YES | |
| BASE TABLE | nart_SUMMARY_TEMP | nart_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | nart_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | nart_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | nart_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | nart_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | nart_SUMMARY_TEMP | fsiq | double | YES | |
| BASE TABLE | nart_SUMMARY_TEMP | viq | double | YES | |
| BASE TABLE | nart_SUMMARY_TEMP | piq | double | YES | |
| BASE TABLE | panss | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | panss | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | panss | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | panss | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | panss | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | panss | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |
| BASE TABLE | panss | _adding_user | varchar(255) | YES | (SERVER) User that added this row |
| BASE TABLE | panss | _when_removed_exact | varchar(32) | YES | (SERVER) Date/time this row was removed, i.e. made not current (ISO 8601) |
| BASE TABLE | panss | _when_removed_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that removed this row (DATETIME in UTC) |
| BASE TABLE | panss | _removing_user | varchar(255) | YES | (SERVER) User that removed this row |
| BASE TABLE | panss | _preserving_user | varchar(255) | YES | (SERVER) User that preserved this row |
| BASE TABLE | panss | _predecessor_pk | int(11) | YES | (SERVER) PK of predecessor record, prior to modification |
| BASE TABLE | panss | _successor_pk | int(11) | YES | (SERVER) PK of successor record (after modification) or NULL (after deletion) |
| BASE TABLE | panss | _camcops_version | double | YES | (SERVER) CamCOPS version number of the uploading device |
| BASE TABLE | panss | _addition_pending | tinyint(1) | NO | (SERVER) Addition pending? |
| BASE TABLE | panss | _removal_pending | tinyint(1) | NO | (SERVER) Removal pending? |
| BASE TABLE | panss | _move_off_tablet | tinyint(1) | YES | (SERVER/TABLET) Record-specific preservation pending? |
| BASE TABLE | panss | when_last_modified | varchar(32) | YES | (STANDARD) Date/time this row was last modified on the source tablet device (ISO 8601) |
| BASE TABLE | panss | id | int(11) | NO | (TASK) Primary key (task ID) on the tablet device |
| BASE TABLE | panss | patient_id | int(11) | NO | (TASK) Foreign key to patient.id for this device |
| BASE TABLE | panss | when_created | varchar(32) | NO | (TASK) Date/time this task instance was created (ISO 8601) |
| BASE TABLE | panss | when_firstexit | varchar(32) | YES | (TASK) Date/time of the first exit from this task (ISO 8601) |
| BASE TABLE | panss | firstexit_is_finish | tinyint(1) | YES | (TASK) Was the first exit from the task because it was finished (1)? |
| BASE TABLE | panss | firstexit_is_abort | tinyint(1) | YES | (TASK) Was the first exit from this task because it was aborted (1)? |
| BASE TABLE | panss | clinician_specialty | text | YES | Clinician's specialty (e.g. Liaison Psychiatry) |
| BASE TABLE | panss | clinician_name | text | YES | Clinician's name (e.g. Dr X) |
| BASE TABLE | panss | clinician_post | text | YES | Clinician's post (e.g. Consultant) |
| BASE TABLE | panss | clinician_professional_registration | text | YES | Clinician's professional registration (e.g. GMC# 12345) |
| BASE TABLE | panss | clinician_contact_details | text | YES | Clinician's contact details (e.g. bleep, extension) |
| BASE TABLE | panss | p1 | int(11) | YES | |
| BASE TABLE | panss | p2 | int(11) | YES | |
| BASE TABLE | panss | p3 | int(11) | YES | |
| BASE TABLE | panss | p4 | int(11) | YES | |
| BASE TABLE | panss | p5 | int(11) | YES | |
| BASE TABLE | panss | p6 | int(11) | YES | |
| BASE TABLE | panss | p7 | int(11) | YES | |
| BASE TABLE | panss | n1 | int(11) | YES | |
| BASE TABLE | panss | n2 | int(11) | YES | |
| BASE TABLE | panss | n3 | int(11) | YES | |
| BASE TABLE | panss | n4 | int(11) | YES | |
| BASE TABLE | panss | n5 | int(11) | YES | |
| BASE TABLE | panss | n6 | int(11) | YES | |
| BASE TABLE | panss | n7 | int(11) | YES | |
| BASE TABLE | panss | g1 | int(11) | YES | |
| BASE TABLE | panss | g2 | int(11) | YES | |
| BASE TABLE | panss | g3 | int(11) | YES | |
| BASE TABLE | panss | g4 | int(11) | YES | |
| BASE TABLE | panss | g5 | int(11) | YES | |
| BASE TABLE | panss | g6 | int(11) | YES | |
| BASE TABLE | panss | g7 | int(11) | YES | |
| BASE TABLE | panss | g8 | int(11) | YES | |
| BASE TABLE | panss | g9 | int(11) | YES | |
| BASE TABLE | panss | g10 | int(11) | YES | |
| BASE TABLE | panss | g11 | int(11) | YES | |
| BASE TABLE | panss | g12 | int(11) | YES | |
| BASE TABLE | panss | g13 | int(11) | YES | |
| BASE TABLE | panss | g14 | int(11) | YES | |
| BASE TABLE | panss | g15 | int(11) | YES | |
| BASE TABLE | panss | g16 | int(11) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | panss_pk | int(11) | NO | FK to the source table's _pk field |
| BASE TABLE | panss_SUMMARY_TEMP | when_source_record_created_utc | datetime | YES | When was the source record created? |
| BASE TABLE | panss_SUMMARY_TEMP | when_summary_created_utc | datetime | YES | When was this summary created? |
| BASE TABLE | panss_SUMMARY_TEMP | seconds_from_creation_to_first_finish | double | YES | Time (in seconds) from record creation to first exit, if that was a finish not an abort |
| BASE TABLE | panss_SUMMARY_TEMP | is_complete | tinyint(1) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | total | int(11) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | p | int(11) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | n | int(11) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | g | int(11) | YES | |
| BASE TABLE | panss_SUMMARY_TEMP | composite | int(11) | YES | |
| BASE TABLE | patient | _pk | int(11) | NO | (SERVER) Primary key (on the server) |
| BASE TABLE | patient | _device | varchar(255) | NO | (SERVER) ID of the source tablet device |
| BASE TABLE | patient | _era | varchar(32) | NO | (SERVER) 'NOW', or when this row was preserved and removed from the source device (UTC ISO 8601) |
| BASE TABLE | patient | _current | tinyint(1) | NO | (SERVER) Is the row current (1) or not (0)? |
| BASE TABLE | patient | _when_added_exact | varchar(32) | YES | (SERVER) Date/time this row was added (ISO 8601) |
| BASE TABLE | patient | _when_added_batch_utc | datetime | YES | (SERVER) Date/time of the upload batch that added this row (DATETIME in UTC) |