collectionrelationship

Table info.

Title Collection Relationship
Description Collection Relationship

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionRelationshipID 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
Text1 varchar(32) Text1 User definable.
Text2 varchar(32) Text2 User definable.
ModifiedByAgentID int(11) MUL
CollectionRelTypeID int(11) MUL
LeftSideCollectionID int(11) MUL
RightSideCollectionID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK246327D65327F942 ModifiedByAgentID
FK246327D6637B3A82 CollectionRelTypeID
FK246327D67699B003 CreatedByAgentID
FK246327D678903837 LeftSideCollectionID
FK246327D68240904C RightSideCollectionID
PRIMARY CollectionRelationshipID

Many-to-one relationships

Name Field Related table Related field
FK246327D65327F942 ModifiedByAgentID agent AgentID
FK246327D6637B3A82 CollectionRelTypeID collectionreltype CollectionRelTypeID
FK246327D67699B003 CreatedByAgentID agent AgentID
FK246327D678903837 LeftSideCollectionID collectionobject CollectionObjectID
FK246327D68240904C RightSideCollectionID collectionobject CollectionObjectID