LicenseSatlLink table - SuperOffice

LicenseSatlLink Table (239)

Link between License and Satellite, for per-database licenses

Fields

Name	Description	Type	Nullable
LicenseSatlLink_id	Primary key	PK	No
moduleLicenseId	The license being linked	FK ModuleLicense	No
satelliteId	The Satellite who occupies one instance of this license	FK satellite	No
validFrom	Reserved field: Valid from date	DateTime	No
validTo	Reserved field: Valid to date	DateTime	No
licenseNumber	Number of license items occupied by this satellite	UInt	No
comment	Optional comment field	String(254)	No
encryptedCheck	Encrypted checksum; tampering will block system usage	String(254)	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

LicenseSatlLink table relationship diagram

Indexes

Fields	Types	Description
moduleLicenseId, satelliteId	FK, FK	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
ModuleLicense	Module licenses, belonging to one single owner
satellite	Definition of Satellites

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Copy to satellite and travel prototypes.

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

LicenseAssocLink table ModuleLicense table satellite table Save Central License Module licenses NSModuleLicenseLink

⌘I