ygtss_revised

Assessment tool used to quantify the severity of tic symptoms.

Assessment tool used to quantify the severity of tic symptoms.

Purpose. To record the results for each component parameter, the Total tic score and the Global severity score.

Source

Columns

Constraints

check ((impairment_scale_code is null and impairment_scale_system is null and impairment_scale_numeric is null and impairment_scale is null) or (impairment_scale_valueset_id is not null and impairment_scale_code is not null and impairment_scale_system is not null and impairment_scale_numeric is not null and impairment_scale is not null))
check (total_tic_score is null or total_tic_score between 0 and 50)
check (global_severity_score is null or global_severity_score between 0 and 100)

Unique

• form_block_id

References

Referenced by

• ygtss_revised_simple_motor_tics_checklist_other_simple_m_12ffaf via ygtss_revised_id
• ygtss_revised_complex_motor_tics_checklist_other_complex_9bd2b4 via ygtss_revised_id
• ygtss_revised_simple_phonic_symptoms_checklist_other_sim_08b6d2 via ygtss_revised_id
• ygtss_revised_complex_phonic_symptoms_checklist_other_co_c54c49 via ygtss_revised_id
• ygtss_revised_score via ygtss_revised_id

Indexes

• ygtss_revised_form_id_idx on form_id

Child tables

5 tables hang off ygtss_revised, one row per repetition.

ygtss_revised_simple_motor_tics_checklist_other_simple_m_12ffaf

Child table — one row per repetition, deleted with its parent.

Unique

• ygtss_revised_id, position

References

ygtss_revised_complex_motor_tics_checklist_other_complex_9bd2b4

Child table — one row per repetition, deleted with its parent.

Unique

• ygtss_revised_id, position

References

ygtss_revised_simple_phonic_symptoms_checklist_other_sim_08b6d2

Child table — one row per repetition, deleted with its parent.

Unique

• ygtss_revised_id, position

References

ygtss_revised_complex_phonic_symptoms_checklist_other_co_c54c49

Child table — one row per repetition, deleted with its parent.

Unique

• ygtss_revised_id, position

References

ygtss_revised_score

Child table — one row per repetition, deleted with its parent.

Constraints

check ((number_code is null and number_system is null and number_numeric is null and number is null) or (number_valueset_id is not null and number_code is not null and number_system is not null and number_numeric is not null and number is not null))
check ((frequency_code is null and frequency_system is null and frequency_numeric is null and frequency is null) or (frequency_valueset_id is not null and frequency_code is not null and frequency_system is not null and frequency_numeric is not null and frequency is not null))
check ((intensity_code is null and intensity_system is null and intensity_numeric is null and intensity is null) or (intensity_valueset_id is not null and intensity_code is not null and intensity_system is not null and intensity_numeric is not null and intensity is not null))
check ((complexity_code is null and complexity_system is null and complexity_numeric is null and complexity is null) or (complexity_valueset_id is not null and complexity_code is not null and complexity_system is not null and complexity_numeric is not null and complexity is not null))
check ((interference_code is null and interference_system is null and interference_numeric is null and interference is null) or (interference_valueset_id is not null and interference_code is not null and interference_system is not null and interference_numeric is not null and interference is not null))

Unique

• ygtss_revised_id, position

References

Value sets