ObjectDocument
Relation between OctoSAM objects and assigned documents.
erDiagram
Document ||--o{ ObjectDocument : "DocumentID"
OctopusObjectType ||--o{ ObjectDocument : "OctopusObjectTypeId"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this relation was created |
| CreatedBy |
string |
User that created this relation |
| CustomField1 |
string |
Custom field 1, not used by OctoSAM |
| CustomField2 |
string |
Custom field 2, not used by OctoSAM |
| DocumentID |
numeric |
Internal ID that references the Document entity (Foreign Key) |
| ExtraData |
string |
Additional data related to the object document in JSON format |
| ID |
numeric |
Internal ID for the ObjectDocument entity (Primary Key) |
| Notes |
string |
Additional notes related to the object document |
| ObjectDisplayName |
string |
Display name of the object |
| ObjectGuid |
guid |
GUID of the OctoSAM object |
| OctopusObjectTypeId |
numeric |
Internal ID that references the OctopusObjectType entity (Foreign Key) |
| Res1 |
string |
Reserved for future use |
| Res2 |
string |
Reserved for future use |
| SortOrder |
numeric |
Indicates sort order of documents when they are displayed in context of the object |
References
| Column Name |
Referenced Table |
Description |
| DocumentID |
Document |
Contains documents that are attached to software items and other entities |
| OctopusObjectTypeId |
OctopusObjectType |
Object types defined in OctoSAM Inventory |