Global Configuration Database Table Schemas

The schema for the following Global Configuration Database (GCD) tables is described. Schema information for the GCD database cannot be retrieved from the Content Engine APIs.

• FNGCD
• FNGCD_ADDON

The schemas are based on the 5.5.x version of the Content Engine server, with no add-ons installed. Some column names correspond with system properties created at domain initialization time. Column sizes are shown for the Db2® database system. Column size is expressed in bytes, except for the STRING type, which is expressed as the character size. On Db2, the STRING byte size is 2X the character size. For information about column sizes for other database systems, see Column Size Vendor Differences.

FNGCD Table

Used to store the last 100 versions of the GCD.

Column Name	Data Type	Db2 ColumnSize vendor differences	Allows Null	Description
epoch_id	INTEGER	4	false	Stores the epoch of the GCD version that is stored in this row.
gcd_blob	BLOB	1G	false	Stores the XML data that is the GCD.
modify_date	DATE	10	false	Stores the date of the last modification of the GCD (the insertion date of this row).
last_epoch_id	INTEGER	4	true	Used by the server in row zero to determine the last epoch to use (for race condition management).

FNGCD_ADDON Table

Used to store the data that is associated with add-ons in the Content Cortex domain.

Column Name	Data Type	Db2 ColumnSize vendor differences	Allows Null	Description
object_id	OBJECT	16	false	Used by property: Id of the add-on.
creator	STRING	80	true	Used by property: Creator
create_date	DATE	10	true	Used by property: DateCreated
modify_user	STRING	80	true	Used by property: LastModifier
modify_date	DATE	10	true	Used by property: DateLastModified
xml_manifest	CLOB	512 M	true	Stores the XML manifest file (the import script) of the add-on.
pre_import_script	CLOB	512 M	true	Stores the pre-import script of the add-on.
post_import_script	CLOB	512 M	true	Stores the post-import script of the add-on.