About Database Structure

When you publish data to MapGuide, a Microsoft Access Database (MDB) is created that contains information about the exported graphic objects and property set data.

Exported database file

Table Name Content
ADT_Drawings This table lists information about the drawing from which the data is exported. Information includes file name, path, date of last modification, and the units of the drawing.
ADT_Object Types This table provides a listing of the object types and object styles contained in the exported data. Each type and style is assigned an ID, which is later used to identify individual objects in the ADT_Objects table.
ADT_Objects This table lists all individual objects contained in the exported data.
ADT_Property Set Definitions This table provides a listing of the property set definitions contained in the exported data. Each property set definition is assigned an ID, which is later used to identify individual properties.
ADT_Property Definitions This table lists all properties contained in the exported data. To identify individual properties, use the PropertySetId from the ADT_Property Set Definitions table.
<Objects> For each object type that has property data attached directly to one or more of its objects, a table is created that contains the objects and their associated property data. For example, if an exported drawing contains a number of doors with attached properties for frame depth and frame width, a DoorObjects table is created that lists all of these doors and their frame depths and frame widths.
<Object>Styles For each object type that has property data attached via an object style, a table is created that contains the objects and the property data derived from their styles. For example, if an exported drawing contains a number of doors with a style controlling the louver height and louver width, a DoorStyles table is created that lists all doors of that style with their louver heights and louver widths.
Note: For a detailed view and description of the individual tables, select a table in Microsoft Access, right-click, and click Design View.

When you export data to an MDB, make sure that your property set definitions names, property definition names, and layer names meet the following naming criteria.