Table: dbo.License
Contains information about the firm's current licenses. Client Access products can't see license files but sometimes need to know which licenses exist. This was created to support ACS Client Acces PR Only.
Columns
NameTypeConstraintsDescription
license_KEYint (4)NOT NULLPrimary Key for this table.
product_codenvarchar (20)NOT NULLThe product code that uniquely identifies the license.
Primary key
NameColumnsDescription
PK_Licenselicense_KEY
Unique constraints
NameColumnsDescription
UK_License$product_codeproduct_code

Schema diagram