Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
92
1.1.74 L2_Vlan_Table
The L2_Vlan_Table contains information about the VLANs in an L2 topology.
Primary key: VLAN_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-72: L2_Vlan_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
TopoNodeID
NUMBER(10)
NOT NULL
Node ID of the circuit's source node
where Point-to-Point topology is used.
Where SPR is used, it is the node ID of
the node that is equal to the maximum of
all node IDs in the SPR.
where Point-to-Point topology is used.
Where SPR is used, it is the node ID of
the node that is equal to the maximum of
all node IDs in the SPR.
TopoUniqueId
NUMBER(10)
NOT NULL
Unique number within the node.
Vlan_Number
NUMBER(10)
NOT NULL
Unique number to identify the VLAN.
Service_Id
VARCHAR2(50)
—
Prime Optical service ID.
Customer_Id
VARCHAR2(50)
—
Prime Optical customer ID.
VlanStatus
NUMBER(2)
—
VLAN status.
ManagedVlan
NUMBER(1)
—
VLAN in the L2 topology.
1.1.75 Link_Layer_Mapping_Table
The Link_Layer_Mapping_Table maps information between link layer integer values and
strings. Integer values are stored in the database and are converted to string values for
user display. The Link_Layer_Mapping_Table is used to convert the integer values to
string values.
strings. Integer values are stored in the database and are converted to string values for
user display. The Link_Layer_Mapping_Table is used to convert the integer values to
string values.
Primary key: LINK_LAYER_MAPPING_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-73: Link_Layer_Mapping_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
LinkLayerId
NUMBER(2)
—
Integer representing the layer ENUM.
LinkLayerString
VARCHAR2(30)
—
Corresponding string value of
LinkLayerId.
LinkLayerId.
1.1.76 Link_Table
The Link_Table contains information about the links on the Prime Optical Network Map.