Database – System Notes Entity (system_note_entity)
Holds system generated note information.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the system note. | ||
entity_type | char(50) | The entity type that the system note is about. There is an entity type for each entity inside LoanPro (e.g. loan, customers, document, autopay, etc.) | E.G. Entity.Loan, Entity.Customer, Entity.Document, Entity.Autopay | |
entity_id | int(11) | The ID of the entity the system note is about. | ||
reference_type | char(50) | This is similar to the entity type, but gives more information when two entities are involved in an action. The reference type usually refers to a child entity. For example, if a document is added to a loan, the entity_type would be Entity.Loan and the reference_type would be Entity.Document. | E.G. Entity.Document, Entity.PaymentAccount | |
reference_id | int(11) | This is the ID of the referenced entity. For example, if the system note references a document being added to a loan, the reference_id is the document ID, while the entity_id is the loan ID. | ||
operation_type | enum | operation type |
| |
operation_sub_type | char(100) | operation sub type | systemNote.operationSubtype.* | |
create_user | int(11) | ID of the user that created the entity | ||
create_user_name | varchar(255) | creating user name | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
remote_addr | char(20) | IP address of the client machine | ||
note_title | varchar(255) | note title | ||
note_data | text | note data | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |