[top]
[prev]
[next]

Table of Contents
Index
Documentation Top
Global Index
|
SYSPUBITEMS
Lists published dictionary objects. It contains one row per object per publication.
Column Name |
Type |
Length |
Nullable |
Contents |
PUBLICATIONID |
CHAR |
36 |
false |
Unique identifier for the publication (joins with SYSPUBS). |
ITEMID |
CHAR |
36 |
false |
Object ID of an item included explicitly or implicitly in the publication. |
ITEMTYPE |
INT |
|
false |
Indicates whether this row corresponds to a table, view, trigger, etc. Determines which system table itemID joins to. The possible values of ITEMTYPE are states in the COM.cloudscape.database.Database class. |
EXPLICIT |
BOOLEAN |
|
false |
Indicates whether the item was included explicitly or implicitly. |
DETAILS |
java.io.Externalizable
|
|
true |
Contains information on the item. |
Indexes
Non-unique index SYSPUBITEMS_INDEX1 on (PUBLICATIONID, ITEMTYPE)
Unique index SYSPUBITEMS_INDEX2 on (PUBLICATIONID, ITEMID)
Unique index SYSPUBITEMS_INDEX3 on (ITEMID, PUBLICATIONID)
|