amc_misc_data

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
amc_id	VARCHAR	31			''

|

|

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 Name	Type	Sort	Column(s)
amc_id	Performance	Asc/Asc/Asc	amc_id + pid + map_id

Relationships

Close relationships within degrees of separation