ThatJeffSmith

More on Classification Types in Oracle SQL Developer Data Modeler v4

We recently covered how to set the classification type of multiple tables in a data model, but today I want to show how to make these easier to identify in your model.

I’m also going to show you how to set multiple classification types for a single table – a new feature in v4 of the Modeler.

By default, the supplied classification types are assigned a color scheme:

And you can change the default colors

You can also change the default colors to fit your needs

If you need more classification types, you can add your own.

Mmmm, tables

Mmmm, tables

But Maybe You’re Color Blind?

Or maybe you just can’t remember the color coding schemes. You want the classification types to be more ‘in your face.’ Simple, in version 4 you can just right click in the diagram and toggle the classification types on for the ‘View Details’ to include the classification types.

Colors plus text to remind you what type of table you're working with.

Colors plus text to remind you what type of table you’re working with.

Still can’t see it?

A new title bar is added to the tables that have one or more classification types

A new title bar is added to the tables that have one or more classification types

But Maybe My Table Has More than One Role to Play?

In version 4 you can now also assign multiple classification types to a table.

Just move over as many classification types as makes sense...

Just move over as many classification types as makes sense…