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

ModuleLicense Table (237)

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

Module licenses, belonging to one single owner

Fields

Name Description Type Null
ModuleLicense_id Primary key PK
moduleName The name of the module, not visible in GUI but used in the code. This must be in UPPER CASE and only contain A-Z and 0-9. NO EXTENDED CHARACTERS please. String(239)
moduleDescription Human-readable description of module, shown in GUI, default language. Additional languages can be added to LocaleText, resource type 25 String(254)
moduleVersion Version string for this module String(254) ●
tooltip Tooltip text, anything you want; shown when the cursor hovers over the line in the GUI. Default language. Additional languages can be added to LocaleText, resource type 27 String(254)
licenseType Entire system, per database, or per associate Enum LicenseType
licenseNumber Number of systems, databases or associates licensed UInt
allowedAssocsMask Bitmask of allowed associate types who can have this kind of license UInt
extraFlags Unspecified extra flags of license, part of checksum. Value=1 means this a 'user plan'; such licenses cause the admin gui to switch to radiobutton view UInt
extraInfo Free field, can be used by the module owner (example: host domain, for eJournal). NOTE: For rows with extraFlags=1 this field contains the list of modules that this plan comprises String(3999) ●
encryptedCheck Encrypted checksum that stops tampering and copying between databases 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
ModuleOwner_id Link to owner of this module FK ModuleOwner
sortOrder Ordering value - generated by SuperLicense and transferred here. Must be followed for signatures to be correct Id ●
signature Signature that verifies that this row is correctly transferred from SuperLicense String(254) ●
unrestricted If true, then there is no licenseNumber limit on how many of these modules may be assigned Bool ●
hidden If true, then this module should not appear in GUI and is not assignable by users Bool ●
prerequisiteModule If set, specifies a module license needed before this license can be granted String(239) ●

ModuleLicense table relationship diagram

Types of module licenses

licenceType ID Comment
Unknown 0 Not a legal value
SiteLicense  1 License is valid for a site (complete installation included all satellites and travellers)
SatelliteLicense 2 License is valid for a database (central, satellite, travel?)
UserLicense 4 License is valid for a particular user

Indexes

Fields Types Description
ModuleLicense_id PK Clustered, Unique
moduleName, moduleVersion, ModuleOwner_id String(239), String(254), FK Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons
LicenseAssocLink Link between ModuleLicense and Associate, for per-assoc licenses; this is how licenses are assigned/consumed
LicenseSatlLink Link between License and Satellite, for per-database licenses
ModuleOwner Unique owner of a set of licensed modules

Replication Flags

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