clinical_rules_log

Columns

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

|

| | | date | DATETIME | 19 | √ | | NULL |

|

| | | pid | BIGINT | 19 | | | 0 |

|

| | | uid | BIGINT | 19 | | | 0 |

|

| | | category | VARCHAR | 255 | | | '' |

|

|

An example category is clinical_reminder_widget

| | value | TEXT | 65535 | √ | | NULL |

|

| | | new_value | TEXT | 65535 | √ | | NULL |

|

| | | facility_id | INT | 10 | √ | | 0 |

|

|

facility where the rule was executed, 0 if unknown

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
category	Performance	Asc	category
pid	Performance	Asc	pid
uid	Performance	Asc	uid

Relationships

Close relationships within degrees of separation