ObjectType In Common OneData XML | Corresponding Information in ARIS AML file |
Table | TypeNum=”OT_ENT_TYPE” |
Column | TypeNum=”'OT_ERM_ATTR” |
Value In Common OneData XML | Corresponding Value in ARIS AML file |
<ID> Element within <TABLE> or <COLUMN> or <CONSTRAINT> | ObjDef.ID Unique Identifier specified in the ARIS file |
<NAME> Element within <TABLE> or <COLUMN> or <CONSTRAINT> | AttrDef.Type=”AT_NAME Mandatory Attribute link to Logical Name and Physical Name of Table, Column and Constraint |
<DESCRIPTION> Element within <TABLE> or <COLUMN> | For <TABLE>: AttrDef.Type=”AT_DESC” For <COLUMN>: AttrDef.Type=”AT_DESC_VALUE” Optional Attribute linked to Data Object Definition or Column Description. |
<DATA_TYPE> Element within <COLUMN> | AttrDef.Type=”AT_SQL_DATA_TYPE” Mandatory Attribute linked to the OneData Column Property: Datatype. |
<LENGTH> Element within <COLUMN> | AttrDef.Type=”AT_LEN_1” Attribute linked to the OneData column property: Length. Mandatory for columns of datatype Varchar and Char |
<DECIMAL_ DIGIT> Element within <COLUMN> | AttrDef.Type="AT_DEC_DIGIT" Optional attribute linked to the OneData column property, precision |
<DEFAULT_ VALUE> Element within <COLUMN> | AttrDef.Type="AT_DEFAULT_VALUE” Optional Attribute linked to the OneData Column Property: Default Value |
<IS_ NULLABLE> Element within <COLUMN> | AttrDef.Type="AT_OPT_ATTR" Optional Attribute linked to the OneData Column Property: Is Database Required? |
<LINKED_ OBJECT> Element within <COLUMN> or <CONSTRAINT> | ToObjDef.IdRef Unique Identifier specified in the ARIS AML file that links column or constraint to the table. Is Mandatory for Column and Constraints |