Database – Loan Customer Link Info (loan__customer)
Description
Provides a many-to-many relationship between customers and loans.
Column | Data Type | Column Info | Value Notes | Other |
id | int(10) | |||
loan_id | int(11) | The id of the associated loan account | ||
customer_id | int(11) | ID for the customer | ||
customer_role | char(100) | Customer role | loan.customerRole.* | |
customer_email_enrollment_access | tinyint(4) | Whether or not the customer has email enrollment | 1 - yes, 0 - no | |
customer_web_access | tinyint(4) | Whether or not the customer has web access | 1 - yes, 0 - no | |
customer_sms_access | tinyint(4) | Whether or not the customer has sms access | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |