treatmenteventattachment

Table info.

Title Treatment Event Attachment
Description Treatment Event Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
TreatmentEventAttachmentID 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
ModifiedByAgentID int(11) MUL
AttachmentID int(11) MUL
CreatedByAgentID int(11) MUL
TreatmentEventID int(11) MUL

Indexes

Name Fields Unique Nullable
FK1725BC52BE40B22 TreatmentEventID
FK1725BC55327F942 ModifiedByAgentID
FK1725BC57699B003 CreatedByAgentID
FK1725BC5C7E55084 AttachmentID
PRIMARY TreatmentEventAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK1725BC52BE40B22 TreatmentEventID treatmentevent TreatmentEventID
FK1725BC55327F942 ModifiedByAgentID agent AgentID
FK1725BC57699B003 CreatedByAgentID agent AgentID
FK1725BC5C7E55084 AttachmentID attachment AttachmentID