DataRight Table (195)

• 2 minutes to read
 • 2 minutes to read

Data right definition

Fields

Name Description Type Null
DataRight_id Primary key PK
roleId Role this dataright is valid for FK Role
tableId ID of table this right is valid for TableNumber
fieldId ID of field this right is valid for. 0 = whole table. Must correspond to tableId! FieldId
relationToOwner How is the owner related to the target - 0 = Owner, 1 = Primary group, 2 = Other, 3 = Other group, 4 = External, 5 = Anonymous, 6 = My company, 7 = Same project, 8 = Other to external, 9 = Hide this relation (used with ShownOtherCompanyAssoc functional right) Enum RelationToOwner
CRUD Allowed operations, composed of characters indicating operations. String(39)
encryptedCheck Encrypted data, to detect unwanted changes String(254)
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

DataRight table relationship diagram

Indexes

Fields Types Description
DataRight_id PK Clustered, Unique
roleId FK Index
roleId, tableId, fieldId, relationToOwner FK, TableNumber, FieldId, Enum Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
Role User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see http://techdoc.superoffice.com

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • 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.