Back to Openemr

amc_misc_data

Documentation/EHI_Export/docs/tables/amc_misc_data.html

latest934 B
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
amc_idVARCHAR31''

|

|

Unique and maps to list_options list clinical_rules

| | pid | BIGINT | 19 | √ | | NULL |

|

| | | map_category | VARCHAR | 255 | | | '' |

|

|

Maps to an object category (such as prescriptions etc.)

| | map_id | BIGINT | 19 | | | 0 |

|

|

Maps to an object id (such as prescription id etc.)

| | date_created | DATETIME | 19 | √ | | NULL |

|

| | | date_completed | DATETIME | 19 | √ | | NULL |

|

| | | soc_provided | DATETIME | 19 | √ | | NULL |

|

| |

Indexes

Constraint NameTypeSortColumn(s)
amc_idPerformanceAsc/Asc/Ascamc_id + pid + map_id

Relationships

Close relationships within degrees of separation