Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Table Of Contents
Brocade Network Advisor SAN User Manual 1417
53-1002948-01
Database tables and fields
H
TABLE 245 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 246 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 etc.
varchar 512
NEW_LICENSE_INFO New License information during downgrade. The
details will have license type, license count like fabric,
device, port 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 247 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