rule_patient_data

Columns

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

|

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

|

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

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier

| | category | VARCHAR | 31 | | | '' |

|

| rule_action_item.category | Defined in XML | R |

|

Maps to the category item in the rule_action_item table

| | item | VARCHAR | 31 | | | '' |

|

| rule_action_item.item | Defined in XML | R |

|

Maps to the item column in the rule_action_item table

| | complete | VARCHAR | 31 | | | '' |

|

|

Maps to list_options list yesno

| | result | VARCHAR | 255 | | | '' |

|

| |

Indexes

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

Relationships

Close relationships within degrees of separation