Tables in the product library geodatabase (Defense Mapping)

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.

CautionCaution:

Don't edit these tables directly; doing so may corrupt the product library.

Table name

What it contains

PL_TemplateInstruction

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

PL_Database

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

PL_DataModel

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

PL_DataModelVersion

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

PL_Dataset

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

PL_File

References to files that have been loaded into the product library

PL_FileData

Metadata for files in the product library

PL_FileVersion

Information about specific versions of files

PL_Relationship

References to relationships that exist in the geodatabase schemas

PL_SpatialReference

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

PL_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

PL_<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 PL_JOG_AOI.)

PL_<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 PL_JOG_Instance.)

PL_<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 PL_JOG_Product.)

PL_<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 PL_JOG_Series.)

PL_ClassVersion

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

PL_EntryType

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

PL_Permission

The permissions assigned for each product library user

PL_ProductClass

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

PL_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_ClassVersionQuery

References to queries created at the product class level

PL_CustomObject

Stores the production environment property type (Desktop or Enterprise) used when creating nautical products

PL_ExtractionExclusion

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

PL_ExtractionQuery

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

PL_ReplicationHistory

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

NoteNote:

This only applies if you are using an enterprise geodatabase or an ArcSDE geodatabase for SQL Server Express licensed for ArcGIS for Desktop and the ArcGIS for Maritime: Charting.

PL_Components

Version information for product library components 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
12/22/2014