---
title: "ygtss_revised"
description: "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

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.ygtss_revised.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/form) | no | The form this entry was recorded on. | — |
| `form_block_id` | `uuid` | yes | The block within the form, when the entry is bound to one. | — |
| `event_type` | `text` | yes | null represents any_event | — |
| `simple_motor_tics_checklist_eye_blinking` | `boolean` | yes | Eye blinking | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0007]` |
| `simple_motor_tics_checklist_eye_blinking_description` | `text` | yes | Eye blinking description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0167]` |
| `simple_motor_tics_checklist_eye_movements` | `boolean` | yes | Eye movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0009]` |
| `simple_motor_tics_checklist_eye_movements_description` | `text` | yes | Eye movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0168]` |
| `simple_motor_tics_checklist_nose_movements` | `boolean` | yes | Nose movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0011]` |
| `simple_motor_tics_checklist_nose_movements_description` | `text` | yes | Nose movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0169]` |
| `simple_motor_tics_checklist_mouth_movements` | `boolean` | yes | Mouth movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0158]` |
| `simple_motor_tics_checklist_mouth_movements_description` | `text` | yes | Mouth movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0170]` |
| `simple_motor_tics_checklist_facial_grimace` | `boolean` | yes | Facial grimace | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0013]` |
| `simple_motor_tics_checklist_facial_grimace_description` | `text` | yes | Facial grimace description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0171]` |
| `simple_motor_tics_checklist_head_jerks_movements` | `boolean` | yes | Head jerks/movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0015]` |
| `simple_motor_tics_checklist_head_jerks_movements_description` | `text` | yes | Head jerks/movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0172]` |
| `simple_motor_tics_checklist_shoulder_shrugs` | `boolean` | yes | Shoulder shrugs | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0017]` |
| `simple_motor_tics_checklist_shoulder_shrugs_description` | `text` | yes | Shoulder shrugs description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0173]` |
| `simple_motor_tics_checklist_arm_movements` | `boolean` | yes | Arm movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0019]` |
| `simple_motor_tics_checklist_arm_movements_description` | `text` | yes | Arm movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0174]` |
| `simple_motor_tics_checklist_hand_movements` | `boolean` | yes | Hand movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0021]` |
| `simple_motor_tics_checklist_hand_movements_description` | `text` | yes | Hand movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0175]` |
| `simple_motor_tics_checklist_abdominal_tensing` | `boolean` | yes | Abdominal tensing | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0023]` |
| `simple_motor_tics_checklist_abdominal_tensing_description` | `text` | yes | Abdominal tensing description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0176]` |
| `simple_motor_tics_checklist_leg_foot_or_toe_movements` | `boolean` | yes | Leg, foot, or toe movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0025]` |
| `simple_motor_tics_checklist_leg_foot_or_toe_movements_de_7c46d2` | `text` | yes | Leg, foot, or toe movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0177]` |
| `complex_motor_tics_checklist_eye_movements` | `boolean` | yes | Eye movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0030]` |
| `complex_motor_tics_checklist_eye_movements_description` | `text` | yes | Eye movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0178]` |
| `complex_motor_tics_checklist_mouth_movements` | `boolean` | yes | Mouth movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0032]` |
| `complex_motor_tics_checklist_mouth_movements_description` | `text` | yes | Mouth movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0179]` |
| `complex_motor_tics_checklist_facial_movements_or_expressions` | `boolean` | yes | Facial movements or expressions | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0034]` |
| `complex_motor_tics_checklist_facial_movements_or_express_526b79` | `text` | yes | Facial movements or expressions description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0180]` |
| `complex_motor_tics_checklist_head_gestures_or_movements` | `boolean` | yes | Head gestures or movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0036]` |
| `complex_motor_tics_checklist_head_gestures_or_movements__4b3e92` | `text` | yes | Head gestures or movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0182]` |
| `complex_motor_tics_checklist_shoulder_movements` | `boolean` | yes | Shoulder movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0038]` |
| `complex_motor_tics_checklist_shoulder_movements_description` | `text` | yes | Shoulder movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0181]` |
| `complex_motor_tics_checklist_arm_movements` | `boolean` | yes | Arm movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0040]` |
| `complex_motor_tics_checklist_arm_movements_description` | `text` | yes | Arm movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0183]` |
| `complex_motor_tics_checklist_hand_movements` | `boolean` | yes | Hand movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0042]` |
| `complex_motor_tics_checklist_hand_movements_description` | `text` | yes | Hand movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0184]` |
| `complex_motor_tics_checklist_writing_tics` | `boolean` | yes | Writing tics | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0044]` |
| `complex_motor_tics_checklist_writing_tics_description` | `text` | yes | Writing tics description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0185]` |
| `complex_motor_tics_checklist_dystonic_postures` | `boolean` | yes | Dystonic postures | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0046]` |
| `complex_motor_tics_checklist_dystonic_postures_description` | `text` | yes | Dystonic postures description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0186]` |
| `complex_motor_tics_checklist_bending_or_gyrating` | `boolean` | yes | Bending or gyrating | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0048]` |
| `complex_motor_tics_checklist_bending_or_gyrating_description` | `text` | yes | Bending or gyrating description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0187]` |
| `complex_motor_tics_checklist_rotating` | `boolean` | yes | Rotating | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0050]` |
| `complex_motor_tics_checklist_rotating_description` | `text` | yes | Rotating description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0188]` |
| `complex_motor_tics_checklist_leg_or_foot_or_toe_movements` | `boolean` | yes | Leg or foot or toe movements | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0052]` |
| `complex_motor_tics_checklist_leg_or_foot_or_toe_movement_5064af` | `text` | yes | Leg or foot or toe movements description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0189]` |
| `complex_motor_tics_checklist_blocking` | `boolean` | yes | Blocking | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0054]` |
| `complex_motor_tics_checklist_blocking_description` | `text` | yes | Blocking description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0190]` |
| `complex_motor_tics_checklist_tic_related_compulsive_behaviors` | `boolean` | yes | Tic related compulsive behaviors | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0056]` |
| `complex_motor_tics_checklist_tic_related_compulsive_beha_ccd919` | `text` | yes | Tic related compulsive behaviors description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0191]` |
| `complex_motor_tics_checklist_copropraxia` | `boolean` | yes | Copropraxia | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0058]` |
| `complex_motor_tics_checklist_copropraxia_description` | `text` | yes | Copropraxia description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0192]` |
| `complex_motor_tics_checklist_self_abusive_behavior` | `boolean` | yes | Self-abusive behavior | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0060]` |
| `complex_motor_tics_checklist_self_abusive_behavior_description` | `text` | yes | Self-abusive behavior description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0193]` |
| `complex_motor_tics_checklist_paroxysms_of_tics_displays` | `boolean` | yes | Paroxysms of tics (displays) | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0062]` |
| `complex_motor_tics_checklist_paroxysms_of_tics_displays__fe9d83` | `text` | yes | Paroxysms of tics (displays) description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0194]` |
| `complex_motor_tics_checklist_paroxysms_of_tics_duration` | `interval` | yes | Paroxysms of tics duration | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0064]` |
| `complex_motor_tics_checklist_disinhibited_behavior` | `boolean` | yes | Disinhibited behavior | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0102]` |
| `complex_motor_tics_checklist_disinhibited_behavior_description` | `text` | yes | Disinhibited behavior description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0103]` |
| `simple_phonic_symptoms_checklist_coughing` | `boolean` | yes | Coughing | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0070]` |
| `simple_phonic_symptoms_checklist_coughing_description` | `text` | yes | Coughing description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0195]` |
| `simple_phonic_symptoms_checklist_throat_clearing` | `boolean` | yes | Throat clearing | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0071]` |
| `simple_phonic_symptoms_checklist_throat_clearing_description` | `text` | yes | Throat clearing description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0196]` |
| `simple_phonic_symptoms_checklist_sniffing` | `boolean` | yes | Sniffing | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0072]` |
| `simple_phonic_symptoms_checklist_sniffing_description` | `text` | yes | Sniffing description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0197]` |
| `simple_phonic_symptoms_checklist_snorting` | `boolean` | yes | Snorting | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0073]` |
| `simple_phonic_symptoms_checklist_snorting_description` | `text` | yes | Snorting description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0198]` |
| `simple_phonic_symptoms_checklist_grunting` | `boolean` | yes | Grunting | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0074]` |
| `simple_phonic_symptoms_checklist_grunting_description` | `text` | yes | Grunting description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0199]` |
| `simple_phonic_symptoms_checklist_gulping` | `boolean` | yes | Gulping | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0075]` |
| `simple_phonic_symptoms_checklist_gulping_description` | `text` | yes | Gulping description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0200]` |
| `simple_phonic_symptoms_checklist_whistling` | `boolean` | yes | Whistling | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0076]` |
| `simple_phonic_symptoms_checklist_whistling_at0201` | `text` | yes | Whistling | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0201]` |
| `simple_phonic_symptoms_checklist_humming` | `boolean` | yes | Humming | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0077]` |
| `simple_phonic_symptoms_checklist_humming_description` | `text` | yes | Humming description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0202]` |
| `simple_phonic_symptoms_checklist_mouth_noises` | `boolean` | yes | Mouth noises | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0078]` |
| `simple_phonic_symptoms_checklist_mouth_noises_description` | `text` | yes | Mouth noises description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0203]` |
| `simple_phonic_symptoms_checklist_burping` | `boolean` | yes | Burping | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0079]` |
| `simple_phonic_symptoms_checklist_burping_description` | `text` | yes | Burping description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0204]` |
| `simple_phonic_symptoms_checklist_hiccups` | `boolean` | yes | Hiccups | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0080]` |
| `simple_phonic_symptoms_checklist_hiccups_description` | `text` | yes | Hiccups description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0205]` |
| `simple_phonic_symptoms_checklist_atypical_breathing_tics` | `boolean` | yes | Atypical breathing tics | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0081]` |
| `simple_phonic_symptoms_checklist_atypical_breathing_tics_0409e8` | `text` | yes | Atypical breathing tics description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0206]` |
| `simple_phonic_symptoms_checklist_chirping_or_other_bird_noises` | `boolean` | yes | Chirping or other bird noises | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0082]` |
| `simple_phonic_symptoms_checklist_chirping_or_other_bird__fe4427` | `text` | yes | Chirping or other bird noises description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0159]` |
| `simple_phonic_symptoms_checklist_barking_or_other_dog_noises` | `boolean` | yes | Barking or other dog noises | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0084]` |
| `simple_phonic_symptoms_checklist_barking_or_other_dog_no_9097b9` | `text` | yes | Barking or other dog noises description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0160]` |
| `simple_phonic_symptoms_checklist_other_animal_noises` | `boolean` | yes | Other animal noises | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0086]` |
| `simple_phonic_symptoms_checklist_other_animal_noises_des_0ae61f` | `text` | yes | Other animal noises description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0207]` |
| `complex_phonic_symptoms_checklist_syllables` | `boolean` | yes | Syllables | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0090]` |
| `complex_phonic_symptoms_checklist_syllables_descripion` | `text` | yes | Syllables descripion | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0161]` |
| `complex_phonic_symptoms_checklist_words` | `boolean` | yes | Words | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0091]` |
| `complex_phonic_symptoms_checklist_words_description` | `text` | yes | Words description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0162]` |
| `complex_phonic_symptoms_checklist_phrases` | `boolean` | yes | Phrases | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0092]` |
| `complex_phonic_symptoms_checklist_phrases_description` | `text` | yes | Phrases description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0163]` |
| `complex_phonic_symptoms_checklist_coprolalia` | `boolean` | yes | Coprolalia | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0093]` |
| `complex_phonic_symptoms_checklist_coprolalia_description` | `text` | yes | Coprolalia description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0164]` |
| `complex_phonic_symptoms_checklist_echolalia` | `boolean` | yes | Echolalia | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0094]` |
| `complex_phonic_symptoms_checklist_echolalia_description` | `text` | yes | Echolalia description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0208]` |
| `complex_phonic_symptoms_checklist_palalalia` | `boolean` | yes | Palalalia | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0095]` |
| `complex_phonic_symptoms_checklist_palalalia_description` | `text` | yes | Palalalia description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0209]` |
| `complex_phonic_symptoms_checklist_blocking` | `boolean` | yes | Blocking | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0096]` |
| `complex_phonic_symptoms_checklist_blocking_description` | `text` | yes | Blocking description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0210]` |
| `complex_phonic_symptoms_checklist_speech_atypicalities` | `boolean` | yes | Speech atypicalities | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0097]` |
| `complex_phonic_symptoms_checklist_speech_atypicalities_d_a02a73` | `text` | yes | Speech atypicalities description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0165]` |
| `complex_phonic_symptoms_checklist_disinhibited_speech` | `boolean` | yes | Disinhibited speech | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0098]` |
| `complex_phonic_symptoms_checklist_disinhibited_speech_de_376a87` | `text` | yes | Disinhibited speech description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0166]` |
| `impairment_scale`<br />`impairment_scale_code`<br />`impairment_scale_system`<br />`impairment_scale_numeric`<br />`impairment_scale_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Impairment scale | `/data[at0001]/events[at0002]/data[at0003]/items[at0143]` |
| `total_tic_score` | `integer` | yes | Total tic score | `/data[at0001]/events[at0002]/data[at0003]/items[at0150]` |
| `global_severity_score` | `integer` | yes | Global severity score | `/data[at0001]/events[at0002]/data[at0003]/items[at0151]` |

