Brocade Network Advisor SAN User Manual v12.3.0 - Manual (Page 1603)

Brocade Network Advisor SAN User Manual 1551
53-1003154-01
Database tables and fields
H
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 91 DEPLOYMENT_REPORT_TEMPLATE
Field Definition Format Size
DEPLOYMENT_HANDLER_ID Foreign Key references
DEPLOYMENT_HANDLER(id). int
HEADER Stores header content of deployment report. This
could be plain text or HTML or XML text
FOOTER Stores the footer content of deployment report.
This could be plain text or HTML or XML. text
TABLE 92 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 90 DEPLOYMENT_PRODUCT_STATUS (Continued)
Field Definition Format Size