storageattachment

Table info.

Title Storage Attachment
Description Storage Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
StorageAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal ordinal
Remarks text Remarks remarks
StorageID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AttachmentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKBE9EFDDE5327F942 ModifiedByAgentID
FKBE9EFDDE7699B003 CreatedByAgentID
FKBE9EFDDEC7E55084 AttachmentID
FKBE9EFDDEEB48144E StorageID
PRIMARY StorageAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKBE9EFDDE5327F942 ModifiedByAgentID agent AgentID
FKBE9EFDDE7699B003 CreatedByAgentID agent AgentID
FKBE9EFDDEC7E55084 AttachmentID attachment AttachmentID
FKBE9EFDDEEB48144E StorageID storage StorageID