Database modeling does not have to be a dull, dreary activity. And on SqlDBM it is not! Thanks to the new Colors feature, your database diagrams come to life! But this is not just for aesthetics; different-colored parts of your model really does help you and your team to quickly distinguish different sections and objects, even in a relatively complex diagram. We explain below how to put this new feature to use to simplify your life.
1.Different colors for different schemas
The first way we have implemented color-coding is by simply having different colors for different schemas. This helps to quickly and easily identify and group tables by schema, especially if they are placed in separate parts of the board. By default, each table has a color indicator according to its schema.
And now you can also grandfather in this new feature for your older tables. Thanks to the Inherit button, you can apply a single color for all tables belonging to a schema. You also can override table color.
2.Mark a status
Some colors already have associated meaning which we are all accustomed to. In SqlDBM we also follow this widely-accepted construct, in line with our deeply ingrained ethos of making life easier for our users.
Here are some of the societal color conventions we recommend our users to follow in their SqlDbm models:
– Use yellow if you want to call attention to an object;
– Use grey to denote disabled or non-active objects;
– Use red to mark errors or issues that need to be fixed;
– Use green if everything is ok, or all issues have been fixed.
3.Mark types of tables
Pick out tables which don’t affect the model, like reference tables or those tables required by company standards. For this case use grey or violet color. Pay special attention to green and red colors since these are associated with very specific statuses. To avoid confusion for your team, try to use these only according to these widely-accepted conventions (such as an object marked red usually indicates it has some type of error that needs fixing).
4.Mark groups of tables
Yet another way to use color is for marking and identifying logical groups of objects using a common color indicator. For example, as shown in the animated screenshot below, all tables connected with a common address are then marked with a common color.
Simply select each table you want to include in the grouping, by clicking next to its name in the diagram. Then use the color bar that appears to color-code all of them with one color.
4.Use colored notes
You can also use colors for notes. You can implement this as a legend for coloring the tables or to highlight comments that the user should pay attention to.
Use the new color indicators to inject some variation into your database model and make it more understandable for you and your team.
So how do you apply colors? We would love to hear from you. Please share your suggestions in the Support portal. Your opinion is very important to us. After all, that is our main feedback mechanism as we strive to create the data-modeling tool of your dreams!