bvc

A checklist which assists in the prediction of imminent violent behaviour.

A checklist which assists in the prediction of imminent violent behaviour.

Purpose. To record the results for each component parameter and their total sum for the BVC score.

Source

Columns

Constraints

check ((confused_code is null and confused_system is null and confused_numeric is null and confused is null) or (confused_valueset_id is not null and confused_code is not null and confused_system is not null and confused_numeric is not null and confused is not null))
check ((irritable_code is null and irritable_system is null and irritable_numeric is null and irritable is null) or (irritable_valueset_id is not null and irritable_code is not null and irritable_system is not null and irritable_numeric is not null and irritable is not null))
check ((boisterous_code is null and boisterous_system is null and boisterous_numeric is null and boisterous is null) or (boisterous_valueset_id is not null and boisterous_code is not null and boisterous_system is not null and boisterous_numeric is not null and boisterous is not null))
check ((physical_threats_code is null and physical_threats_system is null and physical_threats_numeric is null and physical_threats is null) or (physical_threats_valueset_id is not null and physical_threats_code is not null and physical_threats_system is not null and physical_threats_numeric is not null and physical_threats is not null))
check ((verbal_threats_code is null and verbal_threats_system is null and verbal_threats_numeric is null and verbal_threats is null) or (verbal_threats_valueset_id is not null and verbal_threats_code is not null and verbal_threats_system is not null and verbal_threats_numeric is not null and verbal_threats is not null))
check ((attacking_objects_code is null and attacking_objects_system is null and attacking_objects_numeric is null and attacking_objects is null) or (attacking_objects_valueset_id is not null and attacking_objects_code is not null and attacking_objects_system is not null and attacking_objects_numeric is not null and attacking_objects is not null))
check (total_score is null or total_score between 0 and 6)
check ((interpretation_code is null and interpretation_system is null and interpretation_valueset_id is null and interpretation is null) or (interpretation is not null and interpretation_code is not null and interpretation_system is not null and interpretation_valueset_id is not null))

Unique

• form_block_id

References

Indexes

• bvc_form_id_idx on form_id

Value sets