Cisco Cisco Prime Optical 9.6 기술 참조

Cisco Prime Optical 9.6.3 Database Schema

OL-28045-01

135

Table 1-120: ObjectTypeTable

Column Name

Oracle Data
Type

Integrity
Constraints

Description

MODELTYPE

NUMBER(4)

NOT NULL

Model type.

OBJECTINDEX

NUMBER(10)

NOT NULL

Metadata object index.

METADATAINDEX

NUMBER(5)

—

Index in the ObjectAttributeTable.

OBJSHORTNAME

VARCHAR2(32)

NOT NULL

Short name for the object.

OBJLONGNAME

VARCHAR2(128)

—

Long name for the object.

PARENTINDEX

NUMBER(5)

—

Index of the parent object.

BOARDNAME

VARCHAR2(32)

—

Name of the object (module).

1.1.125

ONS15216_Active_User_Table

Primary key: ONS15216_ACTIVE_USER_TABLE_PK

Tablespace: ONS152xx_DATA_TABLESPACE

Table 1-121: ONS15216_Active_User_Table

Column Name

Oracle Data
Type

Integrity
Constraints

Description

NEDBAccessID

NUMBER(10)

NOT NULL

ID to access this table for an NE; same as
NEDBAccessID in the NE_Info_Table.

UserID

VARCHAR2(64)

NOT NULL

ONS 15216 username.

1.1.126

ONS15216_NE_Inventory_Table

The ONS15216_NE_Inventory_Table stores ONS 15216 inventory information.

Primary key: ONS15216_NE_INVENTORY_PK

Tablespace: ONS152XX_DATA_TABLESPACE

Table 1-122: ONS15216_NE_Inventory_Table

Column Name

Oracle Data
Type

Integrity
Constraints

Description

NEDBAccessID

NUMBER(10)

NOT NULL

ID to access this table for an NE; same as
NEDBAccessID in the NE_Info_Table.

Cleicode

VARCHAR2(32)

—

CLEI code for the card.

PartNumber

VARCHAR2(32)

—

Part number of the module.

SerialNumber

VARCHAR2(32)

—

Serial number of the module.