s_picture_entry table - SuperOffice

s_picture_entry Table (340)

This table describes each picture in the database

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
attachment_id	The id of the attachment in the attachment table	FK attachment	Yes
description	A description of the picture	String(255)	Yes
folder_id	The folder which this picture belongs to. -1 indicates that the picture is on the root	Int	No
flags	Various flags for this picture	UInt	Yes
status	Indicates the status of the picture. 0 = ok, 1 = deleted	Short	No
hits	Number of hits on this image	Int	Yes
registered	Registered when	UtcDateTime	Yes
registered_associate_id	Registered by whom	FK associate	Yes
updated	Last updated when	UtcDateTime	Yes
updated_associate_id	Last updated by whom	FK associate	Yes
updatedCount	Number of updates made to this record	UShort	Yes

Indexes

Fields	Types	Description
attachment_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
attachment	This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

attachment table s_picture_folder table Put Picture Folder Entity Post Picture Folder Entity Get Picture Folder Entity Default Picture Folder Entity

⌘I