Database – Action & Result Selection (action_result_selection_entity)
Description
This allows for the linking of an action to a result and a note.
Common Uses
Table Fields
Column | Data Type | Column Info | Value Notes |
id | INT(11) | The ID of the action & result selection entity | |
note_id | INT(11) | The ID of the associated note. | |
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. | |
action_text | VARCHAR(255) | The description of the action for an action & result. | |
result_text | VARCHAR(255) | The description of the result for an action & result. | |
created | DATETIME | This is the date that the action & result note was created. | |
lastUpdated | TIMESTAMP | This is the date that the action & result note was last updated. | |
deleted | TINYINT(1) | Whether this record has been marked as deleted. | 1 - yes, 0 - no |