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