Database Design Report XML Output Grammar

| BaseTable Section 7
BaseTable Section
<FileReferenceCatalog><OdbcDataSource><FilterTables
— —
tableName="table"
Any valid text string The table name to filter for. Optional, defaults
to blank.
schemaName="schema"
Any valid text string The schema name to filter for. Optional,
defaults to blank.
catalogName="catalog"
Any valid text string The catalog name to filter for. Optional,
defaults to blank.
typeBasedFilter="True"
Can have one of the
following values:
1 True
1 False
Attribute indicates if data source filters on
object type, specifically identified below.
Optional, defaults to False.
retrieveTables="True"
Can have one of the
following values:
1 True
1 False
Attribute indicates if tables should be retrieved.
Optional, defaults to False.
retrieveViews="True"
Can have one of the
following values:
1 True
1 False
Attribute indicates if views should be retrieved.
Optional, defaults to False.
retrieveSystemTables="True"
Can have one of the
following values:
1 True
1 False
Attribute indicates if system tables should be
retrieved. Optional, defaults to False.
Tag Name Value Description
<FMPReport><File><BaseTableCatalog>
— XML node for catalog of (base) table
definitions.
<FMPReport><File><BaseTableCatalog><BaseTable
— XML node for the (base) table definition.
name="Table1"
Any valid table name. —
shadow="True"
Can have one of the
following values:
1 True
1 False
Indicates whether or not this table is a shadow
table.
id="1"
Internal unique positive
integer value indicating
creating order.
—
records="12">
Stores the record numbers of
a table.
—
<FMPReport><File><BaseTableCatalog><BaseTable>
<DataSourceRef
A reference to the data source associated with
this table. Only available if the "shadow"
attribute of the parent BaseTable is "True".
name="..."
Any valid string. The name of the data source (data source
names are unique.)
Tag Name Value Description