collectingeventattr

Table info.

Title Collecting Event Attribute
Description Collecting Event Attribute

Fields

Name Type Required Index Hidden On form Title Pick list Description
AttrID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
DoubleValue double
StrValue varchar(255) String Value strValue
ModifiedByAgentID int(11) MUL
CollectingEventID int(11) MUL
AttributeDefID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
COLEVATColMemIDX CollectionMemberID
FK42A088135327F942 ModifiedByAgentID
FK42A088137699B003 CreatedByAgentID
FK42A08813B237E2BC CollectingEventID
FK42A08813E84BA7B0 AttributeDefID
PRIMARY AttrID

Many-to-one relationships

Name Field Related table Related field
FK42A088135327F942 ModifiedByAgentID agent AgentID
FK42A088137699B003 CreatedByAgentID agent AgentID
FK42A08813B237E2BC CollectingEventID collectingevent CollectingEventID
FK42A08813E84BA7B0 AttributeDefID attributedef AttributeDefID