erx_rx_log

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	INT	10		√	null

|

| | | prescription_id | INT | 10 | | | null |

|

| | | date | VARCHAR | 25 | | | null |

|

| | | time | VARCHAR | 15 | | | null |

|

| | | code | INT | 10 | | | null |

|

| | | status | TEXT | 65535 | √ | | NULL |

|

| | | message_id | VARCHAR | 100 | √ | | NULL |

|

| | | read | INT | 10 | √ | | NULL |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id

Relationships

Close relationships within degrees of separation