Database - Action & Result Note (action_result_note_entity)
Description
This is the note of the action/result. For more information regarding actions and results see this article: Actions & Results.
Common Uses
Table Fields
Column | Data Type | Column Info | Value Notes |
id | INT (11) | This is the id or the identifier of the action & result note. | |
loan_id | INT(11) | This is the id of the loan that the action & result note is tied to. | |
note | TEXT | The body of the note. | |
create_user | INT(11) | This is the id of the user that created the action & result note. | |
create_user_name | VARCHAR(225) | This is the name of the user that created the action & result note. | |
remote_addr | CHAR(20) | This is the ip address from where the note was created. | |
created | TIMESTAMP | This is the date that the action & result note was created. | |
last_updated | TIMESTAMP | This is the date that the action & result note was last updated. | |
deleted | TINYINT(1) | This determines whether the action & result note is deleted. | 1 - yes, 0 - no |
logged_date | TIMESTAMP | This is the date that the action & result note was logged. |