Database - Action and Results Mapping Table (action__result)

Description

This table maps the relationship between actions and results for those actions.

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.


How did we do?


Powered by HelpDocs (opens in a new tab)