loanattachment

Table info.

Title Loan Attachment
Description Loan Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
LoanAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal ordinal
Remarks text Remarks Additional comments.
AttachmentID int(11) MUL
LoanID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK23ECB2135327F942 ModifiedByAgentID
FK23ECB2137699B003 CreatedByAgentID
FK23ECB213A16D4F1E LoanID
FK23ECB213C7E55084 AttachmentID
PRIMARY LoanAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK23ECB2135327F942 ModifiedByAgentID agent AgentID
FK23ECB2137699B003 CreatedByAgentID agent AgentID
FK23ECB213A16D4F1E LoanID loan LoanID
FK23ECB213C7E55084 AttachmentID attachment AttachmentID