User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1683
53-1003153-01
Database tables and fields
I
EXPIRATION_TIME num (20,0)
FORMAT num (2,0)
DESCRIPTION varchar 1024
NOTIFICATION_TIME The time stamp (long format) of the last expiration
notification sent
num (20,0)
NOTIFICATION_SENT The status of last notification sent.
Possible values: Unknown -0, Good 1, Expiring 2,
Expired 3
num (2,0)
NOTIFICATION_REPEAT Indicates whether repeat expiration notification is
enabled for this certificate or not.
Possible values: Repeat Disabled - 0, Repeat Enabled -
1
num (2,0)
SYNC_DEVICE Indicates whether this certificate is in sync with device
or not.
Possible values: Need Deploy 0, Imported 1, Deployed
2, Unknown 3.
num (2,0)
CERTIFICATE The content of the ssl certificate. txt
USER_ID This field will be populated when the Management
application user creates certificate or import
certificates from file. User can view this certificate not
bound to any vip in SSL certificate dialog
int
TABLE 384 SSL_CERTIFICATE_VIP_SERVER_MAP
Field Definition Format Size
SSL_CERTIFICATE_ID Foreign key to SSL_CERTIFICATE_ID in ssl_certificate
table
int
VIP_SERVER_ID The column holds ID of VIP Server. It is Foreign Key and
refers to ID column of VIP_SERVER table
int
TABLE 385 SSL_KEY
Field Definition Format Size
ssl_key_id int
name varchar 255
location varchar 255
file_name varchar 255
key_type varchar 2
encryption_type varchar 2
password varchar 255
description varchar 1024
strength The strength of the private key in bits. int
TABLE 383 SSL_CERTIFICATE (Continued)
Field Definition Format Size