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

UserPreference Table (56)

Some tooltip text!
• 3 minutes to read
 • 3 minutes to read

Preference system. If deflevel is set to 5; the user may change the preferences

Fields

Name Description Type Null
userpreference_id Primary key PK
deflevel The level: 0=hard default, 1=systemwide, 2=database, 3=group, 4=individual Enum PreferenceLevel
maxlevel Highest override level allowed Enum PreferenceLevel
owner_id level=3: group; level=4: associate Id
prefsection Preference section name String(199)
prefkey Preference key name String(199)
prefvalue Preference value String(2046) ●
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

UserPreference table relationship diagram

Values needed to access the UserPreference tables

This table must have special values that are not easy to guess correctly. They are listed below with a description of how to use them.

The User preference override level is the level at which a particular preference is defined.

Levels ID Comment
Undefined 0 Undefined value (error)
Hard default 1 Default value used if no other value has been specified. Hard-coded default, owner_id == 0
System wide 2 Value valid for all databases under this licence, owner_id == 0
Database 3 Valid for all users of this database, owner_id = travelcurrent.current_id
Group 4 Valid for all users that are members of this group, owner_id = UserGroup.Id
Individual 5 Valid for this associate only, owner_id = associate.id
PC 6 Valid for this PC only, not connected to user. (Note: stored in the Registry, not in the database)

Indexes

Fields Types Description
userpreference_id PK Clustered, Unique
deflevel Enum Index
owner_id Id Index
prefsection String(199) Index
prefkey String(199) Index
prefsection, prefkey, deflevel, owner_id String(199), String(199), Enum, Id Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
text Long text fields from all over the system

Replication Flags

  • Area Management controlled table. Contents replicated to satellites and traveller databases.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

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