s-picture-entry.md

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

s_picture_entry Table (340)

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]

Indexes

Fields	Types	Description
id	PK	Clustered, Unique
attachment_id	FK	Index

Replication Flags

• None

Security Flags

• No access control via user's Role.