erx_ttl_touch

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
patient_id	BIGINT UNSIGNED	20			null

|

|

Patient record Id

| | process | enum('allergies', 'medications') | 11 | | | null |

|

|

Ensora eRx SOAP process

| | updated | DATETIME | 19 | | | null |

|

|

Date and time of last process update for patient

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc/Asc	patient_id + process

Relationships

Close relationships within degrees of separation