loanagent

Table info.

Title Loan Agent
Description Loan Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
LoanAgentID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
Remarks text Remarks Remarks about the loan agent
Role varchar(50) MUL Role LoanAgentRole
  • Student
  • Researcher
  • Supervisor
  • Other
 The role of the loan agent
DisciplineID int(11) MUL
AgentID int(11) MUL
LoanID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK63FA1415384B3622 AgentID
FK63FA14154CE675DE DisciplineID
FK63FA14155327F942 ModifiedByAgentID
FK63FA14157699B003 CreatedByAgentID
FK63FA1415A16D4F1E LoanID
LoanAgDspMemIDX DisciplineID
PRIMARY LoanAgentID
Role Role, LoanID, AgentID

Many-to-one relationships

Name Field Related table Related field
FK63FA1415384B3622 AgentID agent AgentID
FK63FA14154CE675DE DisciplineID discipline UserGroupScopeId
FK63FA14155327F942 ModifiedByAgentID agent AgentID
FK63FA14157699B003 CreatedByAgentID agent AgentID
FK63FA1415A16D4F1E LoanID loan LoanID