Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
286
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEModel
NUMBER(10)
NOT NULL
NE model.
NEModelIndex
NUMBER(10)
NOT NULL
NE model index.
ModuleType
NUMBER(10)
NOT NULL
Module type.
PMCategory
VARCHAR2(64)
NOT NULL
PM category.
OBJECTTYPEID
NUMBER(10)
NOT NULL
Object type ID.
PMTableColNo
NUMBER(10)
—
PM table column number.
PMParamID
NUMBER(10)
NOT NULL
Sequence ID.
InterfaceType
VARCHAR2(64)
NOT NULL
Interface type.
ParamPosition
NUMBER(10)
NOT NULL
Bulk PM parameter position.
ValidityPosition
NUMBER(10)
NOT NULL
Bulk PM validity position.
TCANumber
NUMBER(10)
—
TCA number.
TCALocation
VARCHAR(10)
—
TCA location.
Direction
VARCHAR(10)
DEFAULT ‘N/A’ Line direction.
1.1.225
Port_Channel_Table
The Port_Channel_Table contains information about port channel interfaces for ML-
series cards.
series cards.
Primary key: PORT_CHANNEL_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-215: Port_Channel_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NE_NODE_ID
NUMBER(10,0) —
The identification of the NE containing
the ML card and port channel.
the ML card and port channel.
SLOT_NUMBER
NUMBER(2,0)
NOT NULL
The slot number.
PORT_CHANNEL_ID
NUMBER(2,0)
NOT NULL
The port channel ID identifies the port
channel interface. Prime Optical
generates the ID automatically; the
range is from 1 to 64.
channel interface. Prime Optical
generates the ID automatically; the
range is from 1 to 64.
ADMIN_STATE
NUMBER(1,0)
—
The status of the port channel
interface. Values are:
0: Down
1: Up
interface. Values are:
0: Down
1: Up