Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2101)

2064 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Database tables and fields
I
PRODUCT_ID This record will be per product. Hence this will
have the id of the product. int
PRODUCT_TYPE_ID Foreign Key references TARGET_TYPE(id). This
identifies the PRODUCT_ID. (Whether it is
switch, device, etc). int
STATUS Indicated the product deployment status
1-Aborted
2-Succesful
3-Partial Failure
4-Failed smallint
MESSAGE Message to be displayed in the report. txt
ERROR_CODE Error code, can be used for i18n int
TABLE 162 DEPLOYMENT_STATUS
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_CONFIGU
RATION_ID Foreign Key References
DEPLOYMENT_CONFIGURATION(id).
Identifies the deployment configuration int
DEPLOYMENT_TIME Start Time of the deployment (UTC) timestamp with time zone
STATUS Overall status of the deployment.
1-In Progress
2-Success
3-Failure
4-Partially failed smallint
DEPLOYED_BY User who deployed the configuration varchar 255
STATUS_MESSAGE Overall Success/Failure status description txt
TRIGGER_SOURCE Maintains the source from which this
deployment was triggered such as Event Action
<Event policy name>, Manual and Scheduled
etc. varchar 128
TABLE 163 DEPLOYMENT_TARGET_MAP
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_CONFIGU
RATION_ID Foreign Key References
DEPLOYMENT_CONFIGURATION (id)
Identifies the deployment configuration this row
is applied int
TARGET_ID Identifies the target. It will NOT have mapping
to any product table like device, etc varchar 255
TABLE 161 DEPLOYMENT_PRODUCT_STATUS (Continued)
Field Definition Format Size