Tables in the product library geodatabase

The information related to the product library is stored as records in tables. There are several tables created for each product class in the product library, and they contain information such as all the series, products, instances, and areas of interest associated with one product class. There are also separate tables that outline the solutions, users, and files in the product library. The areas of interest are stored in a feature class.

Since the basic structure of the product library is a hierarchy, there are several table items that are related to items in other tables within the product library. Below is a table that contains the names of the tables in the product library as well as a summary of what is contained in each one.

Table name

What it contains

Carto_TemplateInstruction

Data frame rules, layout rules, and python scripts used as part of template instructions

CKB_Database

Metadata about any geodatabase files that are associated with instances in your product library

CKB_DataModel

References to all data model files that are in the product library

CKB_DataModelVersion

Version information for the geodatabase schemas such as major and minor version numbers, revision number, and edition number

CKB_Dataset

Data model dataset feature classes and tables, as well as metadata about each one

CKB_File

References to files that have been loaded into the product library

CKB_FileData

Metadata for files in the product library

CKB_FileVersion

Information about specific versions of files

CKB_RelManager

References to relationships that exist in the geodatabase schemas

CKB_SpatialReference

All the spatial references that can be used with data for chart and map production

CKB_User

The names of users who are allowed to access the product library

FB_Entry

Parameters related to features that have been created using the Feature Builder

ML_Entry

Ancillary information such as cartographic versions of tables and feature classes and references to lookup tables

MT_MaskingRule

Information related to masking rules that have been configured for data in specific data models

PCat_<product class name>_AOI

Polygons that represent all the areas of interest for a product class in the product library (For example, the table that contains all the Joint Operation Graphic [JOG] areas of interest [AOIs] would be PCat_JOG_AOI.)

PCat_<product class name>_Instance

The names of the data frames for all map sheets in a map series for a product class in the product library (For example, the table that contains all the JOG instances would be PCat_JOG_Instance.)

PCat_<product class name>_Product

The names of all the map sheets in a map series for a product class in the product library (For example, the table that contains all the JOG map sheets would be PCat_JOG_Product.)

PCat_<product class name>_Series

The names of all the map series available for a product class in the product library (For example, the table that contains the map series for JOG would be PCat_JOG_Series.)

PCat_ClassVersion

Version information for the product classes such as major and minor version numbers, revision number, and edition number

PCat_EntryType

Information related to map sheets and data frames that are accessible from the product library

PCat_Permission

The permissions assigned for each product library user

PCat_ProductClass

The names of all the product classes that have been loaded into the product library

PCat_Solution

The names of all the solutions that have data schemas loaded into the product library

PL_BatchJob

Stores batch job files that are linked to a product for validation of the production database

PL_FieldConfiguration

Defines display and behavior of attribute fields when editing

PN_ClassVersionQuery

References to queries created at the product class level

PN_CustomObject

References to options used for implementing and populating instances and publishing

PN_ExtractionExclusion

Tables and feature classes that are being excluded from extraction using extraction queries

PN_ExtractionQuery

Metadata related to the extraction queries for different parts of the product library

PN_ReplicationHistory

Metadata related to replicas that have been created for instances in the product library

NoteNote:

This only applies if you are using an ArcSDE geodatabase and the Nautical Solution.

Prod_ComponentVersion

Version information for tools such as major and minor versions, revision numbers, and edition numbers

PV_DefQuery

Definition queries that have been created for feature classes, along with identifiers for the sets in which they belong

PV_DefQuerySet

The names of definition query sets

PV_MaskingSet

The names of masking sets

PV_MaskingSetting

Masking settings that have been configured for feature classes, along with identifiers for the masking sets in which they belong

PV_View

The names of views that have been created using Views

VST_Representations

Information related to specific feature class representation properties that are managed using visual specifications

VST_Rule

Information related to calculated representation rules

VST_Specification

The names of specifications that have calculated representation rules

Tables in the product library

4/17/2012