report_itemized

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
report_id	BIGINT	19			null

|

| | | itemized_test_id | SMALLINT | 5 | | | null |

|

| | | numerator_label | VARCHAR | 25 | | | '' |

|

|

Only used in special cases

| | pass | BOOLEAN | 3 | | | 0 |

|

|

0 is fail, 1 is pass, 2 is excluded

| | pid | BIGINT | 19 | | | null |

|

| | | rule_id | VARCHAR | 31 | √ | | NULL |

|

|

fk to clinical_rules.rule_id

| | item_details | TEXT | 65535 | √ | | NULL |

|

|

JSON with specific sub item results for a clinical rule

|

Indexes

Constraint Name	Type	Sort	Column(s)
report_id	Performance	Asc/Asc/Asc/Asc	report_id + itemized_test_id + numerator_label + pass

Relationships

Close relationships within degrees of separation