## Constraints

```sql
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

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `impairment_scale_valueset_id, impairment_scale_code, impairment_scale_system, impairment_scale, impairment_scale_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`ygtss_revised_simple_motor_tics_checklist_other_simple_m_12ffaf`](/docs/tables/ygtss_revised_simple_motor_tics_checklist_other_simple_m_12ffaf) via `ygtss_revised_id`
- [`ygtss_revised_complex_motor_tics_checklist_other_complex_9bd2b4`](/docs/tables/ygtss_revised_complex_motor_tics_checklist_other_complex_9bd2b4) via `ygtss_revised_id`
- [`ygtss_revised_simple_phonic_symptoms_checklist_other_sim_08b6d2`](/docs/tables/ygtss_revised_simple_phonic_symptoms_checklist_other_sim_08b6d2) via `ygtss_revised_id`
- [`ygtss_revised_complex_phonic_symptoms_checklist_other_co_c54c49`](/docs/tables/ygtss_revised_complex_phonic_symptoms_checklist_other_co_c54c49) via `ygtss_revised_id`
- [`ygtss_revised_score`](/docs/tables/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.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `ygtss_revised_id` | `uuid` → [`ygtss_revised`](/docs/tables/ygtss_revised) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `name` | `text` | yes | Name | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0104]/items[at0105]` |
| `description` | `text` | yes | Description | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]/items[at0104]/items[at0106]` |

