fieldnotebookattachment

Table info.

Title Field Notebook Attachment
Description Field Notebook Attachment

Fields

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

Indexes

Name Fields Unique Nullable
FKDC15BBB85327F942 ModifiedByAgentID
FKDC15BBB87699B003 CreatedByAgentID
FKDC15BBB8B522A4E2 FieldNotebookID
FKDC15BBB8C7E55084 AttachmentID
PRIMARY FieldNotebookAttachmentId

Many-to-one relationships

Name Field Related table Related field
FKDC15BBB85327F942 ModifiedByAgentID agent AgentID
FKDC15BBB87699B003 CreatedByAgentID agent AgentID
FKDC15BBB8B522A4E2 FieldNotebookID fieldnotebook FieldNotebookID
FKDC15BBB8C7E55084 AttachmentID attachment AttachmentID