Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
245
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
NULL
particular type.
NEDBAccessID1
NUMBER(10)
—
ID of the NE where the discrepancy is
detected.
detected.
NEDBAccessID2
NUMBER(10)
—
ID of the second NE involved in the
discrepancy.
discrepancy.
DcrpTimeStamp
DATE
—
Time when discrepancy was detected.
DcrpDescr
VARCHAR2(256)
DEFAULT
NULL
NULL
Description of the discrepancy.
DcrpDetails
VARCHAR2(1024)
DEFAULT
NULL
NULL
Any details about the discrepancy.
1.1.182
ONS155xx_Discovery_Info_Table
The ONS155xx_Discovery_Info_Table contains information about the main discovery
and NE discovery for the ONS 155xx.
and NE discovery for the ONS 155xx.
Primary key: ONS155XX_DISCOVERY_INFO_PK
Tablespace: ONS155XX_DATA_TABLESPACE
Table 1-178: ONS155xx_Discovery_Info_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access this table for an NE; same as
NEDBAccessID in NE_INFO_TABLE.
NEDBAccessID in NE_INFO_TABLE.
startTime
DATE
—
Starting time of the discovery.
endTime
DATE
—
Finishing time of the discovery.
status
NUMBER(1)
NOT NULL
Discovery status. Values are:
0: Idle
1: In progress
2: Completed
3: Failed
0: Idle
1: In progress
2: Completed
3: Failed
startMode
NUMBER(1)
NOT NULL
Discovery mode. Values are:
1: Scheduled
2: User-requested
3: Update-triggered
1: Scheduled
2: User-requested
3: Update-triggered
descr
VARCHAR2(256)
—
Description.