borrowagent

Table info.

Title Borrow Agent
Description Borrow Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
BorrowAgentID 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
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Remarks text Remarks Remarks about the borrowing agent
Role varchar(32) MUL Role BorrowRole
  • Student
  • Botanist
  • Supervisor
 The role of the borrowing agent
CreatedByAgentID int(11) MUL
BorrowID int(11) MUL
ModifiedByAgentID int(11) MUL
AgentID int(11) MUL

Indexes

Name Fields Unique Nullable
BorColMemIDX2 CollectionMemberID
FKF48F8A30384B3622 AgentID
FKF48F8A305327F942 ModifiedByAgentID
FKF48F8A307699B003 CreatedByAgentID
FKF48F8A30F8BF6F28 BorrowID
PRIMARY BorrowAgentID
Role Role, AgentID, BorrowID

Many-to-one relationships

Name Field Related table Related field
FKF48F8A30384B3622 AgentID agent AgentID
FKF48F8A305327F942 ModifiedByAgentID agent AgentID
FKF48F8A307699B003 CreatedByAgentID agent AgentID
FKF48F8A30F8BF6F28 BorrowID borrow BorrowID