mayo_score

An assessment score used to estimate the severity of ulcerative colitis.

An assessment score used to estimate the severity of ulcerative colitis.

Purpose. To record an assessment of the severity of ulcerative colitis.

Source

Columns

Constraints

check ((stool_frequency_code is null and stool_frequency_system is null and stool_frequency_numeric is null and stool_frequency is null) or (stool_frequency_valueset_id is not null and stool_frequency_code is not null and stool_frequency_system is not null and stool_frequency_numeric is not null and stool_frequency is not null))
check ((rectal_bleeding_code is null and rectal_bleeding_system is null and rectal_bleeding_numeric is null and rectal_bleeding is null) or (rectal_bleeding_valueset_id is not null and rectal_bleeding_code is not null and rectal_bleeding_system is not null and rectal_bleeding_numeric is not null and rectal_bleeding is not null))
check ((endoscopy_findings_code is null and endoscopy_findings_system is null and endoscopy_findings_numeric is null and endoscopy_findings is null) or (endoscopy_findings_valueset_id is not null and endoscopy_findings_code is not null and endoscopy_findings_system is not null and endoscopy_findings_numeric is not null and endoscopy_findings is not null))
check ((global_assessment_code is null and global_assessment_system is null and global_assessment_numeric is null and global_assessment is null) or (global_assessment_valueset_id is not null and global_assessment_code is not null and global_assessment_system is not null and global_assessment_numeric is not null and global_assessment is not null))
check (total_mayo_score is null or total_mayo_score between 0 and 12)
check (partial_mayo_score is null or partial_mayo_score between 0 and 9)
check (simplified_mayo_score is null or simplified_mayo_score between 0 and 6)

Unique

• form_block_id

References

Indexes

• mayo_score_form_id_idx on form_id

Value sets