conservdescriptionattachment

Table info.

Title Conservator Description Attachment
Description Conservator Description Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
ConservDescriptionAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal The order or position
Remarks text Remarks remarks
ModifiedByAgentID int(11) MUL
ConservDescriptionID int(11) MUL
CreatedByAgentID int(11) MUL
AttachmentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK1EED20875327F942 ModifiedByAgentID
FK1EED20877699B003 CreatedByAgentID
FK1EED20878FF9CFA6 ConservDescriptionID
FK1EED2087C7E55084 AttachmentID
PRIMARY ConservDescriptionAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK1EED20875327F942 ModifiedByAgentID agent AgentID
FK1EED20877699B003 CreatedByAgentID agent AgentID
FK1EED20878FF9CFA6 ConservDescriptionID conservdescription ConservDescriptionID
FK1EED2087C7E55084 AttachmentID attachment AttachmentID