SoftwareItemDocument
Relation between SoftwareItem and Document entities.
erDiagram
Document ||--o{ SoftwareItemDocument : "DocumentID"
SoftwareItem ||--o{ SoftwareItemDocument : "SoftwareItemID"
Fields
| Field |
Type |
Description |
| Created |
datetime |
Date/Time this entity was created in the database |
| CreatedBy |
string |
User that created this entity |
| CustomField1 |
string |
custom field 1, not used by OctoSAM |
| CustomField2 |
string |
custom field |
| DocumentID |
numeric |
Internal ID that references the Document entity (Foreign Key) |
| ExtraData |
string |
Extra data for this relation (JSON formatted) |
| ID |
numeric |
Internal ID for the SoftwareItemDocument entity (Primary Key) |
| Res1 |
string |
Reserved for future use |
| Res2 |
string |
Reserved for future use |
| SoftwareItemID |
numeric |
Internal ID that references the SoftwareItem entity (Foreign Key) |
| SortOrder |
numeric |
Sort order for documents linked to the same software item |
References
| Column Name |
Referenced Table |
Description |
| DocumentID |
Document |
Contains documents that are attached to software items and other entities |
| SoftwareItemID |
SoftwareItem |
Software items hold customer specific information about software objects |