Brocade Communications Systems IP250 user manual Sslkey, Database tables and fields Sslcertificate

	Database tables and fields		I
TABLE 375 SSL_CERTIFICATE (Continued)
Field	Definition	Format	Size
EXPIRATION_TIME		num	(20,0)
FORMAT		num	(2,0)
DESCRIPTION		varchar	1024
NOTIFICATION_TIME	The time stamp (long format) of the last expiration	num	(20,0)
	notification sent
NOTIFICATION_SENT	The status of last notification sent.	num	(2,0)
	Possible values: Unknown -0, Good 1, Expiring 2,
	Expired 3
NOTIFICATION_REPEAT	Indicates whether repeat expiration notification is	num	(2,0)
	enabled for this certificate or not.
	Possible values: Repeat Disabled - 0, Repeat Enabled -
	1
SYNC_DEVICE	Indicates whether this certificate is in sync with device	num	(2,0)
	or not.
	Possible values: Need Deploy 0, Imported 1, Deployed
	2, Unknown 3.
CERTIFICATE	The content of the ssl certificate.	txt
USER_ID	This field will be populated when the Management	int
	application user creates certificate or import
	certificates from file. User can view this certificate not
	bound to any vip in SSL certificate dialog
TABLE 376 SSL_CERTIFICATE_VIP_SERVER_MAP
Field	Definition	Format	Size
SSL_CERTIFICATE_ID	Foreign key to SSL_CERTIFICATE_ID in ssl_certificate	int
	table
VIP_SERVER_ID	The column holds ID of VIP Server. It is Foreign Key and	int
	refers to ID column of VIP_SERVER table
TABLE 377 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

Brocade Network Advisor IP User Manual	1535
53-1003056-01