audit_details

Columns

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

|

| | | table_name | VARCHAR | 100 | | | null |

|

|

openemr table name

| | field_name | VARCHAR | 100 | | | null |

|

|

openemr table’s field name

| | field_value | LONGTEXT | 2147483647 | √ | | NULL |

|

|

openemr table field value

| | audit_master_id | BIGINT | 19 | | | null |

|

|

Id of the audit_master table

| | entry_identification | VARCHAR | 255 | | | '1' |

|

|

Used when multiple entry occurs from the same table.1 means no multiple entry

|

Indexes

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

Relationships

Close relationships within degrees of separation