#### Unique

- `ygtss_revised_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `ygtss_revised_id` | [`ygtss_revised`](/docs/tables/ygtss_revised) | cascade |

### `ygtss_revised_complex_motor_tics_checklist_other_complex_9bd2b4`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `ygtss_revised_id` | `uuid` → [`ygtss_revised`](/docs/tables/ygtss_revised) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `name` | `text` | yes | Name | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0069]/items[at0027]` |
| `description` | `text` | yes | Description | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0069]/items[at0028]` |

#### Unique

- `ygtss_revised_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `ygtss_revised_id` | [`ygtss_revised`](/docs/tables/ygtss_revised) | cascade |

### `ygtss_revised_simple_phonic_symptoms_checklist_other_sim_08b6d2`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `ygtss_revised_id` | `uuid` → [`ygtss_revised`](/docs/tables/ygtss_revised) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `name` | `text` | yes | Name | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0087]/items[at0088]` |
| `description` | `text` | yes | Description | `/data[at0001]/events[at0002]/data[at0003]/items[at0068]/items[at0087]/items[at0089]` |

#### Unique

- `ygtss_revised_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `ygtss_revised_id` | [`ygtss_revised`](/docs/tables/ygtss_revised) | cascade |

### `ygtss_revised_complex_phonic_symptoms_checklist_other_co_c54c49`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `ygtss_revised_id` | `uuid` → [`ygtss_revised`](/docs/tables/ygtss_revised) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `name` | `text` | yes | Name | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0099]/items[at0100]` |
| `description` | `text` | yes | Description | `/data[at0001]/events[at0002]/data[at0003]/items[at0067]/items[at0099]/items[at0101]` |

