Database – Action and Results Mapping Table (action__result)
Description
This table maps the relationship between actions and results for those actions. For more information on how to use actions and results in the API, see API - Actions & Results.
Table Fields
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The ID for the relationship between the action and result. | ||
action_id | int(11) | The ID of the action. Actions can be found in the action_entity table. | ||
result_id | int(11) | The ID of the result. Results can be found in the result_entity table. | ||
deleted | int(1) | Whether this record has been marked as deleted. | 1 - yes, 0 - no | |
adjust_base | int(11) | The ID of the date to use as the starting point for an adjustment to the follow-up date. Base date options can be found in the base_variable_entity table. | ||
adjust_number | int(11) | The number of days from the base date that the follow-up date should be set to on a loan, when this action and result are logged. Negative numbers represent days prior to the base date, while positive number represent days after. |