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.


How did we do?


Powered by HelpDocs (opens in a new tab)