I was pleasantly surprised to see some fields in some MySQL tables annotated. However, there are some that baffle me, as they point to something that appears not to exist - any help on this would be greatly appreciated!
Table rule_filter
Field method - ‘Maps to list_options list rule_filters’,
Field method_detail ‘Maps to list_options lists rule__intervals’,
So… I look at the table list_options and no such fields exist there.
The references may be to Clinical Rule Filter Methods & Clinical Rules Reminder Intervals in Administration/Lists, rather than to tables or columns in the database.
As Stephen said, “method” field’s list maps to the list_options table (By list_id=‘rule_filters’). And the corresponding option_id value (in list_options) will be stored as a reference in the rule_filter table’s “method” field.
And similarly some of the options in “method_detail” field maps to the list_options table (By list_id =‘rule_age_intervals’).