How to add Sequence Generator to a table in Oracle SQL Developer Data Modeler

Agenda:
  - Getting started with Oracle SQL developer Data modeler
  - How to create relational data model
  - How to add Sequence Generator to a table
  - Handling M:N relationships
  - How to create database view
  - Export the data model to DDL
  - Backup the modeling project
  - Create New Data Dictionary

Nowadays, most of the database design will use a running sequence number as the table's Primary Key instead of a code column, especially for compound key to reduce the complexity to reference to the table.

Thus, this post will show how to define a Sequence Generator for a table in Oracle SQL Developer Data Modeler.

Assumed that a table already created, with a number type column as the PK shown below.

Steps:
1. Open the Table Properties
    a) R-click on the table > properties OR d-click on the table
    b) Click on Columns node.

2. Open the Column Properties for the PK
    a) d-click on selected column

2. Configure for auto increment and sequence generator.
    a) in General node, check Auto Increment
    b) in Auto Increment node, enter Sequence Name
    c) click OK

Done!