preparationattr

Table info.

Title Preparation Attribute
Description Preparation 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
AttributeDefID int(11) MUL
CreatedByAgentID int(11) MUL
PreparationId int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK4592DD0818627F06 PreparationId
FK4592DD085327F942 ModifiedByAgentID
FK4592DD087699B003 CreatedByAgentID
FK4592DD08E84BA7B0 AttributeDefID
PrepAttrColMemIDX CollectionMemberID
PRIMARY AttrID

Many-to-one relationships

Name Field Related table Related field
FK4592DD0818627F06 PreparationId preparation PreparationID
FK4592DD085327F942 ModifiedByAgentID agent AgentID
FK4592DD087699B003 CreatedByAgentID agent AgentID
FK4592DD08E84BA7B0 AttributeDefID attributedef AttributeDefID