Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
85
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SPEED
VARCHAR2(30) —
Speed:
10: MIN_SPEED
100: MAX_SPEED
auto: AUTO_SPEED
10: MIN_SPEED
100: MAX_SPEED
auto: AUTO_SPEED
DUPLEX
VARCHAR2(30) —
Duplex value:
full: FULL_DUPLEX
half: HALF_DUPLEX
auto: AUTO_DUPLEX
full: FULL_DUPLEX
half: HALF_DUPLEX
auto: AUTO_DUPLEX
FLOWCONTROL_SEND
VARCHAR2(30) —
Flow Control (send) value.
FLOWCONTROL_RECEIVE
VARCHAR2(30) —
Flow Control (receive) value.
RSTP_STATUS
NUMBER(2)
—
RSTP_STATUS has the following
values:
0: DISABLE
1: ENABLE
values:
0: DISABLE
1: ENABLE
CDP
VARCHAR2(30) —
Cisco Discovery Protocol.
IP_ADDRESS
VARCHAR2(50) —
IP address.
SUBNET_MASK
VARCHAR2(50) —
Subnet mask.
1.1.68 L2_Ipsla_Attribute_Table
The L2_Ipsla_Attribute_Table contains information about the attributes of IP service-
level agreements (SLAs) that were created for a specific Layer 2 service.
level agreements (SLAs) that were created for a specific Layer 2 service.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-66: L2_Ipsla_Attribute_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
Source_NeId
NUMBER(10)
NOT NULL
Node ID of the circuit's source node.
Source_PhyLoc
NUMBER(20)
NOT NULL
Source physical location.
Ipsla_Number
NUMBER(10)
NOT NULL
Unique number to identify the IP SLA.
AttributeName
VARCHAR2(50)
NOT NULL
Name of the IP SLA attribute.
AttributeValue
VARCHAR2(50)
—
Value of the IP SLA attribute.