• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

s_picture_entry Table (340)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

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 ●

s_picture_entry table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top