element_profile Table (328)

• 2 minutes to read
 • 2 minutes to read

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

Fields

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

element_profile table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
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.