Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
299
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NECount
NUMBER(10)
NOT NULL
Number of NEs managed by the service.
State
NUMBER(5)
NOT NULL
State of the service. Values are:
0: Stopped
1: Running
2: Failed
0: Stopped
1: Running
2: Failed
DiscoveryMode
NUMBER(2)
DEFAULT 1
Discovery mode of the service. Valid
values are:
0: Manual
1: Automatic
values are:
0: Manual
1: Automatic
1.1.239
SVC_Info_Table
The SVC_Info_Table contains information about the service package.
Primary key: SVC_INFO_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-229: SVC_Info_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SvcID
NUMBER(10)
NOT NULL
Service ID.
SvcName
VARCHAR(64)
NOT NULL
Service name.
SvcPackageID
NUMBER(10)
NOT NULL
Unique ID of the service package.
SvcKind
NUMBER(10)
NOT NULL
Service kind. Values are:
0: NE
1: PM
0: NE
1: PM
SvcConfigName
VARCHAR(64)
NOT NULL
Service configuration name.
IsNPDependent
NUMBER(1)
NOT NULL
Values are:
0: False
1: True
0: False
1: True
IOR
VARCHAR2(64)
—
IOR representation.
1.1.240
SVC_NEModel_Table
The SVC_NEModel_Table contains information about the service NEs.
Primary key: SVC_NEMODEL_PK
Tablespace: BASE_DATA_TABLESPACE