Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1248 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 184 LICENSE
Field Definition Format Size
ID Unique Number assigned for the license information. int
LICENSE_KEY License key string which has encoded value of number
of products, ports licensed and package which this
license isapplicable, etc.
varchar 1024
SERIAL_NO Unique serial number string that helps to identify the
customer or organization which this license is issued
for.
varchar 255
CREATION_TIME Time at which this license key is added timestamp
TYPE Type of license:
• 0 - Trial,
• 1 - Permanent.
The default value is 0.
smallint
SUB_TYPE Sub Type of license:
• 0 - Base,
• 1 - Addon.
The default value is 0.
smallint
VALID Is this license still considered:
• 0 - No,
• 1 - Yes.
The default value is 1.
smallint
TABLE 185 LICENSE_DOWNGRADE_DETAILS
Field Definition Format Size
ID Primary key ID.
PREVIOUS_LICENSE_INFO Previous License information during downgrade. The
details will have license type, license count like fabric,
device, port, MPLS etc.
varchar 512
NEW_LICENSE_INFO New License information during downgrade. The
details will have license type, license count like fabric,
device, port, MPLS etc.
varchar 512
DOWNGRADE_TIME Time when License is downgraded. timestamp
DOWNGRADED_BY User who performed license downgrade. int
IS_ACTIVE Takes the value 0 or 1.
• 1 - currently active downgrade
• 0 - inactive or older downgrade.
smallint
TABLE 186 LICENSE_FEATURE_MAP
Field Definition Format Size
LICENSE_ID* Foreign Key (SWITCH_LICENSE.ID) and is part of the
primary key.
int
FEATURE_ID* Foreign Key (LICENSED_FEATURE.ID) and is part of
the primary.
int