Table: Loan Customer Link Info

Table: Loan Customer Link Info

Provides a many-to-many relationship between customers and loans.

Column Data Type Column Info Value Notes Other
loan_idint(11)The id of the associated loan account
customer_idint(11)ID for the customer
customer_rolechar(100)Customer roleloan.customerRole.*
customer_email_enrollment_accesstinyint(4)Whether or not the customer has email enrollment1 - yes, 0 - no
customer_web_accesstinyint(4)Whether or not the customer has web access1 - yes, 0 - no
customer_sms_accesstinyint(4)Whether or not the customer has sms access1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List