collectionobjectattr

Table info.

Title Collection Object Attribute
Description Collection Object 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
CreatedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
AttributeDefID int(11) MUL

Indexes

Name Fields Unique Nullable
COLOBJATRSColMemIDX CollectionMemberID
FK303746CE5327F942 ModifiedByAgentID
FK303746CE75E37458 CollectionObjectID
FK303746CE7699B003 CreatedByAgentID
FK303746CEE84BA7B0 AttributeDefID
PRIMARY AttrID

Many-to-one relationships

Name Field Related table Related field
FK303746CE5327F942 ModifiedByAgentID agent AgentID
FK303746CE75E37458 CollectionObjectID collectionobject CollectionObjectID
FK303746CE7699B003 CreatedByAgentID agent AgentID
FK303746CEE84BA7B0 AttributeDefID attributedef AttributeDefID