| Title | Field Notebook Page Set Attachment |
|---|---|
| Description | Field Notebook Page Set Attachment |
| Name | Type | Required | Index | Hidden | On form | Title | Pick list | Description |
|---|---|---|---|---|---|---|---|---|
| FieldNotebookPageSetAttachmentId | 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 | |||||
| FieldNotebookPageSetID | int(11) | MUL | ||||||
| AttachmentID | int(11) | MUL | ||||||
| CreatedByAgentID | int(11) | MUL | ||||||
| ModifiedByAgentID | int(11) | MUL |
| Name | Fields | Unique | Nullable |
|---|---|---|---|
| FKB1477CA15327F942 | ModifiedByAgentID | ||
| FKB1477CA17699B003 | CreatedByAgentID | ||
| FKB1477CA19B34BD5A | FieldNotebookPageSetID | ||
| FKB1477CA1C7E55084 | AttachmentID | ||
| PRIMARY | FieldNotebookPageSetAttachmentId |
| Name | Field | Related table | Related field |
|---|---|---|---|
| FKB1477CA15327F942 | ModifiedByAgentID | agent | AgentID |
| FKB1477CA17699B003 | CreatedByAgentID | agent | AgentID |
| FKB1477CA19B34BD5A | FieldNotebookPageSetID | fieldnotebookpageset | FieldNotebookPageSetID |
| FKB1477CA1C7E55084 | AttachmentID | attachment | AttachmentID |