BinaryObjectLink Table (206)
•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
Link table, connects a BinaryObject with one or more owners
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| BinaryObjectLink_id | Primary key | PK | |
| binaryObjectId | The binary object we link to | FK BinaryObject | |
| ownerTable | The owner table | TableNumber | |
| ownerRecord | The owner record | RecordId | |
| linkComment | Link comment, optional | String(254) | ● |
| linkType | The link type | Enum BlobLinkType | |
| rank | Link rank, in case there are more of one type to one owner | UShort | |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
The link type, often synonymous with the blob type, of a BinaryObjectLink row
| LinkType | Comment |
|---|---|
| 1 | Portrait picture of a person |
| 2 | Picture bound to a project |
| 3 | Picture used for a project of type Event, in the Audience client |
| 4 | Generic thumbnail - not used? |
| 5 | Watermark image for a Status Monitor in Sales Intelligence |
| 6 | Information related to a BatchTask in NetServer |
| 7 | Image (possibly more than one, differentiated by rank) of a Product; exactly one row should have rank=1 |
| 8 | Thumbnail image for a product, only one allowed per product |
| 9 | Image (possibly more than one, differentiated by rank) of a Product image for a quote line, only one allowed per quote line |
| 10 | Thumbnail image for a quote line, only one allowed per quote line |
Indexes
| Fields | Types | Description |
|---|---|---|
| BinaryObjectLink_id | PK | Clustered, Unique |
| ownerTable, ownerRecord, linkType, rank | TableNumber, RecordId, Enum, UShort | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| BinaryObject | Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.