Cloudsync System Tables
Page 2 of 4

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)