Sequences can be created in Luna Modeler as other objects and displayed as simple graphical representatives with custom colors.
Creating Oracle Database Sequences
To add a new type, click Other on the main toolbar and select Sequence from the drop-down.
Then click the diagram area to place a new graphical representative to the desired position.
In the right-side panel, on tab Details you can specify the Name and the Description for the Sequence. If you enable displaying descriptions in the diagram settings, the description will be displayed below the sequence graphics in your ERD.
Click the Script tab and define the code the sequence.
If you need a larger area for the code definition, double click the graphical object on the diagram to open a modal form.
Using Oracle Database Sequences
You can use the sequence when adding records to your database or set the default value to the sequence. Expand the area for column detail and set the value to the Default value field.
Using Identity Columns Instead of Oracle Sequences
In newer versions of Oracle database you can also use Identity columns instead of sequences. Define the identity column options in column detail:
#
