collectionreltype

Table info.

Title Collection Relationship Type
Description Collection Relationship Type

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionRelTypeID 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
Name varchar(32) Name The name of the Collection Relationship.
Remarks text Remarks Additional comments.
RightSideCollectionID int(11) MUL
ModifiedByAgentID int(11) MUL
LeftSideCollectionID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK1CAC96F55327F942 ModifiedByAgentID
FK1CAC96F57699B003 CreatedByAgentID
FK1CAC96F5CB93CD98 LeftSideCollectionID
FK1CAC96F5D54425AD RightSideCollectionID
PRIMARY CollectionRelTypeID

One-to-many relationships

Name Field Related table Related field
FK246327D6637B3A82 CollectionRelTypeID collectionrelationship CollectionRelTypeID

Many-to-one relationships

Name Field Related table Related field
FK1CAC96F55327F942 ModifiedByAgentID agent AgentID
FK1CAC96F57699B003 CreatedByAgentID agent AgentID
FK1CAC96F5CB93CD98 LeftSideCollectionID collection UserGroupScopeId
FK1CAC96F5D54425AD RightSideCollectionID collection UserGroupScopeId