s_picture_folder table - SuperOffice

s_picture_folder Table (339)

This table contains all picture folders

Fields

Name	Description	Type	Nullable
id	Primary key	PK	No
name	Name of folder	String(255)	No
parent_id	The parent id for this folder. -1 for root folders	Int	No
description	A description of the folder	String(255)	Yes
folder_type	Indicates which type of folder this is	Short	No
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
folder_type	Short	Index
parent_id, folder_type	Int, Short	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
form	A form which can be published on a webpage and submitted by visitors

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Get Picture Folder Entity form table MailingFolders FormFolders formfolder shipmentfolder

⌘I