Logo Help Center

Enterprise Server 9 database tables

Enterprise Server 9 database tables

The overview below shows the database tables that Enterprise Server 9 makes use of.

Table Content
smart_actionproperties Custom metadata properties assigned to workflow dialogs.
smart_appsessions Articles that are currently in draft by users working with the Web Editor application. This includes new, locked and viewed articles.
smart_authorizations Holds the authorization rules.
smart_channeldata Configured properties for the Issue Maintenance pages. Typically used for Issues of Web Publication Channels.
smart_channels Definitions of Brand Channels.
smart_config Version of installed database model. Used by database setup scripts to update the model to newer versions.
smart_datasources Definitions of structured data sources.
smart_deletedobjects If an object is deleted, it is moved to this table from smart_objects.
smart_dsobjupdates Information about updates on objects for use with structured data sources.
smart_dspublications Brands for use with structured data sources.
smart_dsqueries Queries for use with structured data sources.
smart_dsqueryfamilies Information about query families for use with structured data sources.
smart_dsqueryfields Query fields for use with structured data sources.
smart_dsqueryplacements Information about query placements for use with structured data sources.
smart_dssettings Contains settings for use with dynamic data sources.
smart _dsupdates Information about updates for use with structured data sources.
smart_editions Definitions of Editions.
smart_elements Components that an article consists of.
smart_groups Definitions of user groups.
smart_indesignserverjobs Currently defined jobs for InDesign Server.
smart_indesignservers InDesign Server instances.
smart_issueeditions Information about the actual deadline defined for an Edition in a particular Issue.
smart_issues Holds all Issues.
smart_issuesection Information about the actual deadline defined for a section in a particular Issue.
smart_issuesectionstate Information about the actual deadline and relative deadline defined for a status/section combination in a particular Issue.
smart_log Logs user actions. Can be viewed on the Service Logs Maintenance page.
smart_messagelog Holds user and system messages sent to objects as well as Sticky Notes added to layouts. Also used by plan system integrations for storing messages to inform the designer working on the layout about changes made to the plan.
smart_mtp Holds the MadeToPrint integration configuration settings.
smart_mtpsentobjects Holds the objects that are sent to the MadeToPrint integration.
smart_namedqueries Named Query definitions.
smart_objectflags Holds flags for objects.
smart_objectlocks Instead of using DB-specific SQL features, Enterprise uses this table to lock objects. This way the system can be used cross-database.
smart_objectrelations Holds relations between objects, such as which articles are placed on a layout.
smart_objectrenditions Holds rendition information for objects.
smart_objects Metadata for all objects. Note that all objects have a unique ID. Custom properties are added by using “c_” prefixes.
smart_objectversions Information about older version of object versions.
smart_pages For each layout (InDesign) object, this table holds the metadata of its pages.
smart_placements Holds detailed information about the placements of a story/image on a layout.
smart_placementtiles Contains tile information for specific placements.
smart_profilefeatures Definition of Access Profiles.
smart_profiles List of Access Profiles that can be used in the entire system.
smart_properties Custom metadata property definitions.
smart_publadmin Administrators assigned to Brands.
smart_publications Brand definitions of the entire system.
smart_publishedobjectshist Publish history of individual objects in a Dossier.
smart_publishhistory Publish history of Dossiers.
smart_publobjects Publication-specific object rights (by user group).
smart_publsections The sections with links to their Brand.
smart_routing The automatic routing definitions.
smart_sectionstate Information about the relative deadline for a status in a section.
smart_semaphores Contains the application locks for objects.
smart_serverconnectors Information about which connectors are available.
smart_serverjobconfigs Contains the configuration for created Server Jobs.
smart_serverjobs Contains Server Job run information.
smart_serverjobsupports Links Enterprise servers to certain Server Job configurations (telling which Server can do which job).
smart_serverplugins Information about which Server plug-ins are enabled.
smart_servers Contains (additional) server configurations for servers to be used with Server Jobs.
smart_settings User settings, for example the user defined queries.
smart_states Workflow status definitions.
smart_targeteditions Information about which Editions are selected for which targets.
smart_targets Information about which objects are targeted for which Publication Channel(s) and/or Issues.
smart_tickets Tickets for users that are logged on. When a user logs on, a ticket is generated which is used for the subsequent calls.
smart_users User definitions and encrypted password.
smart_usrgrp Links users with user groups.

Reference Materials

Enterprise Server 9 documentation

Was this article helpful?
0 out of 0 found this helpful / Created: / Updated:
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.