Back to Openemr

form_soap

Documentation/EHI_Export/docs/tables/form_soap.html

latest1.0 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
idBIGINT19null

|

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

|

| | | pid | BIGINT | 19 | √ | | 0 |

|

| patient_data.pid | Defined in XML | R |

|

The internal patient identifier

| | user | VARCHAR | 255 | √ | | NULL |

|

| | | groupname | VARCHAR | 255 | √ | | NULL |

|

| | | authorized | TINYINT | 3 | √ | | 0 |

|

| | | activity | TINYINT | 3 | √ | | 0 |

|

| | | subjective | TEXT | 65535 | √ | | NULL |

|

| | | objective | TEXT | 65535 | √ | | NULL |

|

| | | assessment | TEXT | 65535 | √ | | NULL |

|

| | | plan | TEXT | 65535 | √ | | NULL |

|

| |

Indexes

Constraint NameTypeSortColumn(s)
PRIMARYPrimary keyAscid

Relationships

Close relationships within degrees of separation