> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# s_picture_entry table

> This table describes each picture in the database

## 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](./attachment.mdx) |    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](./associate.mdx)   |    Yes   |
| updated                   | Last updated when                                                                      | UtcDateTime                       |    Yes   |
| updated\_associate\_id    | Last updated by whom                                                                   | FK [associate](./associate.mdx)   |    Yes   |
| updatedCount              | Number of updates made to this record                                                  | UShort                            |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/s_picture_entry.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=99496c0fdd1e76925935bdbd6b09ee4e" alt="s_picture_entry table relationship diagram" width="686" height="59" data-path="media/loc/en/database/tables/s_picture_entry.png" />

## Indexes

| Fields         | Types | Description |
| -------------- | ----- | ----------- |
| attachment\_id | FK    | Index       |

## Relationships

| Table                      | Description                                                                                                                                                   |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [associate](./associate)   | Employees, resources and other users - except for External persons                                                                                            |
| [attachment](./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](/en/database/tables/attachment.md)
- [s_picture_folder table](/en/database/tables/s-picture-folder.md)
- [Put Picture Folder Entity](/en/api/reference/restful/rest/picturefolder/put-picture-folder-entity.md)
- [Post Picture Folder Entity](/en/api/reference/restful/rest/picturefolder/post-picture-folder-entity.md)
- [Get Picture Folder Entity](/en/api/reference/restful/rest/picturefolder/get-picture-folder-entity.md)
- [Default Picture Folder Entity](/en/api/reference/restful/rest/picturefolder/default-picture-folder-entity.md)