Relationship - traffic light to show create + delete + sort options

Idea created by mrwatson-gbs on Nov 16, 2015
    Active
    Score13

    This is a duplicate of  TonyWhite 's idea Relationship Graph badges ...just with a traffic light theme.

     

    Idea

    It is exceedingly difficult to get an overview of create, delete and sort options in the relationship graph. A little traffic light to indicate the three options would be very easy and appealing

    • red - cascade delete
    • yellow - sort
    • green - create

     

    Example:

    RelationshipTrafficLight.png

     

    OK - so the "yellow" color needs changing - but you get the idea!

     

    Also desirable is a tooltip with details of the sort order.

     

     

    Benefits

     

    • Find erroneous relations quicker
    • Low impact / high information GUI artifact

     

     

    UseCases

     

    • Making databases ☺
    • Finding  cascading deletes (which can cause problems if the cascading delete is to an ESS table or invalid file)
    • Tuning database performance: Moving sorting off relations and onto portals, or creating non-sorted relations for faster processing