storagetreedef

Table info.

Title Storage Tree Definition
Description Storage Tree Definition

Fields

Name Type Required Index Hidden On form Title Pick list Description
StorageTreeDefID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
FullNameDirection int(11) Full Name Direction fullNameDirection
Name varchar(64) Name name
Remarks text Remarks Additional Comments
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK21AC10CC5327F942 ModifiedByAgentID
FK21AC10CC7699B003 CreatedByAgentID
PRIMARY StorageTreeDefID

One-to-many relationships

Name Field Related table Related field
FK3529A5B853C7EFD6 StorageTreeDefID institution StorageTreeDefID
FK8FB0427B53C7EFD6 StorageTreeDefID storage StorageTreeDefID
FK589045DF53C7EFD6 StorageTreeDefID storagetreedefitem StorageTreeDefID

Many-to-one relationships

Name Field Related table Related field
FK21AC10CC5327F942 ModifiedByAgentID agent AgentID
FK21AC10CC7699B003 CreatedByAgentID agent AgentID