giftagent

Table info.

Title Gift Agent
Description Gift Agent

Fields

Name Type Required Index Hidden On form Title Pick list Description
GiftAgentID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
Remarks text Remarks Remarks about the donation agent
Role varchar(50) MUL Role GiftAgentRole
  • Recipient of exchange file
  • Botanist
  • Supervisor
  • Student
  • Other
 The role the agent plays in the gift
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
GiftID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK221917D5384B3622 AgentID
FK221917D54CE675DE DisciplineID
FK221917D55327F942 ModifiedByAgentID
FK221917D57699B003 CreatedByAgentID
FK221917D59890879E GiftID
GiftAgDspMemIDX DisciplineID
PRIMARY GiftAgentID
Role Role, GiftID, AgentID

Many-to-one relationships

Name Field Related table Related field
FK221917D5384B3622 AgentID agent AgentID
FK221917D54CE675DE DisciplineID discipline UserGroupScopeId
FK221917D55327F942 ModifiedByAgentID agent AgentID
FK221917D57699B003 CreatedByAgentID agent AgentID
FK221917D59890879E GiftID gift GiftID