Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
84
1.1.67 L2_Interface_Table
The L2_Interface_Table contains information about L2 interfaces.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-65: L2_Interface_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEID
NUMBER(10)
NOT NULL
NE ID.
SLOT_NUMBER
NUMBER(3)
NOT NULL
Slot number.
BRIDGE_GROUP_NUMBER NUMBER(3)
NOT NULL
Bridge group number.
PORT_NUMBER
NUMBER(2)
NOT NULL
Port number.
PORT_SUB_INTERFACE
NUMBER(4)
—
Port subinterface.
INTERFACE_NAME
VARCHAR2(30) —
Interface name.
INTERFACE_TYPE
NUMBER(3)
—
Interface type:
1: POS
2: FAST ETHERNET
3: GIGABIT ETHERNET
1: POS
2: FAST ETHERNET
3: GIGABIT ETHERNET
PORT_TYPE
NUMBER(2)
—
Port types:
1: UNI
2: NNI
1: UNI
2: NNI
CONNECTION_TYPE
NUMBER(2)
—
Connection types:
1: QinQ
2: Dot1Q
3: Untagged
1: QinQ
2: Dot1Q
3: Untagged
PORT_STATE
NUMBER(2)
—
Port state. Values are:
0: PORT_STATE_DISABLED
1: PORT_STATE_ENABLED
0: PORT_STATE_DISABLED
1: PORT_STATE_ENABLED
POLICING_TYPE
NUMBER(2)
—
Policing type.
QOSTEMPLATE_NAME
VARCHAR2(30
—
Name of the QoS template.
MTU_SIZE
VARCHAR2(30) —
Maximum transmission unit
(MTU) size.
(MTU) size.