BinaryObject table - SuperOffice

BinaryObject Table (205)

Binary objects, i.e., blobs. Used for images, documents, SuperOffice inbox mail and other large binary items

Fields

Name	Description	Type	Nullable
BinaryObject_id	Primary key	PK	No
conceptualType	The type, for instance PHOTO, PERSONPHOTO, or whatever, that is descriptive of what kind of image or data this is	String(254)	No
mimeType	Mime type, describing the technical type (image/jpeg) of the data	String(254)	Yes
description	A description that is entered by the user, and visible to the user	String(254)	Yes
originalSize	Original size of the binary data, before encryption and/or zipping. This is what the ultimate client will get	UInt	No
blobSize	The length, in bytes, of the binary data AS STORED after any encryption and/or zipping. Important to get right, since some databases will not tell us just based on the blob itself!	UInt	No
isZipped	Has the data been zipped (support for this will come in HDB)	Bool	No
isEncrypted	Has the data been encrypted (support for this will come in HDB)	Bool	No
extraInfo	Extra information, spare field, can be used for anything that makes sense. Should not refer to any particular context, that is something for the BinaryObjectLInk	String(254)	Yes
binaryData	The binary data itself. Length is limited by the database, generally 1GB seems to be reliably available. Beyond that is database dependent.	Blob	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
conceptualType	String(254)	Index
mimeType	String(254)	Index
extraInfo	String(254)	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
BinaryObjectLink	Link table, connects a BinaryObject with one or more owners
extra_tables	This table contains entries for the extra tables in the system.

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

Sentry controls access to items in this table using user’s Role and data rights matrix.

Related topics

SuperOffice.WebApi.Data.BatchTaskInfo NSBatchTaskInfo Contact (person)How to display an image from the Blob table (services)Update Batch Task Start Batch Job