storagetreedefitem

Table info.

Title Storage Tree Definition Item
Description Storage Tree Definition Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
StorageTreeDefItemID 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
FullNameSeparator varchar(32) Full Name Separator fullNameSeparator
IsEnforced bit(1) Is Enforced isEnforced
IsInFullName bit(1) Is In Full Name isInFullName
Name varchar(64) Name name
RankID int(11) Rank Id rankId
Remarks text Remarks Additional Comments
TextAfter varchar(64) Text After User definable
TextBefore varchar(64) Text Before User definable
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
ParentItemID int(11) MUL
StorageTreeDefID int(11) MUL
Title varchar(64) Title title

Indexes

Name Fields Unique Nullable
FK589045DF3C85253A ParentItemID
FK589045DF5327F942 ModifiedByAgentID
FK589045DF53C7EFD6 StorageTreeDefID
FK589045DF7699B003 CreatedByAgentID
PRIMARY StorageTreeDefItemID

One-to-many relationships

Name Field Related table Related field
FK8FB0427B4D340BDC StorageTreeDefItemID storage StorageTreeDefItemID
FK589045DF3C85253A StorageTreeDefItemID storagetreedefitem ParentItemID

Many-to-one relationships

Name Field Related table Related field
FK589045DF3C85253A ParentItemID storagetreedefitem StorageTreeDefItemID
FK589045DF5327F942 ModifiedByAgentID agent AgentID
FK589045DF53C7EFD6 StorageTreeDefID storagetreedef StorageTreeDefID
FK589045DF7699B003 CreatedByAgentID agent AgentID