uid	title	description	so.generated	keywords	so.topic	so.envir
table-s_picture_entry	s_picture_entry table	This table describes each picture in the database	true	database table s_picture_entry	reference	onsite, online

s_picture_entry Table (340)

This table describes each picture in the database

Fields

Name	Description	Type	Null
id	Primary key	PK
attachment_id	The id of the attachment in the attachment table	FK attachment	●
description	A description of the picture	String(255)	●
folder_id	The folder which this picture belongs to. -1 indicates that the picture is on the root	Int
flags	Various flags for this picture	UInt	●
status	Indicates the status of the picture. 0 = ok, 1 = deleted	Short
hits	Number of hits on this image	Int	●
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	●

[!includedetails]

Fields	Types	Description
id	PK	Clustered, Unique
attachment_id	FK	Index

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.