Database Design Report XML Output Grammar

8 FileMaker Pro Advanced Database Design Report XML Output Grammar
All nodes below start with <FMPReport><File><BaseTableCatalog><BaseTable>
catalogName="catalog"
Any valid string. The name of the remote table's catalog in the
ODBC data source.
schemaName="schema"
Any valid string. The name of the remote table's schema in the
ODBC data source.
tableName="table">
Any valid string. The name of the remote table's table name in
the ODBC data source.
Tag Name Value Description
<FieldCatalog>
— XML node for catalog of fields.
<FieldCatalog><Field
— XML node for a field.
name="Field1"
Any valid field name. —
id="1"
Internal unique positive
integer value indicating
creating order.
—
fieldType="Normal"
Can have one of the
following values:
1 Normal
1 Calculated
1 Summary
1 Invalid
Indicate the field type.
shadowType="Supplemental"
Can have one of the
following values:
1 Shadow
1 Supplemental
Specifies the shadow field type. Only available
if the parent BaseTable's "shadow" attribute is
"True."
dataType="Binary" >
Can have one of the
following values:
1 Text
1 Number
1 Date
1 Time
1 TimeStamp
1 Binary
Indicate what kind of data is stored in the field.
<FieldCatalog><Field><Calculation
— XML node for a calculation.
alwaysEvaluate="True"
Can have one of the
following values:
1 True
1 False
Attribute indicates if calculation is always
evaluated.
This attribute is applicable to calculation in
field definitions only.
table="Table1">
Valid table name. Indicates the context table of the calculation.
This attribute is applicable to auto-enter
calculation only.
<FieldCatalog><Field><Calculation><![CDATA[ F1 ]]>
CDATA containing the
calculation text.
—
Tag Name Value Description