#### Unique

- `ygtss_revised_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `ygtss_revised_id` | [`ygtss_revised`](/docs/tables/ygtss_revised) | cascade |

### `ygtss_revised_score`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `ygtss_revised_id` | `uuid` → [`ygtss_revised`](/docs/tables/ygtss_revised) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `number`<br />`number_code`<br />`number_system`<br />`number_numeric`<br />`number_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Number | `/data[at0001]/events[at0002]/data[at0003]/items[at0107]/items[at0108]` |
| `frequency`<br />`frequency_code`<br />`frequency_system`<br />`frequency_numeric`<br />`frequency_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Frequency | `/data[at0001]/events[at0002]/data[at0003]/items[at0107]/items[at0115]` |
| `intensity`<br />`intensity_code`<br />`intensity_system`<br />`intensity_numeric`<br />`intensity_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Intensity | `/data[at0001]/events[at0002]/data[at0003]/items[at0107]/items[at0122]` |
| `complexity`<br />`complexity_code`<br />`complexity_system`<br />`complexity_numeric`<br />`complexity_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Complexity | `/data[at0001]/events[at0002]/data[at0003]/items[at0107]/items[at0129]` |
| `interference`<br />`interference_code`<br />`interference_system`<br />`interference_numeric`<br />`interference_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Interference | `/data[at0001]/events[at0002]/data[at0003]/items[at0107]/items[at0136]` |

#### Constraints

```sql
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

| Columns | Target | On delete |
|---|---|---|
| `ygtss_revised_id` | [`ygtss_revised`](/docs/tables/ygtss_revised) | cascade |
| `number_valueset_id, number_code, number_system, number, number_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `frequency_valueset_id, frequency_code, frequency_system, frequency, frequency_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `intensity_valueset_id, intensity_code, intensity_system, intensity, intensity_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `complexity_valueset_id, complexity_code, complexity_system, complexity, complexity_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `interference_valueset_id, interference_code, interference_system, interference, interference_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/complexity` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/frequency` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/impairment_scale` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/intensity` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/interference` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.ygtss_revised.v1/number` | 6 |