collector

Table info.

Title Collector
Description Collector

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectorID 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
IsPrimary bit(1) Is primary isPrimary
OrderNumber int(11) Order number The position in the list of collectors
Remarks text Comments The collecting number of a collector who is not the primary collector, or an indication that there is uncertainty about who the collector is
DivisionID int(11) MUL
AgentID int(11) MUL
CollectingEventID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
Text1 text Text1 text1
Text2 text Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2

Indexes

Name Fields Unique Nullable
AgentID AgentID, CollectingEventID
COLTRDivIDX DivisionID
FK7043CC8D384B3622 AgentID
FK7043CC8D5327F942 ModifiedByAgentID
FK7043CC8D7699B003 CreatedByAgentID
FK7043CC8D97C961D8 DivisionID
FK7043CC8DB237E2BC CollectingEventID
PRIMARY CollectorID

Many-to-one relationships

Name Field Related table Related field
FK7043CC8D384B3622 AgentID agent AgentID
FK7043CC8D5327F942 ModifiedByAgentID agent AgentID
FK7043CC8D7699B003 CreatedByAgentID agent AgentID
FK7043CC8D97C961D8 DivisionID division UserGroupScopeId
FK7043CC8DB237E2BC CollectingEventID collectingevent CollectingEventID