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

company Table (1)

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

Information on license and owner of this SuperOffice database. This table should only have 1 row. This table contains encrypted license information. Changing it will disable login for all users and require you to restore the database from backup.

Fields

Name Description Type Null
company_id Primary key PK
version Database version, must match dictionary (conceptualdatabase) Int
revision Database revision, must match dictionary UShort
ownerContactName Name of contact who owns the license - exact match required String(219)
ownerDepartmentName Department of contact who owns the license - exact match required String(219)
ownerContactId ID of contact who owns the license Id
dbContactName Name of contact who owns this database (<> license owner for satellite etc) String(219)
dbDepartmentName Department of contact who owns this database String(219)
dbContactId ID of contact who owns this database Id
serialNo Serial number of license; this is THE master item... which will be checked against SuperOffice AS license database by SoAdmin! String(219)
extraInfo Spare field String(254) ●
encryptedCheck Encrypted hash checksum 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

company table relationship diagram

Indexes

Fields Types Description
company_id PK Clustered, Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons

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