notification_log

Columns

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

|

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

|

| | | pc_eid | INT UNSIGNED | 10 | √ | | NULL |

|

| | | sms_gateway_type | VARCHAR | 50 | | | null |

|

| | | smsgateway_info | VARCHAR | 255 | | | null |

|

| | | message | TEXT | 65535 | √ | | NULL |

|

| | | email_sender | VARCHAR | 255 | | | null |

|

| | | email_subject | VARCHAR | 255 | | | null |

|

| | | type | enum('SMS', 'Email') | 5 | | | null |

|

| | | patient_info | TEXT | 65535 | √ | | NULL |

|

| | | pc_eventDate | DATE | 10 | | | null |

|

| | | pc_endDate | DATE | 10 | | | null |

|

| | | pc_startTime | TIME | 10 | | | null |

|

| | | pc_endTime | TIME | 10 | | | null |

|

| | | dSentDateTime | DATETIME | 19 | | | null |

|

| |

Indexes

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

Relationships

Close relationships within degrees of separation