element_profile table - SuperOffice

element_profile Table (328)

The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
name	This is the name used by common profiles	String(255)	Yes
static_element	An enum for which HtmlElement this is. All profileable elements in static screens has a unique enum matching this one.	static_element	Yes
screen_definition_element	The id of the screen_definition_element.	FK screen_definition_element	No
profile_type	Enum indicating whether this is the default profile (only one), user profile or a common profile. Defined in Profile.h	profile_type	Yes
element_type	What kind of element is this? Static, blogic or extra table?	element_type	Yes
owned_by_user	The id of the user.	FK ejuser	No
config	The actual profile data. Each HtmlElement may choose format. Normally XML.	Clob	Yes
filter_field	Name of field, if any, that is used to filter which profiles should be shown	String(254)	Yes
filter_value	If filter_field is set, then this field is the value that is used to filter which profiles should be shown	String(254)	Yes

element_profile table relationship diagram

Indexes

Fields	Types	Description
screen_definition_element	FK	Index
owned_by_user	FK	Index

Relationships

Table	Description
ejuser	This table contains entries for the users of the system.
role_element	Profiles associated with a role
screen_definition_element	An element in a configurable screen

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

role_element table screen_definition_element table profile table s_list_element table Profile ejuser table

⌘I