Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
62
1.1.36 CTC_UserProfile_Table
The CTC_UserProfile_Table contains information about CTC user profiles.
Primary key: CTC_USR_PROF_TABLE_PK
Tablespace: None
Table 1-35: CTC_UserProfile_Table
Column Name
Oracle Data Type
Integrity
Constraints
Constraints
Description
UserID
VARCHAR2(64)
—
User ID of the CTC user type.
UserPassword
VARCHAR2(64)
NOT NULL
Password of the CTC user type.
PrivilegeID
NUMBER(10)
NOT NULL
Privilege ID of the CTC user type.
UserDesc
VARCHAR2(256)
NOT NULL
Description of the CTC user type.
1.1.37 CTM_Config_Table
The CTM_Config_Table stores Prime Optical configuration information. For detailed
definitions of the parameters in this table, see
definitions of the parameters in this table, see
Primary key: ctm_config_table_pk
Tablespace: BASE_DATA_TABLESPACE
Table 1-36: CTM_Config_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
SectionName
VARCHAR2(40)
NOT NULL
Name of the section.
PropertyName
VARCHAR2(40)
NOT NULL
Name of the parameter.
ActiveValue
VARCHAR2(128)
—
Active value of the parameter.
IsPermanent
NUMBER(1)
NOT NULL
Whether or not the value can be
changed. Values are:
0: False
1: True
changed. Values are:
0: False
1: True
PermanentValue
VARCHAR2(128)
—
Permanent value of the parameter.
1.1.38 CTM_Unique_ObjectType_Table
Primary key: None
Tablespace: BASE_DATA_TABLESPACE