preparationattachment

Table info.

Title Preparation Attachment
Description Preparation Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
PreparationAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Ordinal int(11) Ordinal ordinal
Remarks text Remarks remarks
PreparationID int(11) MUL
CreatedByAgentID int(11) MUL
AttachmentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKE3FD6EFA18627F06 PreparationID
FKE3FD6EFA5327F942 ModifiedByAgentID
FKE3FD6EFA7699B003 CreatedByAgentID
FKE3FD6EFAC7E55084 AttachmentID
PrepAttColMemIDX CollectionMemberID
PRIMARY PreparationAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKE3FD6EFA18627F06 PreparationID preparation PreparationID
FKE3FD6EFA5327F942 ModifiedByAgentID agent AgentID
FKE3FD6EFA7699B003 CreatedByAgentID agent AgentID
FKE3FD6EFAC7E55084 AttachmentID attachment AttachmentID