Documentation

No results
    gitHub

    Attributes in entity boxes

    In Hackolade Studio, we use the generic name of "attribute" for an individual piece of information whose values identify, describe, or measure instances of an entity objects.  In physical data models, this attribute bears a different name depending on the target technology: column in relational and analytics databases, field in document and graph databases and also in Avro and REST APIs, etc...

     

    Create an attribute

    In Hackolade Studio, there are many ways to add an attribute to an entity in the central pane canvas:

    - menu : Action > Add Attribute (appended at the bottom of the entity)

    - keyboard shortcut (Ctrl/Cmd+R): appended at the bottom of the entity

    - toolbar: Add Attribute icon: appended at the bottom of the entity

    - Diagram Object pane: Add attribute via click (appended at the bottom of the entity)

    - Object Browser pane: right-click on entity name and use contextual menu (appended at the bottom of the entity)

    - Central pane: right-click on model name and use contextual menu (appended at the bottom of the entity)

     

    It is also possible to insert an attribute above the currently selected one.  And for complex data types (objects and arrays), it is possible to add "child" attributes.  For complex data types, it often found to be more convenient to maintain attributes in the hierarchical schema view.

     

    Move an attribute

    It is easy to modify the order of attributes.  This can be done in different ways:

    - to change the order of the attributes within a level, use the Move Up or Move Down icons in the toolbar: Toolbar field order up-down arrows

    - using the handle on the left of each attribute:

    ERD - attribute drag-and-drop

    you may move an attribute up or down within an entity, or to another entity, provided that there are no conflicts.  It is not possible to move attributes across different views.  By pressing the Ctrl/Cmd key+select the handle with the mouse, it is possible to perform a copy operation.

    Note that, if the handle does not show, you may enable its display through the Display Options icon in the toolbar or via Tools > Options > Display.