LicenseAssocLink table - SuperOffice

LicenseAssocLink Table (238)

Link between ModuleLicense and Associate, for per-assoc licenses; this is how licenses are assigned/consumed

Fields

Name	Description	Type	Nullable
LicenseAssocLink_id	Primary key	PK	No
moduleLicenseId	The license being linked	FK ModuleLicense	No
assocId	The associate who occupies one instance of this license	FK associate	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 associate - each module will have to decide on the semantics of this	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

Indexes

Fields	Types	Description
moduleLicenseId, assocId	FK, FK	Unique

Relationships

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

Replication Flags

Area Management controlled table. Contents replicated to satellites and traveller databases.
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

LicenseSatlLink table ModuleLicense table Module licenses Protected tables associate table Get Default Associate User Name

⌘I