Cisco Cisco E-Mail Manager Unity Integration Option テクニカルリファレンス
2-115
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Ids Table
Ids Table
Indicates whether a specific object type supports row-level security. For those object types that do
support row-level security, the Ids table contains one row for each object of that type.
support row-level security, the Ids table contains one row for each object of that type.
Related tables:
Object List (via ObjectType)
Object Security (via ObjectType + ObjectID)
User Security Control (via ObjectType+ ObjectID)
Import_Log Table
Central database only.
Contains information about schedule import operations that have been performed. The ICM software
automatically creates an Import_Log row each time it imports schedule information.
automatically creates an Import_Log row each time it imports schedule information.
Table 2-93 Ids Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ObjectType
Identifies the object type.
int
PK, FK, NOT
NULL
NULL
ObjectID
Identifies a specific object for which row-level security is
supported. If the object type does not support row-level
security, this value is 0.
supported. If the object type does not support row-level
security, this value is 0.
int
PK, NOT NULL
ParentObjectType
Identifies the object type of the object’s parent. For example,
a peripheral is a parent to its trunk groups. A value of 0
indicates that the object has no parent.
a peripheral is a parent to its trunk groups. A value of 0
indicates that the object has no parent.
int
NOT NULL
ParentObjectID
Identifies the object’s parent. A value of 0 indicates that the
object has no parent.
object has no parent.
int
NOT NULL
Table 2-94 Import_Log Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
The date and time when the row was generated.
datetime
PK, NOT NULL
ScheduleID
Identifies the schedule affected.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
PK, NOT NULL
LogOperation
The operation that was logged; for example Import or
Edit.
Edit.
varchar(32)
NOT NULL
WorkstationName
The workstation from which data was imported.
varchar(32)
NOT NULL
RowsCopied
The number of rows imported or modified.
int
NOT NULL