collectingtripattachment

Table info.

Title Collecting Trip Attachment
Description Collecting Trip Attachment

Fields

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

Indexes

Name Fields Unique Nullable
FK3E419F805327F942 ModifiedByAgentID
FK3E419F80697B3F98 CollectingTripID
FK3E419F807699B003 CreatedByAgentID
FK3E419F80C7E55084 AttachmentID
PRIMARY CollectingTripAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK3E419F805327F942 ModifiedByAgentID agent AgentID
FK3E419F80697B3F98 CollectingTripID collectingtrip CollectingTripID
FK3E419F807699B003 CreatedByAgentID agent AgentID
FK3E419F80C7E55084 AttachmentID attachment AttachmentID